Need help on an sql query

[silverd]

Little stumped.

I want to display all posts that contain an [IMG] tag and are not in a deleted thread.

Something like:

SELECT * FROM post WHERE pagetext='[img]' WHERE thread.threadid=post.threadid AND thread.visible=1

--------------- Added [DATE]1307553941[/DATE] at [TIME]1307553941[/TIME] ---------------

still trying

SELECT * FROM post WHERE pagetext LIKE '%[img]%' WHERE post.threadid=thread.threadid AND thread.visible = 1

[BirdOPrey5]

You need to JOIN the thead table onto the post table...

Try

SELECT * FROM post, thread WHERE post.threadid=thread.threadid AND pagetext LIKE '%[img]%' AND thread.visible = 1

[silverd]

SELECT pagetext FROM post, thread WHERE pagetext LIKE '%[img]%' AND post.threadid=thread.threadid AND thread.visible = 1

^^^
that got it workin