result into an array...?

[dayk995]

I have the following php code.

 

 

<?php

include("clsMySQL.php");

 

$x = new clsMySQL;

$sSQL = " SELECT name FROM general.parts_vendors WHERE name LIKE '".$term."%' LIMIT 1; ";

$result =  $x->ExecuteQuery("general", $sSQL);

return $result[0];

?>

 

 

 

 

i'm not sure exactly how to store all the results into a variable, if there's a way to do it, how could i store the results into an array?

 

 

 

 

[Barand]

 

$sSQL = " SELECT name FROM general.parts_vendors WHERE name LIKE '".$term."%' LIMIT 1; ";
$result =  $x->ExecuteQuery("general", $sSQL);

$array = array();
while ($row = mysql_fetch_row($result)) $array[] = $row[0];