Smudly Posted April 17, 2011 Share Posted April 17, 2011 I'm working on a Stats page that will need to run multiple queries to access the information needed to dislpay on the page. Rather than running 30+ queries to get the user's Stats, is there a better method? Any tips that you suggest I further research? Thanks Quote Link to comment https://forums.phpfreaks.com/topic/233983-running-multiple-queries/ Share on other sites More sharing options...
Pikachu2000 Posted April 17, 2011 Share Posted April 17, 2011 There may be a better method, but without seeing the code, db/table structures, sample data, expected results, etc., there's no way to tell for sure. Quote Link to comment https://forums.phpfreaks.com/topic/233983-running-multiple-queries/#findComment-1202627 Share on other sites More sharing options...
maxudaskin Posted April 17, 2011 Share Posted April 17, 2011 There may be a better method, but without seeing the code, db/table structures, sample data, expected results, etc., there's no way to tell for sure. +1 I'm taking a wild guess and assuming that all the information is in one database (each row is a user, and contains all of the information for that user). You can get multiple rows from a database with one query. See the following links: PHP MySQL Select - W3Schools MySQL Query Strings Tutorial - W3Schools Quote Link to comment https://forums.phpfreaks.com/topic/233983-running-multiple-queries/#findComment-1202640 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.