Change yourr code to place the sql into a variable and the echo the variable out to see what the problem might be. You can also cut'n'paste the variable into the the mysql gui of your choice to see if there are other errors


Subject: [PHP-DB] Problem with an update after an insert: MySQL
Date: Mon, 7 Feb 2005 11:31:52 EST

I'm having trouble with having trouble with doing an update after doing an
insert on and a select on a table. The order of execution is:

 $result = mysql_query("select token from  tokenuserid where  userid =
'$none' ");
if (!$result)
echo  mysql_error();

  $numresult = mysql_num_rows($result);
$row =  mysql_fetch_row($result);
$gotToken =  $row[0];

$generatedToken =  date(YmdHis);
$result = mysql_query("insert into tokenuserid  values ('$generatedToken',

  $result = mysql_query("update tokenUserid set userid = '$userid'  where
token = '$gotToken'");
if (!$result)
echo  "can't find user";

I can't get this update to take. Actually, I can get this to work on one
implementation of this database and on the next implementation of this it
doesn't work. returning the error after the update. The MySQL version is 3.23.52.
Is it because I have a capital U in the name tokenUserid in the update
statement? I could believe this as a reason since the table is defined as:
tokenuserid - (without any caps). If this is the problem then why does it occur in one
implementation and not the other?

-- PHP Database Mailing List ( To unsubscribe, visit:

Reply via email to