accessing resource

[rpjd]

If $result contains the result of mysql_query, a select count distinct query, how do I access the count?  I've tried $result[0] to no avail and $result only returns the resource #.

[Adam]

You need to use one of the fetch functions (mysql_fetch_array, mysql_fetch_assoc, ...) The resource only contains a reference to the data on the MySQL server.

[vicodin]

you need to use:

 

$row = mysql_fetch_array($result);

echo $row['Your_Column_name_here'];