[PHP/MySQL] How to show all mysql output in php?

[myliquid]

how to show all mysql table output?
ex.:
$query=mysql("select name from account where score='9'");

i want ouput who have score 9 :

peter
jack
teddy

anybody know how? help please?

 

[andrew951]

Re: Help, how to show all mysql output in php?

while(mysql_query("select NAME from ACCOUNT where SCORE='9'")) {
echo
}

something like that. i forget all the needed info, but thats the basic.

 

[Jackel]

Re: Help, how to show all mysql output in php?

That's not going to work. mysql_query() only returns a resource.

 $query = mysql_query("SELECT name FROM account WHERE score = 9");

 while ($data = mysql_fetch_array($query))
	{
	echo $data['name'] . "<br />";
	}

 

[myliquid]

wow, it's work, thank's for help....