listing in reverse order

longbow

hello i have been doing PHP for about 4 months now i have the basics down like stting up functions and logging into Mysql 3 and basic mysql executions. but the book i am useing does not tell me how to list a database in php in reverse order.

ex. db

ID text

0 hello
1 there
2 people

the script i am useing would print "hello there people"
i want it to print "people there hello"
this is only an example but that is what i would like it to do
can any one help
the code i am useing is as follows

<?php
$conn = mysql_connect("localhost", "username", "password");
mysql_select_db("test",$conn);
$sql = "SELECT * FROM welcome";
$result = mysql_query($sql, $conn) or die(mysql_error());
while ($newArray = mysql_fetch_array($result)) {
$testField = $newArray['welcome'];
echo "$testField <br><br>";
}
?>

thanks Longbow

LordShryku

See "order by"

Frederick

Placing ORDER BY into your query will list the items they way you choose.

Example: List last name first then first name
SELECT * FROM tablename ORDER BY last_name,first_name,id

Example: list by id reversed
SELECT * FROM tablename ORDER BY id DESC

longbow

i am getting a "Query was empty" statement with the
{SELECT * FROM tablename ORDER BY id DESC} syntax
any ideas ?

Frederick

what are your field names

amcgrath

One other thing you may want to consider is to add a create_date column with a default of sysdate and use this to order by. I guess it doesn't really matter, but it does look cleaner.

amc

longbow

Originally posted by amcgrath
One other thing you may want to consider is to add a create_date column with a default of sysdate and use this to order by. I guess it doesn't really matter, but it does look cleaner.

amc

but what is the code that i use to retreive the data in the reverse order?