[SOLVED] UPDATE lowest id

[GetYourArse]

Ok how do i update a row with the lowest id? is this correct or is there a better way?

 

UPDATE table SET title = '$utitle' WHERE id = (SELECT id FROM table ORDER BY id ASC LIMIT 1)

[Wildbug]

That's fine.  Unless your implementation doesn't support subqueries. 

[GetYourArse]

i got this error

 

You can't specify target table 'mytable' for update in FROM clause

[Wildbug]

Ah!  *Smacks forehead*  That's right.  I've read that but didn't remember.

 

From MySQL manual:  "Currently, you cannot update a table and select from the same table in a subquery."

 

You'll have to use two seperate queries.  Either save it in a PHP variable or in a MySQL session variable.

[Wildbug]

Or you might be able to do it as follows (untested):

UPDATE table SET title = '$utitle' ORDER BY id ASC LIMIT 1

[GetYourArse]

thanks didn't know that will be so simple