Msg#: 4209719 posted 4:25 am on Oct 1, 2010 (gmt 0)
hi, i have a query that post articles in mysql. now i want to query the latest post but not the newest article. e.i. post id 1 <--inserted first post id 2 <--inserted second post id 3 <--inserted third ------------------------- so when i run the query it should display the ff in DESC: ------------ post id 2 ------------ post id 1 ------------ 'coz post id 3 is the newest and they are being viewed in the same page. (so no need to post id 3 again.) hope someone can help :D P.S. (i need the query)
Msg#: 4209719 posted 1:18 pm on Oct 1, 2010 (gmt 0)
thanks for the reply, fields will be title,content,date its like a mimic of wordpress latest post except that it doesn't show the newly inserted post.. so it will like -1 for the id to be called.. hope you'll help me. thanks!
Msg#: 4209719 posted 5:00 pm on Oct 4, 2010 (gmt 0)
While that works, it could potentially break if there are any mods to the database in future updates . . . you should use the inherent WP functions. Additionally min and max are evaluation functions, if you go that route you can save overhead by just doing ".. order by id desc limit 1,1" (will pull one record starting with the second record, 0 is record one.)
Though they say in the documentation to include wp_head for external pages, you only need to include wp_load to make Wordpress functions accessible externally.
Msg#: 4209719 posted 3:29 am on Oct 5, 2010 (gmt 0)
thanks man! although im using this on a small site, i think i will just update the code. And im not using WP, its my own cms in php. anyways, i'll try to know more about this. thanks for the code though. cheers!