The Ace Posted May 30, 2008 Posted May 30, 2008 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. Quote
Guest Anonymous Posted May 30, 2008 Posted May 30, 2008 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. Quote
fbiss Posted May 30, 2008 Posted May 30, 2008 Re: City Names Instead of adding a query, first try to change that line to: You begin exploring {$ir['cityname']} Quote
The Ace Posted May 31, 2008 Author Posted May 31, 2008 Re: City Names No, that didn't work either...it just displayed: You begin exploring and see a bit that interests you. But thanks for trying! :) Quote
Joel Posted June 2, 2008 Posted June 2, 2008 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 :/ Quote
The Ace Posted June 3, 2008 Author Posted June 3, 2008 Re: City Names Thanks a lot Extermination! :o) Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.