Resource ID #3 error

[kigroy]

I get the resource ID #3 error when I run this code:

 

In my header tags:

<?php
$conn = mysql_connect('dbname','username','password') or trigger_error("SQL", E_USER_ERROR);   
$db = mysql_select_db('tablename',$conn) or trigger_error("SQL", E_USER_ERROR);   

$name = mysql_real_escape_string($_GET['name']); //**from form submitted.  the form code works i doubled checked**//

$query = "SELECT column_name1 FROM column_name2 WHERE column_name2 = '$name'"; //** query works too, i tested in phpMyAdmin**//
$result = mysql_query($query, $conn);
?>

 

In my body tags:

<?PHP 
echo $result
?>

 

My server is WAMPSERVER 2.0 and my php running is 5.2.7.

 

Thoughts?

 

Thanks

[rhodesa]

you need to fetch a row from the result...

<?php
$conn = mysql_connect('dbname','username','password') or trigger_error("SQL", E_USER_ERROR);   
$db = mysql_select_db('tablename',$conn) or trigger_error("SQL", E_USER_ERROR);   

$name = mysql_real_escape_string($_GET['name']); //**from form submitted.  the form code works i doubled checked**//

$query = "SELECT column_name1 FROM column_name2 WHERE column_name2 = '$name'"; //** query works too, i tested in phpMyAdmin**//
$result = mysql_query($query, $conn);
$row = mysql_fetch_array($result);
?>

<?php
echo $row[0];
?>

[kigroy]

Thanks!  Worked like a charm. 

 

BTW, I'm a noob if you haven't figured it out.