after adding universal email facing problem with rs.
i have universal email which send email on following trigger : Recordset: smsBillingDetails is not empty..
file attached.
booking.php. when i open bookings.php it opens perfectly fine.
when url turns this: bookings.php?BID=25&passenger=1&status=4&invoice=&billid=11
i get error. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
also for this url i get error : bookings.php?BID=25&passenger=1&status=4&invoice=1&billid=11
all same errors.
WHEN I REMOVE UNIVERSAL EMAIL all works fine with any url.
there are many rs which uses $_GET BID so i used:
<?php if(isset($_GET['invoice']) == 1 || isset($_GET['passenger']) == 1 ){ ?>
rs here
<?php } ?>
& <?php if(isset($_GET['invoice']) == "1") { ?>
universal email
<?php } ?>