MySQL help

[Anon]

I'm looking for a reasonably simple and fast way to fill an array with the results of a single column select query.

example results from query:

+-----------+
| productid |
+-----------+
| PS |
| PSLEB |
| MD1 |
| CPSS1 |
| CPSG1 |
| CPSP1 |
| CPSSR |
| CPSGR |
| ST1 |
| STFREE |
+-----------+

desired array:
$arr = array(PS,PSLEB,MD1,CPSS1,CPSG1,CPSSR,CPSGR,ST1,STFREE);

I'm using MySQL.

I've seen ways to fill an array with an entire single row. But I only need one value from each row so mysql_query() and mysql_fetch_array() seem like overkill. Does anyone have a function that might do this already or a suggestion to get me started?

Ultimate Goal:
Basically, I want to interate through a set of ID's returned by the select query and perform further querys based on each id in the result. An array would be a clean way to step through it. If there is a
better/simpler/easier way to do this, please let me know. I'm new to PHP
(but not programming).

Thanks a bunch,
Glenn

[Anon]

I don't know of any way other than iterating through the rows returned from the query. But I don't see why you want to go through the intermediate step of storing in an array and then stepping through it. Why not just use a "while" loop fetching and processing the rows?

[Anon]

I'm hoping there's a way to iterate through the rows returned in my first query. That is all the data I need from the db. I just think it's redundant to have to ask the db what the next value is, when I've already gotten it in a query - it's the next row.

I will be checking on this key value's existance in another table, then performing actions depending on that.

Your method is really not a big deal, since the number of records, and subsequent fetches, is only around 10. But what if I had a 100 or 1000 records to check?

Isn't there a better way? Or am I missing something fundamental?