I would like to do something rather complicated for a type of classifieds site.
Basically, after a user creates a post in a certain category, that category is added to an SQL table. Let's assume the category is called "Books."
I want the title of the user's post to be posted in the "Books" section, along with all other posts in this category. Then, when someone clicks on the title of the post, its actual content is displayed in a different page (pretty much like Craigslist, but my site will differ in many other ways). How do I go about creating each page?
For the first page with the titles, I was thinking about doing:
$query = mysql_query("SELECT * FROM posts WHERE section='Books'")
and then somehow echoing the title for each row that meets this criterion. How can I do this?
I'd also appreciate any advice for the site at large.
Thanks a lot. And let me know if I'm not being clear I'll explain in more detail
Just to clarify, this is a sample of a first page I have in mind http://toronto.craigslist.ca/bar/ (all the titles of posts in the "barter" category are posted on this page)