Count(*)

[rIkLuNd]

How do I print the result from this query?

$sql = "SELECT COUNT(*) as total FROM table";
$result = mysql_query($sql);

[nnichols]

Try this -

$sql = "SELECT COUNT(*) as total FROM table";

// should always have some form of error handling when you run a query
$result = @mysql_query($sql) or die('MySQL error: '.mysql_error().'<br>Query: '.$sql);

$row = mysql_fetch_row($result);
echo 'Total rows - ' . $row[0];

Hope this helps 😉

[rIkLuNd]

yeah, I solved it like this:

// by the way, I've got a query function with built in error
// reporting so that I can change the error mes´sage for all queries... =)

$sql = "SELECT COUNT(*) as total FROM table";
$result = sql_query($sql);
$data = mysql_fetch_object($result);

echo $data->total;

but thanks for the reply!