rendered paste body function listMovies($gID){ include 'config.php'; $dbcon = db_con(); $mData = array(); $sql = 'SELECT * FROM ' . $dbname . '.' . $movie_table_name . ' WHERE ' . $movie_gID_field . '=\'' . $gID . '\''; $dbLM = mysql_query($sql); if(!$dbLM){ mysql_close($dbcon); $err = 'Error with pulling data for listing movies <br/> Error: ' . mysql_error() . ' <br/> SQL: ' . $sql; return array(0,$err); }else{ while($row = mysql_fetch_assoc($dbLM)){ $mData[] = $row; } if(empty($mData)){ mysql_close($dbcon); $err = 'Error with fetching movie data <br/> Error: ' . mysql_error(); return array(0,$err); }else{ mysql_close($dbcon); return array(1,$mData); } } }