[RESOLVED] Getting most recent ID

Neko_D

So I have a database, in this database I have two tables, items and pasts. In the pasts table I have a reference to the ID in the items table.

So I have a PHP script that needs to enter a past when and item is entered. So my question is, is there an sql query that will help me get the most recent item entries ID? I do not have timestamps on either table. I just want to pull out the id, is there anyway to do this?

Stryker250


$query = "SELECT * FROM items, pasts ORDER BY items.id DESC, pasts.id DESC LIMIT 10";
$result = mysql_query($query) or die(mysql_error());

while($info = mysql_fetch_array($result)){
echo "ID : ".$info['id']."<br />\n";
}

Not sure if that is what you are looking for

dougal85

mysql_insert_id

Neko_D

dougal85 wrote:
mysql_insert_id

Thanks that works just like I want it too. Are there any PHP functions for retreiving the last primary key if the primary key is not an int?

MarkR

If the primary key isn't an int, you can't have mysql automatically insert it**

Therefore you must have manually specified it, so you can simply use the value that you specified for it.

Mark

** Unless you're using a trigger or something else funky.

Neko_D

MarkR wrote:
If the primary key isn't an int, you can't have mysql automatically insert it**

Therefore you must have manually specified it, so you can simply use the value that you specified for it.

Mark

** Unless you're using a trigger or something else funky.

Oh right, my is my face red now. I was kind of tired at the time I made this post.