Here is my code so far...
Code: Select all
<?php
//**********************************************************//
//StudentCenter //
//Display News Function Version 0.1 //
// //
//Written by: Rob Frawley //
//************************************* *********************//
require('config2.inc.php');
function displaynews($limit)
{
//query database for news
$news->query1 = "SELECT * FROM `news` ";
$news->query1 .= "ORDER BY `id` DESC ";
$news->query1 .= "LIMIT 0, `{$limit}`";
$news->result1 = mysql_query($news->query1) or die (mysql_error());
//display news
while ($row1 = mysql_fetch_array($news->result1)) {
//query database for poster info
$news->query2 = "SELECT * FROM `users` ";
$news->query2 .= "WHERE `id` = `{$row1['userid']}`";
$news->result2 = mysql_query($news->query2) or die (mysql_error());
$row2 = mysql_fetch_array($news->result2);
//display news
echo 'NEWS:' . '<br>';
echo '<u>' . 'Date:' . '</u>' . ' ' . $row1['timestamp'] . ' ' . '<u>' . 'Author:' . '</u>' . ' ' . $row2['firstname'] . ' ' .
$row2['lastname'] . '<br>';
echo $row1['news'];
}
}
displaynews(5);
?>