Re: Re: Newbie: odbc_prepare & parameters

Michael J. Eisner wrote:

i have a loop going through a result set of an odbc-query. each row of this loop has to be checked if there is an entry in another table. so as the last odbc-query is the same for each row except they key-field, i tried to use the odbc_prepare function and a parameter array. but it doesn't work.

If Access supports subqueries, you should consider this approach, e.g. $sql="SELECT fldCaptain, fldCaptID, fldCaptStat, fldCaptTR, fldCaptDuty, fldFO, fldFOID, fldFOStat, fldFOTR, fldFODuty, fld_F_Reserved, fld_F_Flown FROM tblBookings WHERE fldFlight in (select ... from ... where ...) AND fldBookDate=#".$EngDatum."#"; with the subquery being essentially your $ergRouten statement. HTH, Andreas -- Andreas Karajannis mediaworx berlin AG Fon (0 30) 2 75 80 - 266 Fax (0 30) 2 75 80 - 200