basic query driving me nuts

[aussiefly]

hey guys,

 

for some reason im getting a funny return from this query:

 

$query = mysql_query("SELECT `balance` FROM `members` WHERE userid = '415'");

echo $query;

 

now it just keeps echoing Resource #6. So I thought it was obviously a problem with my query...but when i go and run the query in phpmyadmin it brings up the result no problems.

 

Its freaking driving me nuts...ive been screwing with it for 2 hrs now.

 

Anyone know why ???

[awpti]

Because that's all it returns.

 

$data = mysql_fetch_assoc($query);

 

var_dump($data);

[DarkerAngel]

With what you have, Remove echo $query;

 

<?
$result = mysql_fetch_array($query);
print_r($result);
?>

[aussiefly]

Thanks everyone...i managed to get there with your help.

 

cheers

aussie