stuck on a problem . . .

[davez]

Hello world!

            It been a week now, I try to make a code to display the total number of users on my home page.

            I almost succeeded, but I am stuck on a problem.

            The code displays all the 'ID' on the page, and I want only the last 'ID'

 

            Here is the code:

 

 

<?

session_start();

include "config.php";

global $c,$loggedin;

include "data.php";

global $config;

include "funciones.php";

?>

<?

$tabla = mysql_query("SELECT id FROM tb_users");

while ($registro = mysql_fetch_array($tabla))

 

echo "

". $registro["id"] .""

?>

 

 

          Thank You!

          davez

[MasterACE14]

$tabla = mysql_query("SELECT id FROM tb_users LIMIT 1");

?

[davez]

Almost!

 

Now I have the first 'ID' of my list, but I need the last 'ID'

 

Thank You very much!

 

:-)

[MasterACE14]

this should do the trick...

$tabla = mysql_query("SELECT id FROM tb_users ORDER BY id DESC LIMIT 1"); // orders the results by the 'id' field in descending order

[davez]

wow..loll

                Thank You very much, this is very appreciate !!!

                My problem is solved !

 

ThX!

 

:-D