[SOLVED] Joining 2 select statements depending on condition

[meames]

Hi all,

Not sure if this fits in the PHP or MySQL section, I guess its more PHP though so here goes......I am currently trying to write a search script which takes a search term from the user and also takes 3 options on what to search for depending on what the user wants:

• Keywords
  
• Story Title
  
• Main Story
  

 

I have passed all of this to a new page which has the following query in:

 

$Query = "SELECT * FROM News WHERE Park LIKE '%$SearchTerm%'";

 

The 'Park' will be searched every time, but I only want to search on the other options if the user has selected them, I thought about adding the following:

 

if(!empty($Keywords)) {
$Query = $Query + "OR Keywords LIKE '%$SearchTerm%'";
}

 

and so on for the other 2 options, yet this does not work. There must be some way of doing this, can anybody help?

 

Thanks.

[Axeia]

Try echo'ing out the query, think you're missing a space before the OR.

After echo'ing it out try executing it in phpmyadmin or whatever tool you have available to see if it works.

[meames]

Thanks, echo'ing out the query led went to show me what was going off. I have now got it working with the following code:

 

$Query = "SELECT * FROM News WHERE Park LIKE '%$EditedSearchTerm%'";

if(!empty($Keywords)) {
$Query = "$Query OR Keywords LIKE '%$EditedSearchTerm%'";
}

 

Really happy over this, I can move on now