sql query to show recently added items

[bobicles2]

Is this possible?

 

im looking to display the top 10 most recently added items to my table on the homepage

 

any ideas? thanks

[MadTechie]

add a timestamp field and then ORDER BY timestamp DESC LIMIT 10

[bobicles2]

add a timestamp field and then ORDER BY timestamp DESC LIMIT 10

 

just adding the field now, does it need any particular variables, or will it be added naturally ive set the field type to TIMESTAMP

[MadTechie]

if you set the default to current_time/NOW() it should be fine

[bobicles2]

if you set the default to current_time/NOW() it should be fine

 

mysql_connect(localhost,$username,$password);

@mysql_select_db($database) or die( "Unable to select database");

$query="SELECT * FROM Events ORDER BY timestamp DESC LIMIT 10";

$result=mysql_query($query);

$num=mysql_numrows($result);

 

i use this, and it works and echo's everything fine when i used the query

 

SELECT * FROM Events

 

but doesnt work with the new query despite me having a timestamp field in my database having the default as timestamp i checked my databse and when i add an entry the timestamp is added so im not sure whats going wrong

[MadTechie]

if SELECT * FROM Events ORDER BY timestamp DESC LIMIT 10 works why are you using  SELECT * FROM Events  ?

[bobicles2]

if SELECT * FROM Events ORDER BY timestamp DESC LIMIT 10 works why are you using  SELECT * FROM Events  ?

 

sorry i meant it to mean it doesnt work... but when i used Select * From Events it works fine.. so theres a problem with the query

 

ive solved this now though using a different method..i have a field for ID which is set to auto increment so just changed it to display the 10 highest ID's (which are obviously the most recently added events)

 

thanks for the help though much appreciated!

[MadTechie]

Query looks fine, while ordering by prime ID will work, you may run into trouble if you need to update the code to order by recently updated!