Storing different columns from database to an array. [duplicate]

Question

heres my code.

$speakers=array();
    $handler2=mysql_query("SELECT fName,lName,title FROM speaker ;");
        while($row = mysql_fetch_assoc($handler2)){
        $speakers[] =$row['fName'],$row['lName'],$row['title'];
        }

i want to get fName,lName and title from my database and store it in a single array index.

so print_r($speakers)'

will output the value of fName,lName,title like this

Array ([0]=>fname lname title [1]=>fname lname title).

can you guys help?

official doc

Adi Prasetyo
– Adi Prasetyo

2016-03-13 10:57:04 +00:00
Commented Mar 13, 2016 at 10:57 — Adi Prasetyo
– Adi Prasetyo, Commented Mar 13, 2016 at 10:57

RomanPerekhrest · Accepted Answer · 2016-03-13 10:55:26Z

0

If you want to save field values as a string( [0]=>fname lname title) - change your code as shown below:

while ($row = mysql_fetch_assoc($handler2)) {
    $speakers[] = $row['fName']. " " .$row['lName']. " " .$row['title'];
}

answered Mar 13, 2016 at 10:55

RomanPerekhrest

93.1k4 gold badges75 silver badges112 bronze badges

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

1 Comment

Boneyflesh Over a year ago

thanks man, this is exactly what i need. wew,didnt know it was that simple, maybe my cold affected the way i think..haha thanks @RomanPerekhrerst

Gouda Elalfy · Accepted Answer · 2016-03-13 10:55:35Z

0

you can do this easily:

while($row = mysql_fetch_assoc($handler2)){
    $speakers[] =array($row['fName'],$row['lName'],$row['title']);
}

answered Mar 13, 2016 at 10:55

Gouda Elalfy

7,0833 gold badges28 silver badges38 bronze badges

2 Comments

Boneyflesh Over a year ago

thanks, but this will create multiple indexes. not exactly what i had in mind but no worries,i found an answer.

Boneyflesh Over a year ago

the guy who answered after you,, while ($row = mysql_fetch_assoc($handler2)) { $speakers[] = $row['fName']. " " .$row['lName']. " " .$row['title']; }

PerlDuck · Accepted Answer · 2016-03-13 11:12:25Z

0

Depending on your context you could also make MySQL do the job for you:

SELECT CONCAT_WS(' ', title, fName, lName) as spkr FROM speaker;

This will only return one column, spkr, with the values already concatenated. See CONCAT_WS.

answered Mar 13, 2016 at 11:12

PerlDuck

5,7463 gold badges23 silver badges42 bronze badges

Collectives™ on Stack Overflow

Storing different columns from database to an array. [duplicate]

3 Answers 3

1 Comment

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

Comments

Linked

Related