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
Error: ' . mysql_error() . '
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
Error: ' . mysql_error();
return array(0,$err);
}else{
mysql_close($dbcon);
return array(1,$mData);
}
}
}