Andy-H Posted November 16, 2009 Share Posted November 16, 2009 I assume the problem was the $world variable appended to the table names in your query. What was that for?? Quote Link to comment https://forums.phpfreaks.com/topic/181482-solved-join-3-tables/page/2/#findComment-958678 Share on other sites More sharing options...
kickstart Posted November 16, 2009 Share Posted November 16, 2009 Hi Presuming you have seperate tables suffixed with the world number then from your table declarations on the previous page player9.ally should be there. Check the table declarations. All the best Keith Quote Link to comment https://forums.phpfreaks.com/topic/181482-solved-join-3-tables/page/2/#findComment-958679 Share on other sites More sharing options...
RichardRotterdam Posted November 16, 2009 Share Posted November 16, 2009 edit nvm Quote Link to comment https://forums.phpfreaks.com/topic/181482-solved-join-3-tables/page/2/#findComment-958697 Share on other sites More sharing options...
sp@rky13 Posted November 17, 2009 Author Share Posted November 17, 2009 I swapped the $world's with the 9 already and the decleration is fine I'm pretty sure Quote Link to comment https://forums.phpfreaks.com/topic/181482-solved-join-3-tables/page/2/#findComment-958958 Share on other sites More sharing options...
kickstart Posted November 17, 2009 Share Posted November 17, 2009 Hi Try the SQL directly against the database in phpmyadmin (or equivalent). All the best Keith Quote Link to comment https://forums.phpfreaks.com/topic/181482-solved-join-3-tables/page/2/#findComment-959022 Share on other sites More sharing options...
sp@rky13 Posted November 17, 2009 Author Share Posted November 17, 2009 It works fine in the php my admin so yah, i don't know what the issue is Quote Link to comment https://forums.phpfreaks.com/topic/181482-solved-join-3-tables/page/2/#findComment-959028 Share on other sites More sharing options...
kickstart Posted November 17, 2009 Share Posted November 17, 2009 Hi That is confuing. Only thing I can think of is that possibly you are not connecting to the same database? All the best Keith Quote Link to comment https://forums.phpfreaks.com/topic/181482-solved-join-3-tables/page/2/#findComment-959048 Share on other sites More sharing options...
sp@rky13 Posted November 17, 2009 Author Share Posted November 17, 2009 That is true. I'mnot. It contains simalar data but I'm not connecting to the same database for the one I'm uploading as I'm using someone elses database though I have a database I can test on which is what I checked. I'll go query my database EDIT: My database worked fine though the other one still isn't working . You guys probably can't help me anymore. Thanks heaps though for all the help and sorry about my stupidity Quote Link to comment https://forums.phpfreaks.com/topic/181482-solved-join-3-tables/page/2/#findComment-959051 Share on other sites More sharing options...
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.