Multiple Selects, Dropdowns creates SQL Error
We created these dropdown that populate other dropdowns when selected which works fine until multiples are selected,
We created these dropdown that populate other dropdowns when selected which works fine until multiples are selected,
It appears to be working... What exactly is wrong?
Note the attachment. The Last Bill Date displays right until you select more than one company then throws the SQL code where the Last Bill Date would be.
If you want to support multiple values in a SELECT statement you have to use "IN" instead of "=".
I made the update on your admin/plugins/lastBillDate.php file so the query now reads:
"SELECT DISTINCT customer_ads.start_date FROM customer_ads WHERE customer_ads.client_id IN ? ORDER BY customer_ads.start_date DESC"
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.