Would somebody look at this simple MySQL statement please?
Posted: Mon Sep 11, 2006 5:59 pm
I'm just getting into inserting data on a MySQL server from a PHP script and I can't see what's wrong with this update statement. Would someone mind pointing me in the right direction?
Running the script returns
Code: Select all
include_once("/var/www/html/php/db/logon.php");
mysql_connect($host, $user, $pass);
mysql_select_db($db);
$query = mysql_query("UPDATE * SET timeAdded='Null' WHERE timeAdded=''") or die("I'm back" .mysql_error());
echo "<br>Update sucess";Regards, StephenPHP Parse error: syntax error, unexpected T_STRING in /var/www/html/php/db/edit.php on line 10