thanks olexandr my posting had a misprint. the select should be on "mytable" not "user", so when i use your suggestion, i get an error:
mysql> update test set id = (select max(id) + 1 from test) where id = '$myid'; ERROR 1093 (HY000): You can't specify target table 'test' for update in FROM clause so how does one make a row id to appear as a newly inserted row, without doing multiple queries? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]