Php Creating Number Array From Database

[Q695]

my print_r from a database is: Array ( [0] => 1 [1] => 1 [2] => 11 [3] => 1 )

 

the script is a standard php/mysql pull that I've used labeled rows with before:

$sqli1 = "SELECT * FROM ...................................";
$result1 = mysql_query($sqli1, $con) or die ("can not generate result " . mysql_error());
$row1 = mysql_fetch_row($result1);

 

What's going wrong to not load column names?

[Zane]

You should use mysql_fetch_assoc if you want the column names for the key

 

Typically, when people write code to retrieve mysql results they loop through their result with a while loop, such as this

while($row = mysql_fetch_array($result1)) {
echo $row['columnName'];
}

Edited October 1, 2012 by Zane

[Pikachu2000]

To clarify a little more, mysql_fetch_row() returns only an enumerated array, mysql_fetch_assoc() returns an associative array, and mysql_fetch_array() returns both.

[Q695]

Thanks MN North Stars