Q695 Posted October 1, 2012 Share Posted October 1, 2012 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? Quote Link to comment https://forums.phpfreaks.com/topic/268957-php-creating-number-array-from-database/ Share on other sites More sharing options...
Zane Posted October 1, 2012 Share Posted October 1, 2012 (edited) 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 Quote Link to comment https://forums.phpfreaks.com/topic/268957-php-creating-number-array-from-database/#findComment-1382023 Share on other sites More sharing options...
Pikachu2000 Posted October 1, 2012 Share Posted October 1, 2012 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. Quote Link to comment https://forums.phpfreaks.com/topic/268957-php-creating-number-array-from-database/#findComment-1382027 Share on other sites More sharing options...
Q695 Posted October 1, 2012 Author Share Posted October 1, 2012 Thanks MN North Stars Quote Link to comment https://forums.phpfreaks.com/topic/268957-php-creating-number-array-from-database/#findComment-1382041 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.