List:General Discussion« Previous MessageNext Message »
From:Mike Date:April 17 2002 10:49pm
Subject:Re: print on top
View as plain text  
Sorry, I forget the column name for the ORDER BY

> $Query = "SELECT * from $TableName ORDER BY column_name DESC";

Mike
----- Original Message -----
From: "Mike" <mike@stripped>
To: <mysql@stripped>; "Jule Slootbeek" <jslootbeek@stripped>
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" <jslootbeek@stripped>
> To: <mysql@stripped>; <php-general@stripped>
> 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
> > jslootbeek@stripped
> > 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 <mysql-thread106440@stripped>
> > To unsubscribe, e-mail <mysql-unsubscribe-mike=wkla.com@stripped>
> > 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

Thread
print on topJule Slootbeek18 Apr
  • Re: print on topMike18 Apr
    • Re: print on topDan Nelson18 Apr
  • RE: print on topGurhan Ozen18 Apr
Re: print on topMike18 Apr