Posted by Alexey Kulentsov on 05/18/07 00:05

Akhenaten wrote:
> function respond_check($qid)
> {
> include "db.inc.php";
> $postchk2 = mysql_query("SELECT * FROM `answers` , `users` WHERE `qid`
> = $qid AND `a_uid` = `userid` LIMIT 0, 30",$db);
> while ($userx=mysql_fetch_array($postchk2))
> {
> if (in_array($username, $userx)) {
> echo "Got It!";
> }
> }
> }

Never use PHP to do MySQL work.
Select only data you need. Something like this.

$sql="SELECT * FROM answers INNER JOIN users ON a_uid=userid WHERE
qid=$qid AND username IN (".implode(',',$quotedUserNamesArray).")";

[Back to original message]