Databridge V2 with MySQLi support IS Now Available!

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › PHP and MySQL › My search results a sql error. Can you please take a look?

My search results a sql error. Can you please take a look?

Thread began 6/23/2022 3:42 pm by jo271221 | Last modified 6/23/2022 4:27 pm by Ray Borduin | 82 views | 1 replies |

6/23/2022 3:42 pm | #1 jo271221

My search results a sql error. Can you please take a look?

Page attached in live link in PM

6/23/2022 4:27 pm | #2 Ray BorduinWebAssist

It is probably an issue with the "featured" column in your database. Is that a varchar column or integer? You may need to update it to do an "=" search instead of includes and change the data type to integer instead of string.

Try updating line 53 from:
$searchWADAhorses_WADbSearch1->setSearch(array("type"=>"Edit", "comparison"=>"Includes", "join"=>"AND"), array("featured"), "s", "featured");

to:
$searchWADAhorses_WADbSearch1->setSearch(array("type"=>"Edit", "comparison"=>"=", "join"=>"AND"), array("featured"), "c", "featured");

Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

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.