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
