I'm not sure whether I need to use || or &&
Code: Select all
// page url would look something like domain.com/forumsearch.php?fts=All&keywords=keyword&author=author
// don't freak out =) the variables were already converted from $_GET['var'] to $var
$sql = "SELECT topicid FROM forumentries WHERE";
if((!$fts) || ($fts == "All"))
{
$sql .= " forumid IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25)";
} ELSE
{
$sql .= " forumid = '$fts'";
}
if(($keywords != "") || ($keywords != "keyword"))
{
$sql .= " AND entry LIKE '%$keywords%'";
}
if(($author != "") || ($author != "author"))
{
$sql .= " AND author LIKE '%$author%'";
}
$sql.= " GROUP BY topicid";For some reason I get really confused when it comes to || or &&