Resource id #9 and Similar Goofyness

[UCC]

Any time I try and retrieve a simple variable from a select query in my PHP I seem to get these Resource Id #s instead.

Heres a simple example. Surely there's something simple I'm missing. Thanks!

$loc=$db->query("SELECT cityname from cities WHERE cityid=$ir['location']");

print $loc;

[Decepti0n]

Re: Resource id #9 and Similar Goofyness

fetch it into an array first

$loc=$db->query("SELECT cityname from cities WHERE cityid=$ir['location']");

$array = mysql_fetch_assoc($array);

print $array['cityname'];

unless you have like $db->array

[UCC]

Re: Resource id #9 and Similar Goofyness

Thanks Deception. :-D