[RESOLVED] SQL Query

[Springles]

Hi I treid both:

SELECT id FROM user_time ORDER BY O_Id DESC LIMIT 1

&

SELECT LAST(id) AS LastID FROM user_time

SQL says ther is a syntax error.

[AL-Kateb]

the first query looks fine, though the second has this LAST function, which i don't think exist in MYSQL.

please post your table structure cos the first query looks just fine.

[Springles]

Got his fixed already.

[bradgrafelman]

Out of curiosity, can you explain why you are trying to find the last 'id' value in the table in this manner?

[Springles]

so I can insert a new incremental ID which I can also store as a var to update the sql line.

[bradgrafelman]

Ah, that's what I was afraid of.

What you're doing, then, is vulnerable to a race condition since the next ID value could change between the time you retrieve it and the time you actually use it. I don't know what your specific application is, but a better method would be to simply insert the new data and retrieve the ID value it was assigned (not by doing a SELECT query).

[Springles]

bradgrafelman;10976087 wrote:

(not by doing a SELECT query).

If not by SELECT then by what ?

[bradgrafelman]

That would depend upon which library you're using to access the DB (e.g. mysql, mysqli, PDO, etc.), but each should have their own way of returning that information, such as [man]mysql_insert_id/man.