Can't get right results

ppatwari

I have a table called user where all the user information is stored. I
execute following command:

mysql> select counter from user where email='rhp';
+---------+
| counter |
+---------+
| 5 |
+---------+
1 row in set (0.00 sec)

While in PHP when I write:

$sql = "SELECT counter FROM user WHERE email='rhp';

$result = mysql_query($sql);
echo $result;

Resource id #2 - is printed. Why doesn't it print 5? How can I access that
value?

Thanks,

Parth

chriskl

You need to use mysql_fetch_result or whatever on the variable that is returned from mysql_query. RTFM.

Chris

adywarna

In your example, $result stores the result identifier for your mysql query. In order for you to extract the results, you need to fetch as array or object. This can be done:

$object = mysql_fetch_object($result);
echo $object->counter;

$array = mysql_fetch_array($result);
echo $array[0]; // or echo $array["counter"];