Re: [PHP] Setting date fields in mysql queries

2002-10-03 Thread Brad Harriger
I ran the query in PhpMyAdmin. It work fine. It still doesn't work when I try to run it in another script. Frank wrote: 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

[PHP] Setting date fields in mysql queries

2002-10-02 Thread Brad Harriger
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

RE: [PHP] Setting date fields in mysql queries

2002-10-02 Thread Matt Schroebel
From: Brad Harriger [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 3:17 PM Subject: [PHP] Setting date fields in mysql queries I have the following line in a program I'm working on: $query = UPDATE countertable SET CurrDate = '$ndate' WHERE ID = $id $ndate

RE: [PHP] Setting date fields in mysql queries

2002-10-02 Thread Jay Blanchard
[snip] 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

Re: [PHP] Setting date fields in mysql queries

2002-10-02 Thread Frank
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 =