What is " fldFlight='?' "? Are you using ? as a wildcard or is it actually the only character in the data field? If you're trying to use a wildcard, then ? is not it. Use % or _
-----Original Message----- From: Michael J. Eisner [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 18, 2001 11:31 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Newbie: odbc_prepare & parameters Hi all, i'm really new in php (working on my first project9 and i got the following situation: 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. I got no errormessages. this is how it looks like - and doesn't work: ****** ... ... $sql="SELECT fldCaptain, fldCaptID, fldCaptStat, fldCaptTR, fldCaptDuty, fldFO, fldFOID, fldFOStat, fldFOTR, fldFODuty, fld_F_Reserved, fld_F_Flown FROM tblBookings WHERE fldFlight = '?' AND fldBookDate =#".$EngDatum."#"; $ergDispatch=odbc_prepare($conDispatch,$sql); While (odbc_fetch_into($ergRouten, &$datRouten)) ... ... $Para = array($datRouten[0]); odbc_execute($ergDispatch,$Para); ... ... ***** The array is filled correctly, but the odbc_execute function doesNn't bring back any value, but there are definitvly rows where there should be a result. Thanks in advance! Michael J. Eisner -- 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] -- 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]