Adding field values to an array

cmoore67

PHP mySQL
How do I add all the values of a field to an array?

Example:
SELECT id FROM table WHERE field='var1'

assume results in this:
-id-
45
56
66

How do I get those values into the array ids[]?

thanks!

Anon

a simple loop will enable you to do this
$ids = array();
$counter = 1;
while($results)
{
$ids[$counter] = db_field_result;
$counter++;
}

cmoore67

that is not working. Any fixes are welcome. This is exactly what I am using.

$sql = "SELECT * FROM table WHERE id_cat = \"$id_cat\"";

$result = @($sql,$connection) or die("1. Couldn't execute query.");

$id_bus = array();
$counter = 1;
while($result)
{
$id_bus[$counter] = db_field_result;
$counter++;
}

thanks

reagent

$sql = "SELECT * FROM table WHERE id_cat = '$id_cat'";

$result = @($sql,$connection) or die("1. Couldn't execute query.");

$id_bus = array();

while($arrData = mysql_fetch_array($result))
{
$id_bus[] = $arrData["id"];
}

this will do what you want.
The counter isn't necessary, since you can use the [] notation to append to the array.
I'm assuming you're connected to the DB as well.

cmoore67

That worked. Thanks for your time.

Anon

if the ids are numbers try taking the variable out of quotes, sql may be interpreting the number as a string