mysql_fetch_array in a function will work?

[jaikar]

HI,

 

below is my code, when i try to make the mysql_fetch_array in a function, its not work, is my code is correct? ... please advice

 

Thanks

 

function mq($tbl){
	$query="SELECT * FROM $tbl WHERE type ='".$_GET['type']."'";
	$query = mysql_query($query) or die(mysql_error());
	return $query;
}
function mfa($query){
    $result = mysql_fetch_array($query) or die(mysql_error());
    return $result;
}	


            while($result = mfa($page_query)){
     $menu .='<li><a href="pages.php?type=page&pageid='.$result['page_id'].'">'.$result['page_name'].'</a></li>';
            }

[ballhogjoni]

Put () around the sql statment like this

 

function mq($tbl){
	$query=("SELECT * FROM $tbl WHERE type ='".$_GET['type']."'");
	$query = mysql_query($query) or die(mysql_error());
	return $query;
}

[jaikar]

 

Hi

 

logically speaking, making the bracket there is not a problem at all, i know this still i tried and obviously it did not work. i am able to mysql_query the sql statement, the problem is with the mysql_fetch_array function. if i echo anything before that mysql_fetch_array. its displaying but any echo after mysql_fetch_array does not displays anything and nothing happens!,