How to use result from one query as criteria in a second query

[Don Seckler]

Ok, I took a whack at this, but it's still not returning anything.
Granted I used Dreamweaver to create the queries, but I must be messed
up somewhere.

Any help would be appreciated.
1st Query: (this ones works wonderfully)
mysql_select_db($database_db********, $db********);
$query_new_review_one = "SELECT Artists.Artist,
tbl_reviews.album_title, tbl_reviews.opener, tbl_reviews.score,
Albums.image_location, tbl_reviews.artist_id FROM tbl_reviews,
Artists, Albums WHERE tbl_reviews.artist_id = Artists.ID AND
Albums.Album_Name =tbl_reviews.album_title ORDER BY review_id DESC
LIMIT 1";
$new_review_one = mysql_query($query_new_review_one, $db99532137) or
die(mysql_error());
$row_new_review_one = mysql_fetch_assoc($new_review_one);
$totalRows_new_review_one = mysql_num_rows($new_review_one);
Variable Set and Second Query:
$album_user_review_one = "1";
if (isset($row_new_review_one['album_title'])) {
$album_user_review_one = (get_magic_quotes_gpc()) ?
$row_new_review_one['album_title'] :
addslashes($row_new_review_one['album_title']);
}

mysql_select_db($database_db********, $db********);
$query_user_review_one = sprintf("SELECT AVG(tbl_user_reviews.score)
FROM tbl_user_reviews WHERE tbl_user_reviews.album_title = '%s'",
$album_user_review_one);
$user_review_one = mysql_query($query_user_review_one, $db99532137) or
die(mysql_error());
$row_user_review_one = mysql_fetch_assoc($user_review_one);
$totalRows_user_review_one = mysql_num_rows($user_review_one);

[Bill Karwin]

Don Seckler wrote:

$album_user_review_one = "1";
if (isset($row_new_review_one['album_title'])) {
$album_user_review_one = (get_magic_quotes_gpc()) ?
$row_new_review_one['album_title'] :
addslashes($row_new_review_one['album_title']);
There's also a function mysql_escape_string(), which probably does a
similar thing as addslashes(), but the former is intended for MySQL.
Perhaps there's some case of special characters needed for MySQL, but
which addslashes() is not covering.
}

mysql_select_db($database_db********, $db********);
$query_user_review_one = sprintf("SELECT AVG(tbl_user_reviews.score)
FROM tbl_user_reviews WHERE tbl_user_reviews.album_title = '%s'",
$album_user_review_one);
The usual advice in this kind of situation is that you should print the
resulting SQL string to some diagnostic output before executing it. The
error is much easier to spot that way. Whenever you construct SQL
programmatically, no matter how simple it seems to be, sometimes it
doesn't turn out as you expect.

It seems to me that there is at least one case in which
$album_user_review_one could be "1".
$user_review_one = mysql_query($query_user_review_one, $db99532137) or
die(mysql_error());
$row_user_review_one = mysql_fetch_assoc($user_review_one);
$totalRows_user_review_one = mysql_num_rows($user_review_one);

Regards,
Bill K.