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

[Sunil Samuel]

This is actually more an sql questions. ;-)  Take a look at Joins in 
sql.  Should be something like the following:

SELECT mesg.id, mesg.mid, memb.nick
FROM bt_message mesg,  bt_member memb
WHERE mesg.ch='$ch' AND memb.id=mesg.mid
Erick wrote:

$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