connect_errno) { echo "db connection error : " . $mysql->connect_error; exit(); } ?> Sample of two movie queries in the same page
Select Movies from the '90s -- Comedies and Dramas
query($sql); if(!$results) { echo "SQL error: ". $mysql->error . " running query
" . $sql . "
"; exit(); } ?>
R-Rated Comedies: num_rows ?> listings
fetch_assoc() ) { ?> ()
query($sql); // Note: Overwrites previous $results if(!$results) { echo "SQL error: ". $mysql->error . " running query
" . $sql . "
"; exit(); } ?>
R-Rated Dramas: num_rows ?> listings
fetch_assoc() ) { ?> ()