Hey guys and gals,
I'm writing this script for my new webpage, and i'm using MySQL to read and
add news articles to a page, but everytime i add a new article it puts it
under the older one, how can i get it on top?
thanks
Jule
$Link = mysql_connect ($Host, $User, $Password);
$Query = "SELECT * from $TableName";
$Result = mysql_db_query ($DBName, $Query, $Link);
while ($Array = mysql_fetch_array ($Result)) {
print ("<table border=0 align=center valign=top width=100%>");
print ("<tr align=center valign=top>\n");
print ("<td align=left valign=top><b><i>$Array[header]</i></b></td>\n");
print ("</tr>\n");
print ("<tr align=center valign=top>\n");
print ("<td align=left valign=top>$Array[article]</td>\n");
print ("</tr>\n");
print ("<tr align=center valign=top>\n");
print ("<td align=right valign=top><font size=-2>Posted by: $Array[name] on
$Array[postdate]</font></td>\n");
print ("</tr>\n");
print ("</table>");
--
Jule Slootbeek
[EMAIL PROTECTED]
http://blindtheory.cjb.net
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
