mySQL nested select
| From: | Lez Lytollis | Date: | Wed, 05 Jul 2000 15:48:53 +0000 |
| Subject: | mySQL nested select | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-875@lists.php.net to get a copy of this message | ||
Hi,
I am trying to pull a set of results from a mySQL db that shows the last set
of data a user entered.
This works but requires two calls to the db:
$last_date_query = "SELECT MAX(user_measurement_date) FROM user_measurements
WHERE user_id = '$user_id'";
$last_date = mysql_query($last_date_query) or die(mysql_error());
$tmp_result = mysql_result($last_date,"user_measurement_date");
$query = "SELECT * from user_measurements WHERE user_id = '$user_id' AND
user_measurement_date = '$tmp_result' ";
Is there a more elegant way to get the data out in one go?:
i.e. something like:
$query = "SELECT * FROM user_measurements
WHERE user_id = '$user_id'
AND user_measurement_date = (SELECT MAX(user_measurement_date)
FROM user_measurements
WHERE user_id = '$user_id')";
Thanks
Lez