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',
'$none')");
$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?
