I need to grab information from multiple tables and it doesnt seem to work. I need to grab other info from a table named users and I named all of the fields a different name as well so they would not overwrite each other. Here is the code where I am calling it:

PHP Code:
$sql="SELECT * FROM team WHERE staff_user='$myusername' and staff_pass='$mypassword'";





$row mysql_fetch_assoc($result))








Any idea? I tried to do a SELECT * from team, users but it gave me an error.