Create table columns as variables in an array

Question

I am running a query with a while loop that creates an array of the column names

while($ContactLookup_Row = mysql_fetch_array($ContactLookup_Rs)) {
        $ContactLookup_Results[] = array(
        'sequence'=>$ContactLookup_Row["sequence"], 
        'forename'=>$ContactLookup_Row["forename"],
        'surname'=>$ContactLookup_Row["surname"]
         );
    }

How can I make the loop add all the column names as their own variables without having to type them all out manually?

Should I put $ContactsLookup_Results[]= array( before the while loop. And then ); after the while loop

And then I'm not sure about within the loop?

I want it to look like:

'ColumnName'=>$ContactLookup_Row["ColumnName"]

With a , on the end of each one but not the last one

Can you post how the resulting array should then look like? Becouse I don't know what you mean... — Matthias Dunkel
– Matthias Dunkel, Commented Dec 31, 2013 at 12:07

invisal · Accepted Answer · 2013-12-31 12:04:22Z

0

How about

while($ContactLookup_Row = mysql_fetch_array($ContactLookup_Rs)) {
        $ContactLookup_Results[] = $ContactLookup_Row;
}

answered Dec 31, 2013 at 12:04

invisal

11.2k4 gold badges36 silver badges54 bronze badges

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

Comments

Erick Briseño · Accepted Answer · 2013-12-31 17:06:20Z

0

Try this.

$sql="DESCRIBE $_table_name";

$result=mysql_query($sql) or die(mysql_error());

while($data = mysql_fetch_assoc($result)){

    $columns[$data['Field']]=$data['Field'];

}

answered Dec 31, 2013 at 17:06

Erick Briseño

1731 silver badge5 bronze badges

Collectives™ on Stack Overflow

Create table columns as variables in an array

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related