connect_errno) {
echo "db connection error : " . $mysql->connect_error;
exit();
}
// base query
$sql = "SELECT * from view1 WHERE 1=1";
// ADD ON FILTER
$sql .= " AND label LIKE 'Universal%' AND rating = 'G' AND genre = 'Adventure' ";
// ADD ON sort order
$sql .= " ORDER BY title";
// submit query to database, store returned data as $results
$results = $mysql->query($sql);
if(!$results) {
echo "SQL error: ". $mysql->error . " running query
" . $sql . "
";
exit();
} else {
// put sql into comment block of webpage
echo "";
}
// Code to output one sample row with list of columns
$sample = $results->fetch_assoc();
echo "";
$results->data_seek(0); // reset results
?>
Universal Studios Horror Films
num_rows ?> Universal Studios films that are Rated G and are Adventure genres
| Movie Title |
Rating |
Studio Label |
Genre |
fetch_assoc() ) { ?>
|
|
|
|