|
'.$myrow["Title"].'
 ';
echo '';
$pic = mysql_query("SELECT * FROM Images WHERE ContentID=".$myrow["ContentID"],$db);
if ($mypic = mysql_fetch_array($pic)) {
echo ' ';
}
echo $myrow["Content"].' ';
}
while ($myrow = mysql_fetch_array($result));
}
?>
';
echo '';
echo '';
if ((isset($_POST['search'])) AND ($_SESSION['userlogin'] == TRUE)){
$result = mysql_query("SELECT Menu.MenuID, Menu.Description, Menu.Page, Content.Content, Content.Visible FROM Menu INNER JOIN Content ON Menu.MenuID=Content.MenuID WHERE MATCH (Content) AGAINST ('".$_POST["criteria"]."') AND Content.Visible = 1 GROUP BY Menu.MenuID LIMIT 0 , 30",$db);
$rowcnt = mysql_num_rows($result);
echo 'Displaying '.$rowcnt.' results for "'.$_POST["criteria"].'" out of a possible 30.
';
if ($myrow = mysql_fetch_array($result)) {
// display list if there are records to display
do {
echo ''.$myrow["Description"].'
';
echo '';
echo substr($myrow["Content"],0,200).' ';
}
while ($myrow = mysql_fetch_array($result));
}
}
?>
|
