All pastes #488096 Raw Edit

Someone

public php v1 · immutable
·published 2007-05-14 20:21 UTC
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);			}		}	}