I am trying to complete a subquery where I gather all the records for users who like a certain team. I have searched for a couple of hours online and can't find anything except subquery problems for users that are using an older version of MySQL -- I am using version 5.0.

Please help... the code is below:

$query = "SELECT userid,team FROM favteams WHERE userid = (SELECT userid FROM favteams WHERE team='uga')";
$result = mysql_query($query);

while ($row = mysql_fetch_array($result)){
    echo $row["userid"]."<br>";
}

hi,
from your query i can understand, you are trying to get only userid.
simply SELECT userid FROM favteams WHERE team='uga'
you will get the userid, and team will be uga,
what you are trying to do?

surendran
(Anything is Possible)
http://ssuren.spaces.msn.com