Re: [PHP-DB] Problem with an update after an insert: MySQL

2005-02-07 Thread Bestman4unowwa
Bastien, Thanks for your help!. I think I found the answer to my problem. My system is a windows based system and it is not windows based. The system where the code doesn't work is Unix and is case sensitive. I went online to the mysql reference and found this link, _http://dev.mysql.com/

RE: [PHP-DB] Problem with an update after an insert: MySQL

2005-02-07 Thread Bastien Koert
ject: [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 wh

[PHP-DB] Problem with an update after an insert: MySQL

2005-02-07 Thread Bestman4unowwa
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