Re: [Duches77] SQL where clause
Hi Duches77,
Is the 'category' field a multi-value list field? If so it stores multiple values in a tab separated list, so the where needs to be a little different:
'where' => " category LIKE '%\tFundraising Raffles\t%' ",
Or, if it works to have that in the url you can make use of the automatic searching features with:
yourViewer.php?category=Fundraising Raffles
But, if neither of those work, the next step in debugging the problem would be to look at the data being returned and compare it to the where.
list($eventsRecords, $eventsMetaData) = getRecords(array(
'tableName' => 'events',
'perPage' => '25',
#'where' => 'category = "Fundraising Raffles"',
));
showme($eventRecords);
exit;
And to check what the value of 'category' is.
Let me know if any of those help or how far you get. Thanks!
Dave Edis - Senior Developer
interactivetools.com