[SOLVED] last sql query

[Guardian-Mage]

        $query2 = "SELECT shout_id FROM $database ORDER BY shout_id DESC";
        //The above query selects all shout entries and lists them in reverse
        //order so the newest ones are first
        $result2 = mysql_query($query2) //Executes the SQL Query
        or die("This script was unable to execute the SQL Query #2. Please
        contact the webmaster and inform them of the problem. Sorry for the
        inconvience.");

 

Now I need to take the last row from the above query and assign the value to the variable j

 

for example, the results come back like this:

755
754
753
752
751
...
$j = "755";

I would want $j to equal 755

[Dragen]

can't you just put a limit on the mysql query, so it only gives you the one result?

$query2 = "SELECT shout_id FROM $database ORDER BY shout_id DESC LIMIT 1";

[snowdog]

$query2 = "SELECT shout_id FROM $database ORDER BY shout_id DESC";

       //The above query selects all shout entries and lists them in reverse

       //order so the newest ones are first

       $result2 = mysql_query($query2) //Executes the SQL Query

       or die("This script was unable to execute the SQL Query #2. Please

       contact the webmaster and inform them of the problem. Sorry for the

       inconvience.");

 

$show = mysql_fetch_object($result2);

 

$j = $show->shout_id;

 

 

That should do it.

 

Snowdog