|
$res = db_res("SELECT Date, Text, `Header`, ID FROM News ORDER BY `Date` DESC LIMIT 0,2");
$count=0;
while ( $arr = mysql_fetch_array($res))
{
$count++;
$text=substr($arr[Text],0,150);
echo '';
}
?>
|
$query = "SELECT Reviews.ID, Profiles.ID as MembID, Reviews.Date, Reviews.Header, Reviews.Text, Profiles.NickName FROM Reviews INNER JOIN Profiles ON (Reviews.Sender=Profiles.ID) WHERE Reviews.active = 'on' ORDER BY Reviews.`Date` DESC LIMIT 0,4";
$res = db_res($query);
$count=0;
while ( $arr = mysql_fetch_array($res))
{
$count++;
$text=substr($arr[Text],0,150);
echo '
| '.$count.'. |
"'.$text.'.."
|
|
';
}
?>
|
| Current Promo: |
|
include "cmsv.php";
cms(15);
?>
|
|