how do i populate a php array from one column of an sql database?

Question

Lets say I have a mysql database called "pcode" with only one table, called "uk_postcodes" and I want to populate my array with only the first column, called "postcodes". What is missing from the following code:

    //link to mysql server
    $link = mysql_connect('localhost', 'root', 'root');
    mysql_select_db('pcode'); 

    $sql = "SELECT * FROM `ukpostcodes`";
    $query = mysql_query($sql);

$var = array();

usual way to get the data from database is missing, which you used to use 1000 times already, but forgot here for whatever reason. — Your Common Sense
– Your Common Sense, Commented Jan 26, 2011 at 12:41

Dan Grossman · Accepted Answer · 2011-01-26 12:37:37Z

7

$sql = "SELECT postcodes FROM ukpostcodes";
$result = mysql_query($sql);

$var = array();
while ($row = mysql_fetch_array($result)) {
  $var[] = $row['postcodes'];
}

answered Jan 26, 2011 at 12:37

Dan Grossman

52.5k10 gold badges115 silver badges101 bronze badges

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

Collectives™ on Stack Overflow

how do i populate a php array from one column of an sql database?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related