";
print "";
$selectlinks="SELECT * from cl_entries where (CONCAT_WS('' , EntryName, Description, contactname, URL) like '%$searchterm%')order by importance DESC limit $start,$numentries";
$selectlinks2=mysql_query($selectlinks) or die(mysql_error());
$numlinks=mysql_num_rows($selectlinks2);
if($numlinks>0)
{
while($selectlinks3=mysql_fetch_array($selectlinks2))
{
print "";
$selectlinks3[Description]=htmlspecialchars($selectlinks3[Description]);
$selectlinks3[EntryName]=htmlspecialchars($selectlinks3[EntryName]);
$bimg=null; if (!file_exists('busdir/memberimgs/'. $selectlinks3[entryID] .'.img')) {$bimg=' colspan="2"';}
print "| ";
print "$selectlinks3[EntryName]";
print " | ";
print "";
print " $selectlinks3[Description]";
print " ";
if (preg_match('/[a-z0-9]/i', $selectlinks3[phone])) print " Phone: $selectlinks3[phone] ";
if (preg_match('#^http\\:\\/\\/[a-z0-9\-]+\.([a-z0-9\-]+\.)?[a-z]+#i', $selectlinks3[URL])) print " Website: " . str_replace('http://', '' , strtolower($selectlinks3[URL])) . " ";
if (preg_match('/[a-z0-9]/i', $selectlinks3[email])) print" Quick Contact ";
// if($selectlinks3[importance]>0)
// {
// print "
sponsered";
// }
print " ";
print " ";
print " | ";
if (!isset($bimg)) {
print "";
print " ![\"".$selectlinks3[EntryName]."\"](\"busdir/memberimgs/".) ";
print " | ";
}
print"
";
}
echo "";
$order="SELECT * from cl_entries where (CONCAT_WS('' , EntryName, Description, contactname, URL) like '%$searchterm%') order by importance DESC";
$order2=mysql_query($order) or die(mysql_error());
$d=0;
$f=0;
$g=1+$d/$numentries;
$num=mysql_num_rows($order2);
$prev=$start-$numentries;
$next=$start+$numentries;
if($start>=$numentries)
{
print "<< ";
}
if ($start>=$numentries || $start<=$num-$numentries) print "Page ";
while($order3=mysql_fetch_array($order2))
{
if($f>=$start-3*$numentries&&$f<=$start+5*$numentries)
{
if($f%$numentries==0)
{
if ($start<$num-$numentries || $start>=$numentries) print " $g ";
}
}
$d=$d+1;
$g=1+$d/$numentries;
$f++;
}
if($start<=$num-$numentries)
{
print ">> ";
}
}
else
{
echo'
No matching items were found.
Please try again. ';
}
print " | ";
print "
";
print "";
}
else //root case
{
print "