Retrieving data from tbl (problem)

[yoda]

hi, i got this

mysql_db_query($dbname,"SELECT wood from gamerecource");

I want to get back the default value, but instead i get back 'Resource id #2', i don't have a clue what it means all i really need is the code to get the default value back from the tbl instead of the weird 'Recource id #2'

please help me

[Husain]

The default value returned by mysql_db_query IS a resource ID. To get values from the table you need to write some more codes:

$ResultID = mysql_db_query($dbname, 'SELECT wood FROM gamerecource');

$Record = mysql_fetch_array($ResultID); // Assuming that there is only one record in the database.

echo($Record['wood']); 

[yoda]

hmmz, i used it and now i have:

$ResultID = mysql_db_query($dbname, 'SELECT wood FROM gamerecource'); 

$countwood2 = mysql_fetch_array($ResultID); 

but now i get:

Fatal error: Unsupported operand types in /home/virtual/site99/fst/var/www/html/test/buildings/lumbermill.php on line 46

im totally sure it has to do with $countwood2 = mysql_fetch_array($ResultID); , but i don't excactly know what's wrong