mySQL/PHP show all info?

hi,
i’m new to mySQL and PHP, i have a mySQL database and i’m using php to extract the information from it. Its working fine except i can only view one row.
For example i have 3 rows as follows:

Name,email,password
name,email,password
etc,etc,etc

i can view the first row but the other two i cannot. I know its something to do with my php…I’m pretty sure it should look something like the following:

$result = mysql_query(“SELECT * FROM users”,$db);

echo???

what would i echo??

Thanks everyone, i’m sure its an easy solution for those of you who know what you’re talkin about!