Running multiple queries

[Smudly]

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

[Pikachu2000]

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.

[maxudaskin]

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