|
|
|
Recent news
=0) ";
$SQL = $SQL . " AND (TO_DAYS(ExpiredDate)-TO_DAYS(Now())>=0) ";
$SQL = $SQL . " AND Released=1 ";
//$SQL = $SQL . " AND homepage=1 ";
$SQL = $SQL . " ORDER BY ReleaseDate DESC ";
# execute SQL statement
$db_link = mysql_connect('daedelus.bridgeport.edu', 'ubnews', 'Zpix455');
# connect and prepare queries against the database.
mysql_select_db("ubnews",$db_link);
# sends a line of SQL to the MySQL server to be processed.
$retid = mysql_query($SQL, $db_link);
# check for errors
if (!$retid) { echo( mysql_error()); }
else {
# display results
while ($row = mysql_fetch_array($retid)) {
$newsid = $row["NewsID"];
$topic = $row["Topic"];
$url = $row["URL"];
echo ("");
}
}
?>
|
| |
