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?

Reply via email to