[aprogrammer]

here's my code

PHP Code:

$sql="SELECT count(customerid) as countcustomer from customer";

echo $sql;

$result = mysql_query($sql) or die(mysql_error()); 

echo "Total:";

echo $result[0]; 

The result prints out total: and blank -- no number ---
if i run the same query from php my admin I get the number of records.
Waht am I doing wrong?

[darkfreak]

Variable $result is just a pointer to your query results. You must use that pointer to pick up your actual result row with - for example - mysql_fetch_row($result) -function.

PHP Code:

$sql="SELECT count(customerid) as countcustomer from customer";

echo $sql;

$result = mysql_query($sql) or die(mysql_error()); 

$row = mysql_fetch_row($result);

echo "Total:";

echo $row[0];