Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Help building query (grouping etc.)
Fixed it! No help needed, thanks anyway. Pretty ugly query in the end...but i'll post it for laughs ------------------------------------------------ SELECT forummessages.id, forummessages.subject, forums.readaccess, COALESCE(MAX(replies.id), MAX(forummessages.id)) FROM forummessages LEFT... -
can't figure this query out in mySQL
I dont know exactly the php syntax, but I guess the easisest way is just making sure your table is sorted on the item column first item1 keyword1 item1 keyword2 item2 keyword2 item3 keyword3 item3 keyword2 Then when you create the html, as you step through the result set from this... -
Help building query (grouping etc.)
I'm doing a simple forum for a website. In the list of messages, the relevant fields are, id and parent. For new threads, the parent column is set to -1, and for replies, the parent column is holding the id of the message replied to (simple, eh?). The problem now is when I want to make a...
