Welcome Guest, Not a member yet? Register   Sign In
Multiple table problem
#1

[eluser]bondjp[/eluser]
I have a problem getting data from multiple tables and i just don't know where to begin.
Data:

table user
userid
username
useraddress
city


table skill
skillid
skillname
userid

table car
carid
carmodel
userid


I have a form where i ask for:
skill
city
carname

So what i need is to get all users who have the selected skillname, live in the selected city and that drove the carmodel.
Thanks
#2

[eluser]danmontgomery[/eluser]
Code:
SELECT user.*
FROM user
JOIN skill ON skill.userid = user.id
JOIN car ON car.userid = user.id
WHERE user.city = 'Some City' AND skill.skillname = 'Some Skill' AND car.carmodel = 'Some Car'




Theme © iAndrew 2016 - Forum software by © MyBB