Re: [PHP-DB] Outputing Distinct rows

2002-02-10 Thread Jason Cox
Steve, Looks like your missing your FROM portion of your query. That's pretty important. Also, how do you know when a post is new? Are you just assuming that if the database returns it with your LIMIT condition that it comes off the top of the list and is new? I don't think that's too reliabl

[PHP-DB] Outputing Distinct rows

2002-02-09 Thread KingZeus
I'll give you all the short version of what I need and if it is enough for you to help that would be great. I need to pull the last 10 updated topics from a table and output them. However, the posts table lists each post and then has a topic id. There is also a table of topics with topic id, title