How to find different things from a MySQL database.

[god0fgod]

I have a code that places some data into a MySQL database table. The first field is an auto increment interval. How can I find the highest interval in this feild from php so I can use the ID in the code as well. Also how can I select a row from the table with the ID I want using the id.

I'm very new to this. Thanks.

Also you may want to know why I want to know:

mysql_connect("localhost","root","********");
@mysql_select_db(subbmission) or die( "There has been an error in your request. Please try again! Error: Unable to select database.");
$query="INSERT INTO pending VALUES ('','$title','$email','$date','$article','$General','$Funny','$Help','$Quiz','$Chat','$Game')";
$result = mysql_query($query);
mysql_close();

if($result){
$subject = "New article submission - " . $title;
$body = "Below is a new article. visit <a herf=\"http://www.godofgod.co.uk/newssub/newsapprove.php?id=" . $id . "\"></a>" . $article . $General . $Funny . $Help . $Quiz . $Chat . $Game;
mail('[e-mail]',$subject,$body,"From: $email\n");

See I need the ID for another script I will make and I will need to know how to use the ID with the new script.

[Scriptmaker]

Select:
http://www.w3schools.com/php/php_mysql_select.asp

in your case, something like

SELECT * FROM pending WHERE id=$id

would work, after setting the $id variable.

To get the highest id number, read up on the SORT BY feature of SELECT. Then sort by id, descending, and then add LIMIT 1 to make it only grab the row with the highest id.

But, just a little tidbit in case the real reason you want the highest number is to find the last inserted entry:
http://www.php.net/mysql_insert_id

Can post some code if you need it, but if you just read through the examples, you'll see it's not much diff. than the code you already provided.

Good luck!

[Gallagher]

Highest ID:

SELECT MAX(id) FROM pending;

mysql_insert_id() provides the id generated from the last INSERT, but it won't help you if you didn't INSERT a record.

[god0fgod]

Thanks for both of the answers they will come in useful.