php mysql 子查询_如何在循环内的php mysql中对查询结果进行子查询

我自己想出了这一个只是一堆试验和错误

$item_got = false;

$id = $_GET['id'];

$query = "SELECT * ";

$query.= "FROM quotes ";

$query.= "WHERE id = {$id}";

$confirmed_query = confirm_query($query);

if (!$confirmed_query) {

echo "Query Failed".mysql_error();

}

$query = mysql_query($confirmed_query);

$query_result = mysql_fetch_assoc($query);

echo "

foreach ($query_result as $key => $value) {

echo "

".ucwords(str_replace("_", " ", $key))."";

}

echo "

";

foreach ($query_result as $key => $value) {

echo "

{$value}";

}

echo "

$query = "SELECT * ";

$query.= "FROM quote_details ";

$query.= "WHERE quote_id = {$id}";

$confirmed_query = confirm_query($query);

if (!$confirmed_query) {

echo "Query Failed".mysql_error();

}

$query = mysql_query($confirmed_query);

$header_written = false;

echo "

";

while ($query_result = mysql_fetch_assoc($query)) {

while ($header_written == false) {

foreach ($query_result as $key => $value) {

echo "

".ucwords(str_replace("_", " ", $key))."";

$header_written = true;

}

}

echo "

";

echo "

";

//problem starts here

foreach ($query_result as $key => $value) {

if ($key == "item_id"){

$item_query = "SELECT item_number ";

$item_query.= "FROM items ";

$key_item = $value;

$item_query.= "WHERE id = {$key_item}";

$confirmed_query = confirm_query($item_query);

if (!$confirmed_query) {

echo "Query Failed".mysql_error();

}

$item_query = mysql_query($confirmed_query);

while ($item_number = mysql_fetch_assoc($item_query)) {

foreach ($item_number as $item) {

echo "

{$item}";

}

}

}

elseif ($key == "quote_id"){

$item_query = "SELECT quote_number ";

$item_query.= "FROM quotes ";

$key_quote = $value;

$item_query.= "WHERE id = {$key_quote}";

$confirmed_query = confirm_query($item_query);

if (!$confirmed_query) {

echo "Query Failed".mysql_error();

}

$item_query = mysql_query($confirmed_query);

while ($item_number = mysql_fetch_assoc($item_query)) {

foreach ($item_number as $item) {

echo "

{$item}";

}

}

}

else {

echo "

{$value}";

}

}

echo "

";

}

echo "

;"