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

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 =

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 th

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