MySQL query returns resource id

[favian]

Hi. I'm a little confused because when I execute the following script:

$query = "SELECT fielda FROM fieldb WHERE name='ABC'";
if (!$result = mysql_query($query, $link))
exit("Illegal query");
// Display the results of the query in a table
print "$result";

I get the printout:

Resource id #3

when I'm supposed to get the value which I queried from the table.

Can someone tell me what's going on and how I can get the value from 'fielda' to be printed out? Thanks.

[cahva]

When query is succesfull, use for example mysql_fetch_array($result) to fetch the rows.

$query = "SELECT fielda FROM fieldb WHERE name='ABC'";
if (!$result = mysql_query($query, $link))
	exit("Illegal query");

// Display the results of the query in a table
while($row = mysql_fetch_array($result)) {
	echo $row['fielda'].'<br>';
}