Jump to content
MakeWebGames

Resource id #9 and Similar Goofyness


Recommended Posts

Posted

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;

Posted

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...