$host = "webdev.iyaserver.com"; $userid = "mayden"; $userpw = "AcadDev_Mayden_3369958713"; $db = "mayden_dvd"; include '../pdloginvariables.php'; // you can ignore/skip this line $mysql = new mysqli( $host, $userid, $userpw, $db ); if($mysql->connect_errno) { echo "db connection error : " . $mysql->connect_error; exit(); } $sql = "SELECT * FROM movieView WHERE title LIKE '" . $_REQUEST['title] . "%'"; // SQL statement to submit to db echo "
" . $sql . "
" $results = $mysql->query($sql); if(!$results) { echo "SQL error: ". $mysql->error; exit(); } echo "Your search returned " . $results->num_rows . " results.
"; while($currentrow = $results->fetch_assoc()) { echo "field1: " . $currentrow["field1"]; // replace field1 with the name of a column from your SELECT }