Sorry, I forget the column name for the ORDER BY
> $Query = "SELECT * from $TableName ORDER BY column_name DESC";
Mike
----- Original Message -----
From: "Mike" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "Jule Slootbeek" <[EMAIL PROTECTED]>
Sent: Wednesday, April 17, 2002 6:45 PM
Subject: Re: print on top
> use ORDER BY ASC or DESC
>
> $Query = "SELECT * from $TableName ORDER BY DESC";
>
> Mike
> ----- Original Message -----
> From: "Jule Slootbeek" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Wednesday, April 17, 2002 6:38 PM
> Subject: print on top
>
>
> > 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
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02
>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02
---------------------------------------------------------------------
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
