Can a query do this?

[Night Owl]

One of the administrators on my site had several items stolen from her house, including her computer with a year's worth of family photos. So now, the only ones she has left are those that she posted on our forum. I would like to find those for her.

Would be possible to write a query that I could run in phpmyadmin and that would pull up all the posts by her that have an attachment? If so, could someone who is better at query writing than me write one out?

I am running a heavily hacked VB 2.x forum, btw.

Thank you!

[Xenon]

SELECT * FROM post WHERE userid = xx AND attachmentid > 0

[Paul M]

You can view all your attachments in your usercp.

[Night Owl]

Thank you very much, Xenon!

[Xenon]

You can view all your attachments in your usercp.


was that possible in vb2?

don't remember that feature, but it has been a long time

@Night: you're welcome