How can I display an unordered list(<ul></ul>) with 30 entries from a database? They enteries ned to be the most recent with the 1st one being the newest I kmnow I need to use loops but am getting very confused
Cheers

PS: I have a table called gallery with the following fields id(primary), imgTitle, fileName, author,authorAddress, createDate(date)

This should work:

	$query = "select * from gallery Order by '$creatDate"; 
 
$result = mysql_query($query);
$size_results = mysql_num_rows($result);
 
echo "<tr><font size='1'>\n";
while ($row = mysql_fetch_array($result,MYSQL_ASSOC) )
 
{
 
echo "<TABLE 'BORDER-COLLAPSE: collapse' cellSpacing=0 cellPadding=2 width='100%' border=0 align='center'>\n";
 
 
	echo "<td>	{$row['id']},<value=$id></td>\n";
 
	echo "<td>	{$row['imgTitle']},<value=$imgTitle></td>\n";
 
	echo "<td>	{$row['fileName']},<value=$fileName></td>\n";
 
	echo "<td>	{$row['author']},<value=$author></td>\n";
 
	echo "<td>	{$row['authorAddress']},<value=$authorAdress></td>\n";
 
	echo "<td>	{$row['createDate']},<value=$createDate></td>\n";
 
 
}
 
echo "</table>\n";

Thank you KML.
I tried it and this is what I got back:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\apachefriends\xampp\htdocs\My_Web_Projects\Stra ngeDarkness-V2\poetry.php on line 63

"select * from gallery Order by '$creatDate";

add an extra ' to the end of that:

"select * from gallery Order by '$creatDate'";

ah yes of course! Give me a few weeks and I might understand what im doing heh heh

And if I completly understood what I was doing I wouldn't have forgotten the other single quote . It's taken me a few months (and help from a bunch of people here) to be able to get far enough to offer help occassionally!

I'm glad it worked for you after a minor edit!