Code: Select all
<?php $page_title = 'NMIS';
?>
<?php
require_once ('../mysql_connect1.php');
$page_title = 'view';
$query = "SELECT * FROM notices order by date desc limit 6";
$result= mysql_query($query);
echo '<table border="0" width="90%" cellspacing="3" cellpadding="3" align="center">
<tr>
<td align="left" width="100%" bgcolor="#00659C"><b><font color=white><center>Notice Board</center></font></b></td>
</tr>';
echo '</table>';
if (mysql_num_rows($result) > 0)
{ // if there are any rows of data, fetch the data
$row = mysql_fetch_array ($result);
echo'<div align=\"center\"><img src=\"../uploads/". $_SESSION['user_id'].".jpg\" />';
echo '<p>Subject: ' . $row['subject'] . '<br />';
echo '<p>Date: ' . $row['date'] . '<br />';
echo '<p>Notice: ' . $row['notice'] . '<br /><br />';
echo'<a href=\"disnotice.php?uid={$row['notice_id']}\">full description</a>';
echo " <a href=\"prevnotice.php\"><center>Previous Notices</center></a></br>";
echo " <a href=\"latestnav.php\"><b>Click here</b></a> to check latest notes,assignments,books.";
}
else
{
echo '<p>No data returned!</p>';
} // mysql if end
?>records 1
......records2
....
records....
but i want to display records as follows where do i need to change(off course making table)
i tried but didnt got exact result...
i want to display as follow
3 in first
then another 3
records1 record2 record3
records4...

any help?
thanks