Loading MySQL results into array?

[Anon]

I wish to load a set of results from a mysql query into an array. The query is:
$Query = "SELECT ID FROM tablename WHERE title = '$title'";

I wish to load all of the returned values of the field 'ID' into an array which can then be used by the rest of the script. I now how to print the results, using:

while($row = mysql_fetch_array($dbresult)) {
print("$row[ID]");
}
but I do not now how to store the results in an array as variables for use in the script.

Please can somebody help?

[Anon]

Hi Stephen,

try something like this:

$allIds = array();
while($row = mysql_fetch_array($dbresult)) {
$allIds[] = "$row[ID]";
}

Now $allIds contains all the IDs.

Cheers,
Markus

[Anon]

Sorry, should be

...
$allIds[] = $row[ID];
...

although the other version should work as well.

Cheers,
Markus

[Anon]

Fantastic! Thank you!