How to optimize this MySQL command?
| From: | Erick | Date: | Wed, 04 Jun 2003 12:12:04 +0000 |
| Subject: | How to optimize this MySQL command? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-150139@lists.php.net to get a copy of this message | ||
$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?