A little SQL Help please...

[Runnion]

$query  = "SELECT users.userID, users.username, users.firstname, users.lastname, useraddress.address, useremail.email, userphone.phone, userpostal.postal, userlocation_master.cityID, userlocation_master.stateID, userlocation_master.countryID";
$query .= "FROM users, useraddress, useremail, userpostal, userlocation_master, userphone";
$query .= "WHERE users.userID = '$userID' AND ";
$query .= "useraddress.userID = '$userID' AND ";
$query .= "userpostal.userID = '$userID' AND ";
$query .= "userphone.userID = '$userID' AND ";
$query .= "userlocation_master.userID = '$userID' AND ";
$query .= "useremail.userID = '$userID';";

I can't seem to find the sql error in this. Can anyone else see it?

[ultraslacker]

Spaces are a good thing - echo the query to see what's wrong. But anyway, why not just use -

$query = "SELECT users.....
FROM balh
WHERE labclas
ORDER BY woo";

semicolon is not needed in string.

[Runnion]

heh, sometimes i'm stunningly brilliant. other times.... well... see above.