how do i get the highest value present in a row?
MAX().
Look up the usage in the manual; it is fairly easy to search and should have been the first thing you did. I assure you typing up your post took longer than looking it up would have.:rolleyes:
thanks for not being a dick about sheesh
that diddnt work, here is how I am using it
mysql_query("SELECT max(newsorder) FROM news") or die("Couldn't ececute query.");