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


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to