Php connections with mysql tables

[MemphiS]

Just a general question.  Currently my site mysql has 40 tables in it.  Whats the max i can go to without any problems?  Whats the best way to grab the data using php?

 

Thanks.

[unkwntech]

I have never hit a 'hard' or 'soft' limits some databases have had hundreds of tables, some of which had hundreds of columns.

As to grabbing data NEVER NEVER NEVER use "SELECT *"... unless you have to.

If you don't need every column don't ask for it, be specific if you only need 2 pieces of data, request them "SELECT col1, col2".

Minimize the number of queries, and the number of connections as much as possible.

If you can, request the data once and store it either in a cookie or a session.

[MemphiS]

hmm thanks 

 

i usualyl grab the data using this method:

 

$getData = mysql_query("SELECT `member` , `data1` , `data2` FROM `table`");

$getD = mysql_fetch_row($getData);

 

echo "data requested: $getD[0] - $getD[1] - $getD[2] ";