How to automatically read a product ID?

[crazylegseddie]

Little problem I hope someone can help me with. I currently use the following code to display specific details using the product ID as shown below

<?php
					require_once 'library/config2.php';
					$result = mysql_query('SELECT pd_more FROM tbl_product WHERE pd_id =1') or exit(mysql_error()); 
					$row = mysql_fetch_assoc($result); 
					echo $row['pd_more'] = nl2br($row['pd_more']); 
					?> 

Everytime I enter a new product the ID obviously increases. At the moment I have the information pointing at ID number 1. How can I edit this script so it automatically reads the latest/last ID number?

Been trying sources over internet but cannot find anything useful so any help will be good. Thx

[bogu]

SELECT max(ID) FROM table

[crazylegseddie]

thx for putting me on the right track. The final answer was the following:

SELECT pd_more, MAX(pd_id) FROM tbl_product GROUP BY pd_id desc limit 1