Put result from mysql_query in php array

Question

I want to get some results from the MySQL database and put them in a array like this:

array("value2", "value2", "value3");

I have tried this:

$models = array();
$getmodels = mysql_query("select model from cars");
while($res = mysql_fetch_array($getmodels)) {
    $models[$res['model']];
}

This does not work, when i check if the model is in array i get FALSE:

in_array($_REQUEST['model'], $models))

Fad · Accepted Answer · 2016-12-11 09:42:56Z

7

You were supposed to give each key a value, not turning the values into the keys. Try this:

$models = array();
$getmodels = mysql_query("select model from cars");
while($res = mysql_fetch_assoc($getmodels)) {
    $models[] = $res['model'];
}

This will create an array with numeric index. Each key will have the car's model as the value.

edited Dec 11, 2016 at 9:42

answered Oct 16, 2011 at 15:51

Fad

9,8683 gold badges48 silver badges65 bronze badges

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

1 Comment

str Over a year ago

Do not use mysql_fetch_array() if you do not use the number indizes but mysql_fetch_assoc() instead. But even better would be to use mysqli_*() instead of mysql_*().

Collectives™ on Stack Overflow

Put result from mysql_query in php array

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related