"; include ('laud_head.php'); print ''; print ""; print "
Personal Collection of $usernameView Catalog
"; print "

"; print ""; $original_price_total = 0; $current_price_total = 0; $line = 0; $even_line_color = "bgcolor=\"#F0F0E8\""; $odd_line_color = "bgcolor=\"#F7F7EF\""; while ($this_row = @mysql_fetch_array($query_result_handle)) { $sql2 = "SELECT * FROM main WHERE id = '$this_row[0]'"; $new_query_result_handle = mysql_query ($sql2) or die ('Database error'); $qresult2 = mysql_fetch_row($new_query_result_handle); $search = str_replace ("'", "\'", $qresult2[1]); $line++; $sql3 = "SELECT round(avg(price),2) FROM auctions WHERE name = '$search'"; $new_query_result_handle2 = mysql_query ($sql3) or die ('Database error'); $qresult3 = mysql_fetch_row($new_query_result_handle2); if (empty($qresult3[0])) {$qresult3[0] = "No Data";} print ""; $original_price_total += $qresult2[3]; $current_price_total += $qresult3[0]; } print "
NameYearOriginal $FragranceCurrent $
$qresult2[1]$qresult2[2]$qresult2[3]$qresult2[4]\$ $qresult3[0]
"; print "
"; print ""; print ""; print ""; print ""; $avg_original_price = round(($original_price_total / $count),2); print ""; print ""; $avg_current_price = round(($current_price_total / $count),2); print ""; print "
Collection Summary
Total Solids$count
Total Original Price\$ $original_price_total
Average Original Price\$ $avg_original_price
Total Current Price\$ $current_price_total
Average Current Price\$ $avg_current_price
"; print "
";} else { print "Estee Lauder Solid Perfumes Database"; include ('laud_head.php'); print ""; print ""; print "
You are not logged in.[Login]View Catalog
"; } ?>