[RESOLVED] Array from Database problem

[Staggy11]

I'm trying to print a list of names from a database. I want to print the 'name' data of each row that matches a certain criteria. I have two rows which match the criteria, but only the first is printed. Here is my code:

<?
$result3=array();
$query = "SELECT name FROM players WHERE x = ". $object[5]->x ." AND y = ". $object[5]->y ."";
   $result2 = mysql_query($query) or die(mysql_error());
     $result3 = mysql_fetch_array($result2) or die(mysql_error());
       $num = mysql_num_rows($result2) or die(mysql_error());

$id=0;
while ($id<=$num)
{
print_r($result3[$id])
print_r(",");
$id += 1;} 
?>

The output should be

Bob,Bill,

, but is instead

Bob,,,

.
Any suggestions as to what I can do to fix this?

[tsinka]

Hi,

each call to mysql_fetch_array fetches the next row in a record set. In your case you just select the field named "name" so each array returned by mysql_fetch_array just contains one column.

Your code tries to print n columns of the first record. A better solutions is:

<?
$query = "SELECT name FROM players WHERE x = ". $object[5]->x ." AND y = ". $object[5]->y;
$result = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_array($result))
{
  echo $row[0].',';
  // also possible: echo $row['name'].',';
}
?> 

which allows you to use the column name (or column alias) instead of an index.

Regards,
Thomas

[Staggy11]

Cheers! It works perfectly now, and even solved another problem that I had! Thanks!