connect_errno) { echo "db connection error : " . $mysql->connect_error; exit(); } // base query $sql = "SELECT * from view1 WHERE 1=1"; // ADD ON FILTER $sql .= " AND title like 'R%' AND rating = 'PG-13' "; // 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 ""; } /* Note: $results is a database "result set". It has a property $results->num_rows that is a number (how many rows of data) */ // Code to output one sample row with list of columns $sample = $results->fetch_assoc(); echo ""; $results->data_seek(0); // reset results // close php block ?> Horror Movies

Horror Movies

Movie Results:
Title
 Rating
 Genre
 Studio
All Dogs Christmas Carol Rated G Children's/Family MGM
Black Dog Rated PG-13 Suspense Thriller Universal
Boy and His Dog, A: Special Edition Rated R Sci-Fi Image
Chaplin: Special Edition: The Kid/The Rink/The Emmigrant/A Dog�s Life Rated R Delta Entertainment
Charles Mingus: Triumph of the Underdog Rated NR Music Shanachie
Daft Punk: D.A.F.T.: A Story About Dogs, Androids, Fireman And Tomatoes Rated NR Music EMI
Dish Dogs Rated R Comedy Trimark
Dog Of Flanders (1975) Rated NR Animation Pioneer
Dogma Rated R Comedy Columbia TriStar
Firepower 2000 #2:Digital Dogfight Rated NR Documentary Madacy
Kid/A Dog's Life (Silent) Rated NR Comedy Image
Last Of The Dogmen:Special Edition Rated PG Action Adventure HBO
Lawn Dogs Rated R Comedy Trimark
Mad Dog & Glory Rated R Comedy Image
My Dog Skip (Spec. Ed.) Rated PG Children's/Family Warner
My Life As A Dog Rated PG-13 Drama Fox Lorber
Nikki, Wild Dog Of The North Rated G Children's/Family Anchor Bay
Reservoir Dogs Rated R Suspense Thriller Live
Robert De Niro DVD Coll.: Analyze This: Special Edition, A Bronx Tale, Goodfellas, Heat, Wag The Dog: Special Edition Rated R Special Interest Warner
Tap Dogs Rated NR Music Image
Tom Petty & The Heartbreakers:High Grass Dogs:Live Rated NR Music Warner Music
Top Dog Rated PG-13 Action Adventure Artisan
Top Dog: Howliday Favorites In Dog Rated NR Special Interest E Realbiz
Wag the Dog: Platinum Series Rated R Comedy New Line
Why Dogs Smile & Chimpanzees Cry Rated NR Documentary Artisan