problem returning mysql results

[guhyaraja]

Hi I'm experimenting a bit with some code and trying to build a function that returns the result from a mysql query.

I searched this forum and google but not found anything to help me with this. Could anyone point out whats wrong with the code?

<?php

include('./dbconf.php');

function DoSql($query_array=array())
    {
     $data = array(); 
        foreach ($query_array as $key=>$value)
            {

	    if ($key == "SELECT"){
		$query = "SELECT " . $value . " ";
                }

	    if ($key == "FROM"){
		$query = $query . "FROM " . $value . " ";
	    }

	    if ($key == "WHERE"){
		$query = $query . "WHERE " . $value . " ";
	    }

	    if ($key == "DBPAR1"){
		$query = $query . $value . " ";
	    }		    


        }

    echo $query . "<br /><br />\n\n";

    $result = mysql_query($query)
    or die ("No Juice...");


return($result);  

}



$SELECT = "*"; 
$FROM   = "categories";
$WHERE  = "cat_level = 1";
$DBPAR1 = "ORDER BY cat_id ASC";

$qArray = array(
	   "SELECT"=>$SELECT, 
	   "FROM"=>$FROM, 	   

	   "WHERE"=>$WHERE,
	   "DBPAR1"=>$DBPAR1  

	  );


DoSql($qArray);

     while ($row = mysql_fetch_array($result)){
	    echo $row[0] . "<br />\n";
	    echo $row[1] . "<br />\n";
	    echo $row[2] . "<br />\n";
    }



?>

thanks

[cahva]

$result = DoSql($qArray);

Need I say more? 🙂

[guhyaraja]

cahva;10888208 wrote:

$result = DoSql($qArray);

Need I say more? 🙂

doh!

:o All these hours banging my head against the screen 🙂

thanks very much 🙂