Home
Services
Products
Guides
Contact Us
Blog
include ("header.php"); $sql = "select * from blog_articles"; $sql_result = mysql_query($sql, $connection) or die("Could not execute query 1"); $total_articles = mysql_num_rows($sql_result); $num_pages = ceil ($total_articles/5); ?>
Listing 1-= $total_articles?> of = $total_articles?>
Page 1 for ($i = 1; $i < $num_pages; $i++) { $j = $i + 1; ?>
= $j?>
| } ?> of = $num_pages?>
Next >
$sql = "select * from blog_articles order by articledate desc"; $sql_result = mysql_query($sql, $connection) or die("Could not execute query 1"); while ($row = mysql_fetch_array($sql_result)) { $articleid = $row["articleid"]; $articledate = $row["articledate"]; $articletitle = $row["articletitle"]; $articletext = nl2br($row["articletext"]); $sql1 = "select * from blog_comments where articleid = \"$articleid\""; $sql_result1 = mysql_query($sql1, $connection) or die("Could not execute query 1"); $num_comments = mysql_num_rows($sql_result1); ?>
= $articledate?>
= $articletitle?>
= $articletext?>
Add a Comment
|
= $num_comments?> Comments
} ?>
Listing 1-= $total_articles?> of = $total_articles?>
Page 1 for ($i = 1; $i < $num_pages; $i++) { $j = $i + 1; ?>
= $j?>
| } ?> of = $num_pages?>
Next >
include ("footer.php"); ?>
Home :: About Us :: Services :: Products :: Contact Us :: Enquiry
Copyright © Tunnel of Light