[maulikmewa]

hello there


i have came across a problem in mysql query the problem is such that i have two table

1. user : which has id,firstname,lastname,city_id,state_id and cityarea_id where i store

the ids of cityarea in comma spaerated manner in field cityarea_id

2 city area with id,citareaname,city_id and area_direction

user

id firstname lastname city_id state_id cityarea_id
1 abc xyz 1 2 2,4,6,8,9
2 cvd ads 1 2 12,4,5,7,9
2 sdd afs 1 2 2,4,6,99
2 red ahs 1 2 12,14,5,17,9

cityarea
id citareaname city_id area_direction
1 ggg 1 North
2 bbb 1 west
3 ccc 1 west
4 ppp 1 East

i want to show lsit of users in tabs according to thier direction of areas,at the same time a user who has selected area of north and east should been in both the tabs.


pls help me out!!!