Displaying a Row Value

[Ghost_81st]

$query = "SELECT Yes FROM IngameAI";  $result = mysql_query($query) or die("Query failed : " . mysql_error()); 
 // Printing results in HTML  

echo "$result";

That is what I have so far, I use PHP admin, and the value for "Yes" is 1 right now, I am going to be making a counter-ish type thing with it later. but for now I woud like to know why all id does is say "Resource id #3" instead of 1.

I know, this has probably been asked before, but I am still unsure.

[gufmn]

Yes, it has been asked before.
See this

Edit: Bad link should be fixed 🙂

[Ghost_81st]

that link isnt correct really.. so yea, I looked.. still dont see how it works with this:

// Performing SQL query
$query = "SELECT Yes FROM IngameAI";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
$num = mysql_fetch_array($result);
// Printing results in HTML
echo $result['$num'];
// Closing connection
mysql_close($link);

Instead of Resource id #3, I get blankness.

[gufmn]

it would be:

echo $num['collum_name'];