RE: [PHP-DB] Data not fetching in the textfield.

2007-09-26 Thread Naintara
Try replacing this: echo ' input name=storename type=text maxlength=35 id=storename class=regForm disabled=disabled value=$rows[0]/input' ; With this: echo ' input name=storename type=text maxlength=35 id=storename class=regForm

RE: [PHP-DB] How to capture from session and match database

2007-09-23 Thread Naintara
if you have a value in your email session variable. ? Naintara -Original Message- From: Chris Carter [mailto:[EMAIL PROTECTED] Sent: Sunday, September 23, 2007 9:59 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] How to capture from session and match database Hi Naintara, thanks

RE: [PHP-DB] Notice: A non well formed numeric value encountered

2007-09-22 Thread Naintara
I don't see the NOTICE message. Perhaps a timezone notice? Lookup the date() function in the php manual. The time parameter should be a unix timestamp value, so $CTS should contain an integer value. You can also find ways to convert the time value you have to unix timestamp, in the manual.

RE: [PHP-DB] Pages not fully loading

2007-09-22 Thread Naintara
Perhaps a faulty mod_rewrite rule or pages/folder setup. You'll need someone to look at your setup and mod_rewrite rules or if you want to read up on it http://httpd.apache.org/docs/1.3/mod/mod_rewrite.html -Original Message- From: ioannes [mailto:[EMAIL PROTECTED] Sent: Saturday,

RE: [PHP-DB] Notice: A non well formed numeric value encountered

2007-09-22 Thread Naintara
- From: Stephen Sunderlin [mailto:[EMAIL PROTECTED] Sent: Saturday, September 22, 2007 9:24 PM To: 'Naintara'; 'PHP-DB Mailing List' Subject: RE: [PHP-DB] Notice: A non well formed numeric value encountered Thank you for your response. The notice is in the Subject Line of the email: Notice

FW: [PHP-DB] Notice: A non well formed numeric value encountered

2007-09-22 Thread Naintara
Hi again Stephen, Further on my previous post, if you do store the UNIX timestamp as an integer value, it should be very efficient, database storage and query speed, plus giving you ease and flexibility in formatting via php. -Original Message- From: Naintara [mailto:[EMAIL PROTECTED

RE: [PHP-DB] Notice: A non well formed numeric value encountered

2007-09-22 Thread Naintara
(contact_created_date, '%M %d, %Y'); =September 22, 2007 Where contact_created_date is your field. -Original Message- From: Stephen Sunderlin [mailto:[EMAIL PROTECTED] Sent: Saturday, September 22, 2007 10:38 PM To: 'Naintara'; 'PHP-DB Mailing List' Subject: RE: [PHP-DB] Notice: A non well formed numeric

RE: [PHP-DB] Notice: A non well formed numeric value encountered

2007-09-22 Thread Naintara
' This isn't the same as the unix timestamp integer value. -Original Message- From: Stephen Sunderlin [mailto:[EMAIL PROTECTED] Sent: Saturday, September 22, 2007 11:27 PM To: 'Naintara' Cc: 'PHP-DB Mailing List' Subject: RE: [PHP-DB] Notice: A non well formed numeric value encountered Naintara

RE: [PHP-DB] How to capture from session and match database

2007-09-19 Thread Naintara
Hi, First of all, where you are storing the session variable, it should be specified as: $_SESSION['email'] = 'email value' //PHP 4.1.0 onwards This is preferred to registering global variables. There's a whole lot of discussion on why. On the pages you are authenticating, you would

RE: [PHP-DB] Form processing

2007-09-13 Thread Naintara
You could look up the PHP function get_magic_quotes_gpc() When a form is posted, you could do a check like this: if ( get_magic_quotes_gpc() ) { //where $subject contains the subject string and $newsubject is what you use for the mail $newsubject = stripslashes ($subject); }

RE: [PHP-DB] Order By [blank]

2006-12-21 Thread Naintara
Depending on your MySQL version you could use a subquery by combining the two queries you mentioned, for a fairly straight-forward query. http://dev.mysql.com/tech-resources/articles/4.1/subqueries.html http://mysqld.active-venture.com/Subqueries.html You could read about optimizing subqueries

RE: [PHP-DB] Direct Access to an Array Item?

2006-09-03 Thread Naintara
Perhaps you could elaborate on the exact motive Say, why would you be checking against the 4th element of an array. I could understand why you would want to check every element of an array against a particular value, but why just the 4th element, just for interest. In response to your question,

[PHP-DB] storing unicode characters in mysql database

2006-01-30 Thread Naintara
Hi, I'd like to know what would be the best way to store Unicode text in a database. I am using MySQL 4.1. I am trying to create a multi-lingual CMS and the browser charset is set to utf-8 and the database and tables are set to UTF8 and utf8_bin for charset and collation. While displaying in the