Hi,
I have the following code which will query against one word. In this example the word is ‘Host’. However I am trying to make it query against two words. The second one being ‘Organiser’. I have tried a few options like OR and , but whatever I try doesn’t seem to work. Any suggestions please?
[php] <?php
$query = mysql_query(“SELECT dealcompany, logo, ID, dealcountry, eventid, dealdescription, dealtitle, company, country, usertype, state
FROM users
JOIN deals ON deals.userid = users.id
WHERE deals.dealtypeowner = ‘Host’ ORDER BY eventid DESC LIMIT 10”);
while($row = mysql_fetch_array($query)) {
?>[/php]
[php] <?php
$query = mysql_query(“SELECT dealcompany, logo, ID, dealcountry, eventid, dealdescription, dealtitle, company, country, usertype, state
FROM users
JOIN deals ON deals.userid = users.id
WHERE deals.dealtypeowner = ‘Host’ OR ‘Organiser’ ORDER BY eventid DESC LIMIT 10”);
while($row = mysql_fetch_array($query)) {
?>[/php]