List:General Discussion« Previous MessageNext Message »
From:Mike Date:April 17 2002 10:45pm
Subject:Re: print on top
View as plain text  
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

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