Putting results into an array

[Sparks]

I need to assign the results on the line marked //Assign this to an array// to an array. This array will contain a list of x number of users and I want to reference the first one in the array. I can't find the correct way of doing this.

$get_last_set_users_query = 'SELECT user_responsible FROM ' . $Table . ' WHERE category="' . $_POST['category'] . '" ORDER BY cat_no LIMIT ' . $num_eng_assigned . '';

$get_last_set_users_result = mysql_query($get_last_set_users_query) OR die(mysql_error());

while( $row = mysql_fetch_array($get_last_set_users_result) )
{
echo "" . $row['user_responsible'] . "<br>"; //Assign this to an array//
}

[azunoman]

your code: (with shorter variable names), does the SELECT and then calls db_result_to_array, which will build your array. On return from this function, you data will be in an array.

$query= 'SELECT user_responsible FROM ' . $Table . ' WHERE category="' . $_POST['category'] . '" ORDER BY cat_no LIMIT ' . $num_eng_assigned . '';

$result = @($query);
if (!$result)
return false;
$chk = @mysql_num_rows($result);
if ($chk ==0)
return false;
else
$result = db_result_to_array($result);
return $result;

function db_result_to_array($result)
{
$res_array = array();

for ($count=0; $row = @mysql_fetch_array($result); $count++)
$res_array[$count] = $row;
return $res_array;
}