December 7, 2007 at 4:49 am
Hi,
I have a table called node which contains field as type(type field includes data such as forum,travelbag,video,image,blog),nid,title,uid.
For each of the type contained in the node table it contains separate table to store information relating to the particular type.For eg:A table called travelbagcontent contains
the information that are added frequently to the travelbag.
I have some records for eg:countryname,tourist places etc..in
travelbagcontent.
I want to retrieve where all the countryname appears in the type.For eg:If travelbag contains countryname i want to retrieve the records having the same countryname wherever it is present.
How can the corresponding query written for the above.
Thanks in advance
December 7, 2007 at 4:57 am
I doubt, I could understand your query well enough to answer. It would be better if you can provide a sample script with table structures, sample data and the required output.
--Ramesh
December 7, 2007 at 5:20 am
table:travelbagcontent
tbid int
nid int
uid int
name varchar
description text
recordurl text
etc...
table:node
nid int
vid int
type varchar
title varchar
uid int
status int
etc...
table:node_revisions
nid int
uid int
title varchar
etc...
type contains data like forum,blog,travelbag,picture,video
For eg:In the application it contains several options like
add to travelbag,blog this,add picture or video.
When u click on add to travelbag it wil show list of travel bags.
U can choose which travelbag u want.When u clcik any travelbag it will list what all contents that are available in that particular travelbag.A particular travel bag may contain same thing that is present in another travel bag.I want to find out what the list of same thing available in all travel bags.
There are separate tables for each type
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply