Jump to content
MakeWebGames

Recommended Posts

Posted

I am trying to get the name of the city the user is in to display at the top of the explore page, where it says: You begin exploring....

I have tried having:

You begin exploring {$r['cityname']}

 

but that didn't work. Do I need to have something at the top, like in viewuser.php, such as:

$q=$db->query("SELECT u.*,us.*,c.*,h.*,g.*,f.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid LEFT JOIN cities c ON u.location=c.cityid LEFT JOIN houses h ON u.maxwill=h.hWILL LEFT JOIN gangs g ON g.gangID=u.gang LEFT JOIN fedjail f ON f.fed_userid=u.userid WHERE u.userid={$_GET['u']}");

 

but only have:

$q=$db->query("SELECT c.* FROM users u LEFT JOIN cities c ON u.location=c.cityid WHERE u.userid={$_GET['u']}");

or something like that?

Cheers.

Guest Anonymous
Posted

Re: City Names

$db->query("SELECT c.* FROM users u LEFT JOIN cities c ON u.location=c.cityid WHERE u.userid={$ir['userid']}");

that may work.

Posted

Re: City Names

Look on the Submitted mods, I posted a Explore page thats shows the city name near the top, Take that bit out and put it in your explore page :/

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...