[RESOLVED] Need help with simple SQL query

[renova]

I'm trying to store the results of a simple query as a variable.

This query gives me the photoID number of the most recent photo I uploaded:

SELECT photoID FROM photos ORDER BY photoID DESC LIMIT 0, 1"

I want to then take that photoID number and insert it into another table with a few other values from a form. I've tried storing the result of the query above as a $variable and then trying to insert that $variable, but it doesn't work. How should I go about doing this?

Thanks for helping this very frustrated newby!

[laserlight]

This query gives me the photoID number of the most recent photo I uploaded:

Instead of using a query, you should be able to use a function ot get the id of the last row inserted. This would be more accurate due to possible race conditions and possible reuse of deleted ids.

What database API are you using?

[renova]

I'm using mySQL and php

[laserlight]

Okay, then right after inserting the photo, use [man]mysql_insert_id/man to get the photoID of the most recently inserted photo row.

[renova]

That did the trick laserlight! Thank you SO MUCH! I've been racking my brain for the last 4 hours trying to get this to work. I really appreciate your help 🙂

[laserlight]

You're welcome 🙂
Remember to mark this thread as resolved using the thread tools.