list last entries on database

[jd57]

Hi Everyone

I'm looking for a script that will list the last 20 entries from a mysql database, can anyone on the list help me ?

[laserlight]

Record the datetime of each entry, then do a:

SELECT column_names FROM table_name ORDER BY datetime_column DESC LIMIT 20;

[jd57]

Hi
I'm getting a parse error, unexpected T_STRING in / on line

echo $row['Bloom_Name']."<br>";

any suggestions?

<?PHP

mysql_connect("localhost", "xxx_xxx", "xxxx") or die(mysql_error());

mysql_select_db("xxxx_xxx") or die(mysql_error());

$sql = SELECT Bloom_Name FROM ihsreg ORDER BY Bloom_Name DESC LIMIT 20;

$results = mysql_query($sql);

while(($row = mysql_fetch_assoc($results)) !== false){

echo $row['Bloom_Name']."<br>";

}

?>

[jd57]

ok thanks. I got it working

[jd57]

Hi
It's me again, one more question, what if I want list two fields , Id and Bloom_Name? I have tried 'id', 'Bloom_Name' but it doesn't work, can you please help.
Thanks JD

<?PHP

mysql_connect("localhost", "xxx_xxxx", "xxxx") or die(mysql_error());

mysql_select_db("xxxx_xxx") or die(mysql_error());

$sql = "SELECT * FROM `ihsreg` ORDER BY `Bloom_Name` DESC LIMIT 20";

$results = mysql_query($sql);

while(($row = mysql_fetch_assoc($results)) !== false){

echo $row['Bloom_Name']."<br>";

}

?>

[TF_TheMoon]

You want

$sql = "SELECT id, Bloom_Name FROM ihsreg ORDER BY Bloom_Name DESC LIMIT 20";

So what you were trying but without the ''