[SOLVED] SOLVED: Code not working

[sp@rky13]

Here's my code:

 

<?php
$con = mysql_connect("****","***","****");
if (!$con)
{
   die('Could not connect: ' . mysql_error());
}

mysql_select_db("******", $con);
$result = mysql_query("SELECT * FROM village9
JOIN player9
ON village9.player = player9.id WHERE player9.name = 'gianni23';") or die(mysql_error());
if($row = mysql_fetch_array($result))
{
echo $row['x']."|".$row['y']." "; 
}
mysql_close($con);
?>

 

It returns only one results instead of about 500. Why is that?

Note: I would have posted this in the mysql section but no one replies there so there's no point, sorry

[Maq]

Change this:

 

if($row = mysql_fetch_array($result))

 

to this:

 

while($row = mysql_fetch_array($result))

 

How do you expect to traverse through the result set without a loop?

[sp@rky13]

Thank you very much. Solved See what I mean by quick replies

 

EDIT: Where's the solved thingo?