} else { $output .= "\"Cancel Offer\">"; } $output .= "</form>"; echo $output; } ?> <h1 class="h1_spacing">Purchased Books:</h1> <br /> <?php $query = "SELECT * "; $query .= "FROM buy "; $query .= "WHERE buyer_id = {$user_id}"; $buy_set = mysqli_query($connection, $query); while ($buy_order = mysqli_fetch_assoc($buy_set)) { $sell_id = $buy_order["sell_id"]; $query = "SELECT * "; $query .= "FROM sell "; $query .= "WHERE id = {$sell_id}"; $sell_set = mysqli_query($connection, $query); while ($sell_order = mysqli_fetch_assoc($sell_set)) { echo print_book_details_for_sales($sell_order); } //print some book details } ?> </div> </body> </html> <?php ob_end_flush();
$user_set = mysqli_query($connection, $query); while ($user = mysqli_fetch_assoc($user_set)) { $convo_partner = $user["username"]; //pull out the name $header_output .= $convo_partner; } $header_output .= "</h1>"; $header_output .= $output2; $sell_id = $messages["sell_id"]; //use the id from the "sell" database to know which selling order is being discussed $query = "SELECT * "; $query .= "FROM sell "; $query .= "WHERE id = {$sell_id}"; $sell_set = mysqli_query($connection, $query); while ($sell_order = mysqli_fetch_assoc($sell_set)) { $header_output .= print_book_details_for_sales($sell_order); } $buyer_name = ""; $buyer_id = $messages["buyer_id"]; $seller_name = ""; $seller_id = $messages["seller_id"]; $query = "SELECT * "; $query .= "FROM users "; $query .= "WHERE id = {$buyer_id} "; $query .= "LIMIT 1"; $buyer_set = mysqli_query($connection, $query); while ($buyer = mysqli_fetch_assoc($buyer_set)) { //extract the name of the buyer $buyer_name = $buyer["username"]; } $query = "SELECT * ";