Re: [PHP-DB] Page refresh question

2005-06-10 Thread mihaifrisan
i think that the best solution is to use XMLHttpRequest mihai ps. i don't think is a good idea to save the shopping cart in a cookie on client side (i can alter, as a client, the prices from shopping cart) Han wrote: Hi, I can think of 2 solutions: 1 is an old one I used ages ago, and

[PHP-DB] Re: Subject: Creating an Associative Array

2005-06-10 Thread dpgirago
Thank you kindly, Neil Smith and Brent Baisley. I now see the error of my approach. --- $dateArray = array(); for($counter = 0; $counter = 3600; $counter++) { $dateArray[

Re: [PHP-DB] Page refresh question

2005-06-10 Thread han
Hi, I can think of 2 solutions: 1 is an old one I used ages ago, and it was to use javascript to put their choices (onclick, field.value=£3 type of thing) and when they click the OK button it gets sent to php script that sends it to mysql, etc. 2 is pretty much the same but using cookies with

[PHP-DB] Re: Subject: Creating an Associative Array

2005-06-10 Thread dpgirago
Thank you kindly, Neil Smith and Brent Baisley. I now see the error of my approach. --- $dateArray = array(); for($counter = 0; $counter = 3600; $counter++) { $dateArray[

Re: [PHP-DB] Page refresh question

2005-06-10 Thread mihaifrisan
i think that the best solution is to use XMLHttpRequest mihai ps. i don't think is a good idea to save the shopping cart in a cookie on client side (i can alter, as a client, the prices from shopping cart) Han wrote: Hi, I can think of 2 solutions: 1 is an old one I used ages ago, and

Re: [PHP-DB] Page refresh question

2005-06-10 Thread han
Hi, I can think of 2 solutions: 1 is an old one I used ages ago, and it was to use javascript to put their choices (onclick, field.value=£3 type of thing) and when they click the OK button it gets sent to php script that sends it to mysql, etc. 2 is pretty much the same but using cookies with

[PHP-DB] Issue with date() function...

2005-06-10 Thread Chase
I have a variable: $rec2day = date(Y-m-d); that displays correctly when echoed to the screen, but when I write it to my DB, I get the mathmatical answer to the equasion (1989 (2005-06-10)). What do I need to do to correct this?? TIA -- PHP Database Mailing List (http://www.php.net/) To

RE: [PHP-DB] Issue with date() function...

2005-06-10 Thread Bastien Koert
show your code...is the field set as a time field or what? bastien From: Chase [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Issue with date() function... Date: Fri, 10 Jun 2005 10:01:16 -0600 I have a variable: $rec2day = date(Y-m-d); that displays correctly when echoed to

Re: [PHP-DB] Issue with date() function...

2005-06-10 Thread Bruno Ferreira
Chase wrote: I have a variable: $rec2day = date(Y-m-d); that displays correctly when echoed to the screen, but when I write it to my DB, I get the mathmatical answer to the equasion (1989 (2005-06-10)). What do I need to do to correct this?? Just use $rec2day= date(Y/m/d); You

Re: [PHP-DB] Issue with date() function...

2005-06-10 Thread Chase
I made that modification and now it doesn't update the DB at all... Here is the code that I am using to insert that variable into my MySQL DB... Again, my variable is defined as $rec2day = date(Y-m-d) OR $rec2day = date(Y/m/d) ?php $connection = @mysql_connect($server, $user, $pass) or

Re: [PHP-DB] Issue with date() function...

2005-06-10 Thread Chris
Well, without seeing your query (it's much more likely some will be able and willing to help you the more information you give) It appears that you aren't surrounding the date in quotes? So it is being parsed as the expression 2005 (minus) 6 (minus) 10 Instead of seeing it as the string

Re: [PHP-DB] Issue with date() function...

2005-06-10 Thread Bastien Koert
need the quotes around the date $sql = UPDATE $table1 SET last_access_date='$rec2day' WHERE username='$dealer_number' AND password='$password'; bastien From: Chase [EMAIL PROTECTED] To: php-db@lists.php.net Subject: Re: [PHP-DB] Issue with date() function... Date: Fri, 10 Jun 2005 10:52:16