Creating Arrays from the rable

[phpmady]

Hi,

 

I need to create a array like below, from the table:

 

$items = array(

"Great <em>Bittern</em>"=>"1",

"Little <em>Grebe</em>"=>"2",

"Little <em>Grebe</em>"=>"3",

"Little <em>Grebe</em>"=>"4"

);

 

 

users table has 2 columns:

 

id

name

 

 

 

Thanks,

Mubarak.A

 

 

 

 

 

 

 

 

[trq]

And your problem is?

[phpmady]

Hi,

 

I tried to create a array, with the following php code, but am failed whats wrong am doing here?

 

$query  = "SELECT user_id,f_name
                  FROM user_profile";

        $result = mysql_query($query);

echo $result;




	while ($row = mysql_fetch_array($result)) {
	   $results['f_name'] =  $row['user_id'] ;
	}

[dcro2]

'f_name' is still part of the $row array even if you use it like that, so this would work:

$results[$row['f_name']] =  $row['user_id'];

[chriscloyd]

<?php
$query  = "SELECT user_id,f_name FROM user_profile";
$result = mysql_query($query);

echo $result;
$results = array();
while ($row = mysql_fetch_array($result)) {
$results[$row['f_name']] =  $row['user_id'] ;
}
?>