IwnfuM Posted December 17, 2010 Share Posted December 17, 2010 hey , just to know i need to express those words to MySQL syntax. 1.select last 10 from 'table'. 2.select last 10 from 'table' where id = '2'. thanks. Link to comment https://forums.phpfreaks.com/topic/221995-syntaxing/ Share on other sites More sharing options...
Maq Posted December 17, 2010 Share Posted December 17, 2010 Sounds like homework. 1.select last 10 from 'table'. Assuming you have a date column: ORDER by [date] DESC LIMIT 10; 2.select last 10 from 'table' where id = '2'. Same as the last query except the WHERE id = '2' condition. All if this syntax is in the MySQL manual. Next time read it so you can learn for yourself. Link to comment https://forums.phpfreaks.com/topic/221995-syntaxing/#findComment-1148727 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.