SQL
Posted: Thu Aug 15, 2002 10:50 pm
my code is this
for($i=0;$i<=$count_number_of;$i++){
$checklist_pass= mysql_query("SELECT *
FROM pase_res WHERE (pas_dep_flight='$flight_list_no' and pas_dep_status='B' and pas_dep_board_seq='$i') or ( pas_rtn_flight='$flight_list_no'and pas_rtn_status='B' and pas_rtn_board_seq='$i')")or die(mysql_error());
}
what's wrong
no errors comming variables and other datafiels are right
problem is under this sql some records are not comming
for($i=0;$i<=$count_number_of;$i++){
$checklist_pass= mysql_query("SELECT *
FROM pase_res WHERE (pas_dep_flight='$flight_list_no' and pas_dep_status='B' and pas_dep_board_seq='$i') or ( pas_rtn_flight='$flight_list_no'and pas_rtn_status='B' and pas_rtn_board_seq='$i')")or die(mysql_error());
}
what's wrong
no errors comming variables and other datafiels are right
problem is under this sql some records are not comming