MySQL Results

[Anon]

Hi!
I want to make a script, which displays only last 40 mySQL database entrys. I'm currently using:

$connection = mysql_connect("xx","xxx","xxx")
or die("Couldn't make connection.");

$db = mysql_select_db("xxx", $connection) or die("Couldn't select database");

$sql = "SELECT headline, news, poster, email, date, time
FROM news_table";

$sql_result = mysql_query($sql,$connection) or die("Couldn't execute query");

//while ($row = mysql_fetch_array($sql_result)) {

$headline = $row["headline"];
$news = $row["news"];
$poster = $row["poster"];
$email = $row["email"];
$date = $row["date"];
$time = $row["time"];

while ($row = mysql_fetch_array($sql_result)) {
$headline = $row["headline"];
$news = $row["news"];
$poster = $row["poster"];
$email = $row["email"];
$date = $row["date"];
$time = $row["time"];

and so on...
but I don't know, how to display only 40 latest entrys...

[Anon]

If you dont already, make an additional row that will serve as an id. then in your SELECT query just use something like this:
$sql = "SELECT headline, news, poster, email, date, time
FROM news_table WHERE id >= 40";

Derek Meiresonne
[e-mail]
www.etecc.com

[[deleted]]

If you don't care about the order or your results,
use ORDER BY date DESC to list the results from latest to oldest,
and use LIMIT 40 to get only the first 40 results.

SELECT headline, news, poster, email, date, time
FROM news_table
ORDER BY date DESC
LIMIT 40

[Anon]

Thanks, but I care about order of my results... Is there any way to just invert results, eg. entrys a b c are now c b a??