How to manipulate arrays in PHP and MySQL?

Question

I have a code like this.

mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("joomla") or die(mysql_error());

$result = mysql_query("SELECT id,name FROM jos_samples") or die(mysql_error());  



while($row = mysql_fetch_array( $result )) {
print_r($row);
}

And my print array is like this.

Array ( [0] => 3 [id] => 3 [1] => User1 [name] => User1 )
Array ( [0] => 4 [id] => 4 [1] => User2 [name] => User2 ) 
Array ( [0] => 5 [id] => 5 [1] => User3 [name] => User3 ) 
Array ( [0] => 6 [id] => 6 [1] => User4 [name] => User4 )

I want this array something like this

Array ( [3] => User1 [4] => User2 [5] => User3 [6] => User4 )

How can I proceed?

proximus · Accepted Answer · 2011-05-27 07:18:04Z

3

You can reshape your array:

/* ... */

$rows = array();
while($row = mysql_fetch_array($result)) {
    $rows[$row['id']] = $row['name'];
}

$rows is your result.

answered May 27, 2011 at 7:18

proximus

6897 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

hjaffer2001 Over a year ago

Thanks a lot man.. This worked. Thank you again.. Out of words

Mike · Accepted Answer · 2011-05-27 07:47:31Z

3

If I get this right, you want:

while($row = mysql_fetch_array( $result, MYSQL_ASSOC )) {

http://php.net/manual/en/function.mysql-fetch-array.php

(You're currently using the default, which is MYSQL_BOTH.

And then you need to rework your array:

$rows = array();
while($row = mysql_fetch_array( $result, MYSQL_ASSOC )) {
  $rows[$row['id']] = $row['name'];
}

edited May 27, 2011 at 7:47

Mike

21.7k2 gold badges48 silver badges66 bronze badges

answered May 27, 2011 at 7:21

Denis de Bernardy

79.1k14 gold badges138 silver badges158 bronze badges

Comments

Wesley van Opdorp · Accepted Answer · 2011-05-27 07:18:00Z

2

Try this, it builds an array containing the usernames as you want it.

$aUsers = array();

// Use _assoc, it filters numeric key's.
while($aRow = mysql_fetch_assoc( $result )) {
    $aUsers[$aRow['id']] = $aRow['name'];
}

echo '<pre>';
print_r($aUsers);

answered May 27, 2011 at 7:18

Wesley van Opdorp

15k4 gold badges43 silver badges59 bronze badges

3 Comments

proximus Over a year ago

I think the asker wants the mysql field id to represent the array's key.

Dormouse Over a year ago

@proximus, that's what this does

Wesley van Opdorp Over a year ago

@proximus I edited it the second after I posted it :) you were correct!

BugFinder · Accepted Answer · 2011-05-27 07:17:33Z

1

Then dont ask for the ID to be returned in your query, the reason you get 2 items is because ID is in there, secondly if you dont want the name of the field, change the request for the fetch array to

mysql_fetch_array ($result, MYSQL_NUM)

this only gets numbers not the name of the field

answered May 27, 2011 at 7:17

BugFinder

17.9k4 gold badges42 silver badges58 bronze badges

1 Comment

BugFinder Over a year ago

If you just want to print the id and name, then you can do a foreach rather than print_r, you control exactly how and what you see then.

k102 · Accepted Answer · 2011-05-27 07:19:18Z

1

while($row = mysql_fetch_array( $result )) {
$array[$row['id']] = $row['name'];
}

answered May 27, 2011 at 7:19

k102

8,1099 gold badges52 silver badges72 bronze badges

Collectives™ on Stack Overflow

How to manipulate arrays in PHP and MySQL?

5 Answers 5

1 Comment

Comments

3 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

3 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest