 |
Please Select an item you wish to view.
//--------------------------------------------------------------------------
$username = "mysql85786_2";
$password = "8621tami";
$database = "mysql85786_2";
mysql_connect("dbs01.northlandcom.com",$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
//---------------------------------------------------------------------------
$strSQL = "SELECT * FROM `newsitems` WHERE `expires` < curdate() and `startdate` < curdate()";
$getnewsitem= mysql_query($strSQL) or die('Sorry no current news items');
?>
if (mysql_num_rows($getnewsitem) == "0"){ ?>
Sorry no current news items |
} else
$num2=mysql_num_rows($getnewsitem);
{
while ($j < $num2) {
$newsitem_id = mysql_result($getnewsitem,$j,"newsitem_id");
$title=mysql_result($getnewsitem,$j,"title");
?>
echo $title ?> |
$j++;
}
}
?>
Click here to view the current news |
|
 |