convert Results into Associative array

[hemi519]

Hi All,

I want to convert mysql results into associative array like below

function jobs()  // previously i was using this function and i was declaring as mentioned in $job_arr
{
	
	$job_arr = array(
	' '  => "Please select job type",
       '1'=>"Full Time",
       '2'=>"Part Time",
'       3' =>"Freelancing"	
	);

	return $job_arr;
}

But i want to get these results from my mysql result

function jobs()
{


        $sql = "Select * from jh_job_type where Status = 1";
	$query = $ci->db->query($sql);
	$result =  $query->result_array();

   // Id,Name are the field names 

  $job_arr = '';     // i started doing with foreach but did not get required result.



return $job_arr;
}

Anyone know how to do this one?

[hemi519]

solved

[james438]

Good to hear! How did you solve it? If it is solved could you mark this thread as resolved?

[hemi519]

I have changed my function as below

function jobs()
{

       
$sql = mysql_query("Select Id,Name from jh_job_type where Status = 1");
	while($result = mysql_fetch_array($sql))
	{
		$jobs_arr[$result['Id']] = $result['Name'];
	}
	return $jobs_arr;

}

This solved my issue. Hope it helps someone

[fastsol1]

Why not just use mysql_fetch_assoc instead?