Find Row of Last Added Post!

Anon

I have users post comments and reviews on my website. I need to know how I can find out the rowid (its the row of the post auto incremented) right after its posted. Doing a count(*) does not work, cause it does not compensate for the rows deleted.

Does anyone what I can do?

Anon

Try using the mysql_fetch_row function.

IE:

$result = mysql_query("select * from your_table", $db);
$resultyouwant = mysql_fetch_row($result);

I think this might work. I'm a SERIOUS newbie though.

finger

this should work:

SELECT max(rowid) FROM comments;

regards

finger

sepodati

Use the mysql_insert_id() function...

$result = mysql_query("INSERT INTO your_table (name) VALUES ('John')");
$id_number = mysql_insert_id($LINK_ID);

Where $LINK_ID is what's returned from mysql_connect...

You can also find the number in your query. After the first insert above, to insert something into another table using the same id, you do this:

$result2 = mysql_query("INSERT INTO table2 (id,address) VALUES (LAST_INSERT_ID(),'123 Buffalo Street')");

Hope that helps...

---John Holmes...

Anon

Thanks for trying to help, but that didn't work.

Right now I have a select statement that searches for the row that was just inserted with the varibles from the form that were actually use to store the row in the first place:

$row1 = mysql_query("SELECT ROWID from commentnews where NAME LIKE \"%$name%\" AND EMAIL LIKE \"%$email%\" AND BODY LIKE \"%$body%\" AND KEYTONEWS LIKE \"%$id%\" AND TIME LIKE \"%$time%\" AND DATE LIKE \"%$date%\"");

$row2= mysql_fetch_array($row1);

echo $row2[0];

I know this is not the best way to do this!

Please someone help!

Anon

whoops didnt see your guys posts

THanks ALOT!

Anon

There is a function in php used to get the last row id of an insert.
I think is called mysql_insert_id()
or something like that.

if U do a :
$query=mysql_query("INSERT ... ");
$id=mysql_insert_id(); / No arguments /

then $id will get the id of the last INSERT query.