Hi Brian,
Assuming you have mysql 4.0.0 or up, I think the following query should do you:
$query2 = "(SELECT value FROM element_values WHERE element=48 AND user=$user_id)
UNION (SELECT value FROM element_values WHERE element=49 AND user=$user_id)
UNION (SELECT value FROM element_values WHERE element=50 AND user=$user_id)
UNION (SELECT value FROM element_values WHERE element=51 AND user=$user_id)
UNION (SELECT value FROM element_values WHERE element=52 AND user=$user_id)
UNION (SELECT value FROM element_values WHERE element=53 AND user=$user_id)
$result2 = mysql_query($query2) or die("could not $query2 " . mysql_error());
hth,
James
-----Original Message-----
From: Brian Tully [mailto:[EMAIL PROTECTED]
Sent: 06 August 2004 17:15
To: PHP
Subject: [PHP] is there a more efficient query?
i currently have to query a table for 5 separate values based on elementid
and haven't figured out how to do it using just one query with an array or
associative array.
can someone enlighten me as to how I could perform the following queries
more efficiently, i.e., is there a way to do it with one query instead of
five?
thanks a bunch in advance,
brian
code:
<?php
$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);
$query3 = "SELECT value FROM element_values WHERE element=49 AND
user=$user_id";
$result3 = mysql_query($query3) or die("could not $query3 " .
mysql_error());
list($address_street) = mysql_fetch_row($result3);
$query4 = "SELECT value FROM element_values WHERE element=50 AND
user=$user_id";
$result4 = mysql_query($query4) or die("could not $query4 " .
mysql_error());
list($address_city) = mysql_fetch_row($result4);
$query5 = "SELECT value FROM element_values WHERE element=51 AND
user=$user_id";
$result5 = mysql_query($query5) or die("could not $query5 " .
mysql_error());
list($address_state) = mysql_fetch_row($result5);
$query6 = "SELECT value FROM element_values WHERE element=52 AND
user=$user_id";
$result6 = mysql_query($query6) or die("could not $query6 " .
mysql_error());
list($address_zip) = mysql_fetch_row($result6);
$query7 = "SELECT value FROM element_values WHERE element=53 AND
user=$user_id";
$result7 = mysql_query($query7) or die("could not $query7 " .
mysql_error());
list($phone) = mysql_fetch_row($result7);
?>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
