recordset questions

[SylvesterWebster]

Hi,

say I have an SQL statement that says

$query_rsorigin = SELECT * from table where origin = 'spain';

I want to populate an array with the id's returned in the recordset. so say the first row of the recordset has the id of 3 how do i return that id?

Cheers

Tim

[eclipsed4utoo]

SELECT ID FROM Table WHERE Origin = 'Spain'