Putting mysql row count to use.

[tjmbc]

Here's my code so far:

 

$query = "SELECT COUNT(*) FROM table";

$result = mysql_query($query);

 

How do I display the result on my page?

[revraz]

use AS with count.

[phpSensei]

<?php

$query = "SELECT COUNT(*) as phpsensei FROM table";
$result = mysql_query($query);

 while($row = mysql_fetch_object($query)){


     echo $row->phpsensei;


 }

?>

 

or

 

<?php

$query = "SELECT COUNT(*) as phpsensei FROM table";
$result = mysql_query($query);

 while($row = mysql_fetch_array($query)){


     echo $row[phpsensei];

 }

?>

 

 

[moselkady]

 

Your result will contain the number of rows in table. So to display this number, just add these 2 lines:

 

$row = mysql_fetch_array($result);
echo $row[0];