Create PHP array from MySQL column

by

you could loop through the array, and create a new one, like so:

$column = array();

while($row = mysql_fetch_array($info)){
    $column[] = $row[$key];
//Edited - added semicolon at the End of line.1st and 4th(prev) line

}

More Related Contents:

  1. Sign in form always showing "Wrong Credentials"
  2. Prevent creating duplicate entries in PHP
  3. i have stored array in database as a string how can retrieve that array?
  4. Insert array into MySQL database with PHP
  5. Sum values of multidimensional array by key without loop
  6. I have an array of integers, how do I use each one in a mysql query (in php)? [duplicate]
  7. Save PHP array to MySQL?
  8. Notice: Array to string conversion in
  9. mysql_fetch_array, mysql_fetch_assoc, mysql_fetch_object
  10. How get all values in a column using PHP?
  11. mysql select query within a serialized array
  12. PDO fetch one column from table into 1-dimensional array
  13. Get all mysql selected rows into an array
  14. Select from mysql table WHERE field=’$array’?
  15. MySQL query using an array [duplicate]
  16. How to insert json array into mysql database
  17. Why do I get “Resource id #4” when I apply print_r() to an array in PHP? [duplicate]
  18. PHP/SQL Insert Error when using Named Placeholders
  19. Save array in mysql database
  20. MySQL PHP – SELECT WHERE id = array()? [duplicate]
  21. How can I sort arrays and data in PHP?
  22. How do I set ORDER BY params using prepared PDO statement?
  23. Can you add an if statement in ORDER BY?
  24. How to trim white spaces of array values in php
  25. MySQL (or PHP?) group results by field data
  26. PHP: do arrays have a maximum size?
  27. How do I use array_unique on an array of arrays?
  28. PHP array printing using a loop
  29. PDO Cannot execute queries while other unbuffered queries are active
  30. MYSQL select a piece of a string and order by that piece

Leave a Comment