I would be greatfull is somebody could help me. Ok vut a long story short I am trying to create a website which has the facility of a database driven banner system, on either left and right hand side of any page. the purpose of this is so that any banner can be displayed on either page or either side.
Ok, my sql tables are:
colums: id, name, lnk,visible
the unique identifier between both tables is menu.id and lnk_tblmenuid
i have done this hoping to set it up as a one to many relationship i.e one menu to many banners. I have spent all day trying to figer it out. im not too sure if this is the way I should be doing this. please advise
if somebody could come up with a query that would be great thanks