Row id's

NiXXeD

On my site www.nixxed.org, I have a picture uploading feature, so you can upload pictures. What I'd like to do (and I very well know that it should work) is have my upload successful page redirect the client to their newly uploaded photo. Currently what I had set was after I inserted the row into the database, I just had another select statement select the row out of the database and redirect accordingly. It has now all of a sudden stopped working. I was thinking that maybe because the insert just locked the row? Is there a way I can tell what the row id might be before I make the insert? Or is there a way to retrieve just the row that was inserted? I know my code is fine, I'm thinking I just missed some small technicality. Any ideas?

jburfield

You don't say what database you are using, but if you are using MySQL you can issue a 'SELECT last_insert_id()' statement to get the last id that was added to the table.

This is if your id is the primary key on the table.

-- Jason

NiXXeD

Yea, sorry, I am using MYSQL, so that's gonna be what I need... Thanks!

[deleted]

It stopped working means... you get an error? and if so, what is the error?

I assume you are using an auto_increment column, did you make sure to make that an INTEGER column, and not a TINYINT column? Tinyint has a range of -127 to 127, so after 127 inserts you run out if values for tinyint, and the whole thing stops.

NiXXeD

Actually, there are only like 20-some rows, so hopefully that didn't max anything out. Yes I am using the auto_increment feature. And the last post by jburfield solved my problem. I think it was the MYSQL problem where the rows are locked when you make an insert, so every time I made the insert, it wouldn't be able to pull the data from the table yet. The error was in php though, it would claim I had an invalid SQL resource... So it was rather misleading. Anyway, it works now, if you wanna check it out (if you're a skater) -> www.nixxed.org

[deleted]

MySQL does not lock anything at all, in fact, it does not even have those features.

"The error was in php though, it would claim I had an invalid SQL resource.."

That was due to a bad query, nothing at all to do with locking, you should print mysql_error() and see what the error was.