 |
include("includes/global_left.php"); ?> |
 |
| include("includes/global_top.php"); ?> |
 |
|
 |
$i = 0;
$db_connect = mysql_connect($db_host, $db_username, $db_password);
mysql_select_db($db_name, $db_connect) || die(mysql_error());
$sql_query = "SELECT * FROM news ORDER BY news_date ASC";
$result = mysql_query($sql_query) or die(mysql_error());
while ($row = mysql_fetch_array($result)) {
$i++;
$news_id = $row[news_id];
$news_title = $row[news_title];
$news_brief = $row[news_brief];
$news_detail = $row[news_detail];
$news_date = $row[news_date];
$sql_query_2 = "SELECT DATE_FORMAT(news_date,'%d %b %Y') AS news_date FROM news WHERE news_id = '$news_id'";
$result_2 = mysql_query($sql_query_2) or die(mysql_error());
$row_2 = mysql_fetch_array($result_2);
$news_date = $row_2[news_date];
?>
|
|
|
|
}
mysql_close($db_connect);
?>
if (!$i) { ?>
|
Sorry, there are no news found ...
|
} ?>
|
|