View Single Post
Old November 21st, 2009, 04:17 AM   #1 (permalink)
ktmtalk
Member
Verified Customer
 
Join Date: Oct 2009
Posts: 111
Searching multiple sections bug

In showcat.php. around line 405.

It will show:
typecast($_REQUEST, array('mcats' => INT));

replace that with:
typecast($_REQUEST, array('mcats' => STRING));

when multiple sections are selected, the mcats variable will contain something like this:
16,19,34,55

By typecasting it as an INT, the query returns:
"and CATS IN (16)"

By typcasting it as a string like it should be, the query correctly returns
"and CATS IN (16,19,34,55)"


.
.
ktmtalk is offline   Reply With Quote