Is your schema already fixed?
If not, the normal way to do this would be to have m-m join tables:
NewsImage [ news_id, image_id ]
EducationImage [ education_id, image_id ]
HealthImage [ health_id, image_id]
and remove:
content_id
type
from the ContentImage table.
Then if you want all news
Hi,
Thanks for your reply.
I cannot change my table structure.. I need to use the existing
table..
regards
Shihab
On Sep 7, 8:55 pm, Phil Moorhouse moorhouse.p...@gmail.com wrote:
Is your schema already fixed?
If not, the normal way to do this would be to have m-m join tables:
NewsImage [