MySQL results array into php variables?

Question

I have a MySQL result set

$fields_num = mysql_num_fields($result);

I would like to assign all of these results PHP variables that I can use on the page. What's the easiest way?

Thanks!

Do you mean get an array of results, or turn the array into individual variables? Your quoted piece of code would just tell you how many columns were returned. — Jamescun
– Jamescun, Commented Dec 25, 2010 at 0:41

Dejan Marjanović · Accepted Answer · 2010-12-25 19:05:37Z

4

$row = mysql_fetch_assoc($result);

Access via $row["name"]

$row = mysql_fetch_array($result);

Access via $row[0] and $row["name"]

Complete example...

$result = mysql_query("SELECT id, name FROM mytable");

while ($row = mysql_fetch_array($result)){
    echo $row[0];echo $row["name"];  
}

Will print "id" and "name".

answered Dec 25, 2010 at 0:46

Dejan Marjanović

19.4k7 gold badges54 silver badges67 bronze badges

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

Comments

ajreal · Accepted Answer · 2010-12-25 00:39:30Z

2

Try mysql_fetch_array which return results as an array with column name as associate key

$row = mysql_fetch_array($result, MYSQL_ASSOC);
/* $row will be an array */
/* and the column wil be the associate key */

OR

you can use mysql_fetch_field, which provide even more information

answered Dec 25, 2010 at 0:39

ajreal

47.4k11 gold badges97 silver badges119 bronze badges

Jamescun · Accepted Answer · 2010-12-25 00:53:34Z

0

If you are fetching multiple rows, you will need a while loop.

while($row = mysql_fetch_array($result)){
    echo $row['column_name'];
}

This will execute the code in the curly brackets for each row result. In the example, printing a field called 'column_name'.

answered Dec 25, 2010 at 0:53

Jamescun

7036 silver badges8 bronze badges