I'm trying to run a cron job to delete forum topics more than 2 hours
old. I know how to do that, but the problem is also deleting the posts
in the topic at the same time. Can someone shed some light on this, please?
--
The above message is encrypted with double rot13 encoding. Any
Sounds to me like you didn't understand the question. The table
structure is something like:
topics_
| id | forum | author | subject | posttime |
-
_posts
| id | topic | author | message | posttime|
Leif,
Sounds to me like you didn't understand the question. The table
=two sides to every story: either I'm too thick to understand, or you didn't
explain sufficiently - or both... see problem with necessarily open-ended
answer given below and consider...
structure is something like:
[snip]
=others, eg MySQL, do not, and thus unless MySQL's last DELETE format
option
works sufficiently well, the best option might be two DELETE's: the
first
per your suggestion above and the second to remove all entries in
posts
that
no longer join to a topics row.
But you can't join on a