RE: [PHP] How to optimize this MySQL command?

Wouldn't it be easier to "SELECT * from bt_member WHERE ch='$ch' && id='$result[mid]',$db); //I'm not sure of the exact syntax there since I'm a newbie, but wouldn't it be easier to do that and then do a pulling of the fields that you want? //ie... while ($result = mysql_fetch_object($resultb)){ print "<TR>\n"; print "<td width=90 valign=\"top\">$row->id</td>\n"; print "<td width=90 valign=\"top\">$row->mid</td>\n"; print "<td valign=\"top\">$row->nick</td>\n"; print "</tr>\n"; } print "</Table>\n"; print "</Center>\n"; I took this from an example that I have now for something similar, it uses fetch_object, you could still use fetch_array, and just use a $row['id'] or something too. Good luck with this, maybe someone who knows correct syntax could clean this up a bit. I guess my opinion is that it slows the processor down having to pull only certain fields from the database compared to just pulling all of them from a certain table. Most tables shouldn't be that big, if they are you should be using primary keys and making other tables that is the point of a relational database. ;) You can always join tables in the end. (ramblin again!!, sigh) Best of luck, David -----Original Message----- From: Erick [mailto:webmaster@pczonehk.com] Sent: Wednesday, June 04, 2003 7:12 AM To: php-general@lists.php.net Subject: [PHP] How to optimize this MySQL command? $resultb = mysql_query("SELECT id,mid FROM bt_message where ch='$ch' ",$db); while ($result = mysql_fetch_array($resultb)) { $result2b = mysql_query("SELECT nick FROM bt_member where id ='$result[mid]' ",$db); $result2 = mysql_fetch_array($result2b); ......... } Can combine together? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php