Re: Setting date fields in mysql queries

Hi, it's a great tip to install PhpMyAdmin - or phpPgAdmin for PostgresSQL - this will only take you at most half an hour even for a newcomer. You can then easily test queries, see any error messages and see what result they have on tables. In this case I'd echo out the query echo $query = "UPDATE countertable SET CurrDate = '$ndate' WHERE ID = $id" and try to cut-and-paste it into the query-field in PhpMyAdmin. When you say "nothing happens" you'd probably discover that ID is a number not matching anything _or_ that $nDate and the field are not proper date values ;-) Hope it helps! Frank, U5 ~~~~ PHP work! Looking for PHP work over the net? Or would like to try to work in South East Asia's most exiting place, Bangkok? Then jump to http://www.u5.com/ and fill out the Developers Form. We are urgently looking for new people in October 2002 ~~~~ At 15:16 2/10/2002 -0400, you wrote:

I have the following line in a program I'm working on: $query = "UPDATE countertable SET CurrDate = '$ndate' WHERE ID = $id" $ndate is a properly formated date read from a text field on a form on the previous page. When I run the query using mysql_query, it returns TRUE each time, but the field is not updated. The only explanation I can think of is that there is something wrong with the date value. I've echoed it to the screen and it looks fine, but the query still doesn't work. Any suggestions? Thanks in advance, Brad -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php