here i have 3 tables. i want to display OfferDescription,OfferImage,offerPath based on spaid.becaz offerimage and offerdescription are added by using array.so its in different table.
if i add companyname and 2 offerimage and 2 offerdescription its added in this 3 tables.after i have to display based on spaid value.i tried but its taking multiple. i d't know which query i have to use. give some suggestion
SELECT `id`, `OfferDescription`, `spaid` FROM `offerdescription`;
SELECT `offimgid`, `OfferImage`, `offerPath`,`spaid` FROM `o dffersimagegallery`;
SELECT id,companyName FROM spa;