mysql help needed......

[harshasoon]

loku udauwak one oyalagen...

me database eake 'matara & software' kiyala search kalama,kamal list wenna one..both keyword should be match..client keyword table eakata link wela tiyenne..

 

[harshasoon]

plllllllllllllllzzzzzzzzzzzzzzzzzzzzzzzzzz help meeeeeeeeee

 

[cyberDil]

mathaka na
bump

 

[Maga Maruwa]

Godak hithanna wena prashnayak machan...
hm.....balamu

 

[harshasoon]

ane hithala balala kiyapankooooo

 

[kkr]

BUMP ! ! !

 

[v7soft]

ube schema aka penne na ban oka penna dapan

 

[platinumweb]

SELECT $search1 AND $search2 WHERE table name

 

[harshasoon]

client
cid name
1 kapila
2 amila
3 ajith
...

keyword
kid cid keyword
1 1 kapila
2 2 huawei
3 1 matara
4 1 software
...

oyawage tiyenne
......

 

[harshasoon]

SELECT $search1 AND $search2 WHERE table name

na ban where close eake enna one...
foreign key 2k ho wadi ganak search wenna one..

 

[blackcatcyb]

SELECT cl.Name
FROM client cl, keyword kw
where kw.keyword='Matara' and kw.keyword='Software' and cl.cid=kw.cid

Mata problem eka teruna widiyata nam query eka oya widiyata tama enna oni

 

[harshasoon]

macho...oyavidiyata dammoth hariyanna...mokada keyword godak unath gahala search karanna puluwan 'where kw.keyword =...'

 

[blackcatcyb]

macho...oyavidiyata dammoth hariyanna...mokada keyword godak unath gahala search karanna puluwan 'where kw.keyword =...'

keyword keeyak gahanna puluwanda????

 

[blackcatcyb]

where kw.keyword in ('Matara','Software','ABC',.....)

try this

 

[harshasoon]

will it work with foreign keys..i'll try that macho..thank u honde