Query Returning Resource ID #57

[Anon]

I'm trying to do a query on a MySQL database that is just a straight select statement and I keep getting returned "Resource ID #57" or one time I got "Resource ID #51".

Any thoughts on this as I can't find it by doing a search anywhere.

Thanks,

Josh

[lecon]

/Suppose we have a table named "test" with two fields - "Name" AND "Password"/
$query="select * from test";
$result=mysql_Query($query);
$rs=mysql_fetch_array($result);
echo $rs["Name"];
echo $rs["Password"];

[kparker]

The query's supposed to return a resource ID if it succeeds. You need to use that ID with a fetch function of some kind to retrieve the actual data.