Hi,
I have a db containing ids(primary key), subject,date and contents.
I made a table showing subjects
echo'<ul>';
for($i = 0; $i < $count; $i++) {
//echo'<table cellpadding=0 cellspacing=5 border=0 width=95%>';
$rows = mysql_fetch_assoc($result);
echo'<li><a href=\>',$rows['subject'];
//echo'</tr>';
//echo'</table><br>';
}
echo'</ul>';
The problem i am facing are
1.I want to display the subjects according to date(in ascending order)
2.I need only 4 subjects to be shown on the page
3.I need to link subjects to the respective contents using id.
Please help
