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
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
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
[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
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 =
5 matches
Mail list logo