Skip to content

Instantly share code, notes, and snippets.

@gsmcwhirter
Created October 3, 2009 18:40
Show Gist options
  • Save gsmcwhirter/200798 to your computer and use it in GitHub Desktop.
Save gsmcwhirter/200798 to your computer and use it in GitHub Desktop.
<?php
$OrderPart = "timestamp DESC";
if($Articlesearch!='' && $Wilcard!=true && $Authorsearch=='')
{
$WherePart = "name='$Articlesearch'";
}
elseif($Articlesearch!='' && $Wilcard==true && $Authorsearch=='')
{
$WherePart = "name LIKE '%$Articlesearch%'";
}
elseif($Articlesearch=='' && $Authorsearch!='' && $Author_Wildcard!=true)
{
$WherePart = "poster_id='$Authorsearch'";
}
elseif($Articlesearch=='' && $Authorsearch!='' && $Author_Wildcard==true)
{
$WherePart = "reporter LIKE '%$Authorsearch%'";
}
elseif($Articlesearch!='' && $Wildcard!=true && $Authorsearch!='' && $Author_Wildcard!=true)
{
$WherePart = "name='$Articlesearch' AND poster_id='$Authorsearch'";
}
elseif($Articlesearch!='' && $Wildcard==true && $Authorsearch!='' && $Author_Wildcard!=true)
{
$WherePart = "poster_id='$Authorsearch' AND name LIKE '%$Articlesearch%'";
}
elseif($Articlesearch!='' && $Wildcard!=true && $Authorsearch!='' && $Author_Wildcard==true)
{
$WherePart = "name='$Articlesearch' AND reporter LIKE '%$Authorsearch%'";
}
elseif($Articlesearch!='' && $Wildcard==true && $Authorsearch!='' && $Author_Wildcard==true)
{
$WherePart = "name LIKE '%$Articlesearch%' AND reporter LIKE '%$Authorsearch%'";
}
$Query = mysql_query("SELECT id,name,timestamp,reporter,poster_id FROM news WHERE archived=1 AND $WherePart ORDER BY $OrderPart");
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment