RE: [PHP] is there a more efficient query?
| From: | Jay Blanchard | Date: | Fri, 06 Aug 2004 16:25:01 +0000 |
| Subject: | RE: [PHP] is there a more efficient query? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-193008@lists.php.net to get a copy of this message | ||
[snip]
$query2 = "SELECT value FROM element_values WHERE element=48 AND
user=$user_id";
$result2 = mysql_query($query2) or die("could not $query2 " .
mysql_error());
list($username) = mysql_fetch_row($result2);
[/snip]
Tis SQL ....
SELECT value
FROM element_values
WHERE user = $user_id
AND(element=48
OR element=52
OR and so on....)