Monorail

[carlg]

ty for the help sorted now

[Guest Anonymous]

Re: Monorail

$eon = mysql_fetch_object(mysql_query("SELECT * FROM cities WHERE cityid = ".$r['location'].""));

echo "".$eon->cityname."";

Should work.

[carlg]

Re: Monorail

no i have tryed that lol but ty for your help

[_Eagle]

Re: Monorail

 

$eon = mysql_fetch_object(mysql_query("SELECT * FROM cities WHERE cityid = ".$r['location'].""));

echo "".$eon->cityname."";

Should work.

try changing the $r['location'] to $ir['location']. Should function fine then.

[carlg]

Re: Monorail

yes i have tryed this to please note that i am useing v2 codes

[YoungGold]

Re: Monorail

 

print " You are currently in: $ir['location']";

 

think that is right lol aint coded in a while and no-where to test as of this moment...

[carlg]

Re: Monorail

 

print " You are currently in: $ir['location']";

 

think that is right lol aint coded in a while and no-where to test as of this moment...

 

 

 

yer this was my first ider and all that comes up is the id of the city and not the name

[YoungGold]

Re: Monorail

 

print " [b]You are currently in: $ir['cityname'][b]";

 

try this

[Guest Anonymous]

Re: Monorail

EDIT:....

[carlg]

Re: Monorail

 

 

print " [b]You are currently in: $ir['cityname'][b]";

 

try this

 

nope nothing

[fbiss]

Re: Monorail

This should work for ya

 

$eon = mysql_fetch_array($db->query("SELECT * FROM cities WHERE cityid = '{$ir['location']}'"));
echo "{$eon['cityname']}";

[carlg]

Re: Monorail

 

This should work for ya

 

$eon = mysql_fetch_array($db->query("SELECT * FROM cities WHERE cityid = '{$ir['location']}'"));
echo "{$eon['cityname']}";

 

 

ty that worked ty