SQL Search Question

2 posts by 2 authors in: Forums > CMS Builder
Last Post: March 11, 2011   (RSS)

Re: [everbatim] SQL Search Question

By Jason - March 11, 2011

Hi,

You're really close. You need to have the "or" inside the string, otherwise you're using a php "or", not a MySQL "or".

Try this:

list($webinarsRecords, $webinarsMetaData) = getRecords(array(
'tableName' => 'webinars',
'allowSearch' => '0',
'where' => "Presenter='name1' OR Co_Presenter='name1' ",
));


Hope this helps
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/