PHP - I want to retrieve records from specific field from a MySQL table and build array using PHP

[bond007dev]

I want to retrieve records from specific field from a MySQL table and build array.

Lets say I have field first_name in MySQL table and after using query
"SELECT first_name from family", get records like
Andy
Bob
Craig

Now I want them to be in this format of array
$names = array(1=>'Andy',
2=>'Bob',
3=>'Craig');

Now the problem I am facing is when I run this query using PHP

$query = "SELECT first_name FROM family ";
$result = mysql_query($query);
while($rows = mysql_fetch_array($result))
{
$names = $row['first_name'];
}

I don't want my variable (which stores the array) inside a while loop.....

[Expertz]

If it is a problem with the db connection then I cant be too much helful but if it's the array, have a look at the PHP manual's entry on mysql_fetch_array() (http://www.php.net/mysql_fetch_array)

<?php
include 'config.php';
include 'opendb.php';

$query = "SELECT name, subject, message FROM contact";
$result = mysql_query($query);

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
echo "Name :{$row['name']} <br>" .
"Subject : {$row['subject']} <br>" .
"Message : {$row['message']} <br><br>";
}

include 'closedb.php';
?>

[bond007dev]

I dont have problem retrieving records in mysql_fetch_array, I instead want the records to be in array format of

$names = array(1=>'Andy',
2=>'Bob',
3=>'Craig');
and the array should be accessible outside the while or any loop...

[Janos™]

Can you just don't put the quotes in there.

<form method="post" action="">
<input type="text" name="userInfo[name]">
<input type="text" name="userInfo[email]">
<input type="text" name="userInfo[password]">
<input type="submit">
</form>
<pre>
<?php
var_dump($_POST);
?>
</pre>

Submit a,b,c and get:

array(1) {
["userInfo"]=>
array(3) {
["name"]=>
string(1) "a"
["email"]=>
string(1) "b"
["password"]=>
string(1) "c"
}
}

Let us know back.