Im trying to only get the gender of "Male" from this
$sql = "SELECT shocc_users.city, shocc_users.state, shocc_users.username,
shocc_users.rating,shocc_users.age,shocc_users.ethnicity,shocc_users.gender,shocc_users.starsign,
shocc_account_photos.photo_filename,shocc_active.time
FROM shocc_users
JOIN shocc_active
ON shocc_users.username = shocc_active.username
JOIN shocc_account_photos
ON shocc_users.username = shocc_account_photos.username
WHERE main=1
AND gender = Male <-- Doesnt work
ORDER BY rand()
In shocc_users their is a coloum named gender
and also in shoc_active their is a colum named gender
How can i add to this query to get the male gender? I have tried multiple ways and it just says the colums are ambigous or gives me a sql error
