need help ..
Posted 19 October 2006 - 01:03 AM
I was thinking maybe somehow doing a while statement on the topics and running a while statement within that for the replies. After typing all that out thinking it would work, I was then missing some topics that were just made.
I've coded (and helped code) 3 different forums now. I've had no problem with this before but for some reason my brain just isn't working now. I've lost all my old stuff and can't figure out what I did. Can somebody help please? Please don't make me study forums
Posted 19 October 2006 - 01:11 AM
asc <<< asending.
((EMAIL CODE THAT WORKS))
((PAYPAL INTEGRATION THAT WORKS))
Posted 19 October 2006 - 01:38 AM
Posted 19 October 2006 - 02:36 AM
ORDER BY reply_date DESC, topic_date DESC
again, tough to tell what you're after.
Posted 19 October 2006 - 02:40 AM
Next, whenever a reply is added to a post, update the date_modified field to the current timestamp.
Then... simply run your query and ORDER BY the date_modified field.
Posted 19 October 2006 - 03:08 AM
Thanx for the SQL help though akitchin!
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users