\n"; } // **************************** $selstring=""; // **************************** switch ($which) { // seller name case 0: $selstring = "select * from sales " . "where seller like \"%" . $seller . "%\" order by seller limit 50;" ; break; // buyer name case 01: $selstring = "select * from sales " . "where buyer like \"%" . $buyer . "%\" order by buyer limit 50;"; break; // price query case 02: if( $lowprice > $highprice) { $tmp = $lowprice; $lowprice = $highprice; $highprice = $tmp; } $selstring = "select * from sales where price between " . " $lowprice and $highprice order by price limit 50"; break; // date query case 03: $selstring = "select * from sales where month( closing_date) = " . " $closing_month and year( closing_date) = $closing_year " . " order by closing_date limit 50"; break; } echo "\n" . $selstring . "\n"; // ********************************** connect and do the work..... // ginsburg only accepts select user logins from the www.people.virginia.edu server!! mysql_connect( "www.ipm.virginia.edu", "selectuser", ""); mysql_select_db( "test"); // *************************** perform the query $query_handle = mysql_query( $selstring); if (mysql_errno() > 0) { echo "\n" . mysql_errno().": ".mysql_error()."
"; } else { // find out how many rows were returned $num_rows = mysql_num_rows ($query_handle); echo "

"; echo "Got $num_rows row(s) returned from the database.

"; echo "See the data....

"; if ($num_rows > 0) { $row_count = 0; } else { $row_count = $MAX_ROWS +1; } echo "\n"; echo ""; $row = mysql_fetch_array ($query_handle); $buyer_len = strlen( $row["buyer"]); while ($buyer_len > 0 && $row_count <= $MAX_ROWS) { $row_count++; echo "\n"; $row = mysql_fetch_array ($query_handle); $buyer_len = strlen( $row["buyer"]); } echo "
Buyer Seller Location Price Date
" . $row["buyer"] . "
\n"; echo " " . $row["seller"] . "
\n"; echo " ".$row["location"]."
\n"; echo " ".$row["price"]."
\n"; echo " ".$row["closing_date"]."
\n"; echo "
"; } //else clause to stop when an error is detected in the query ?>