Reading Query

lives4him06

so in the MySQL Command Line Client

select distinct type from files;

results in:

+------+
| type |
+------+
| mp3 |
| wma |
+------+
2 rows in set (0.00 sec)

When in a php script i execute the following code:

 
$query = "select distinct type from files;"; 

$result = mysql_query($query)  or die (mysql_error()); 
$row = mysql_fetch_array($result);

Foreach ($row as $key => $val )
{
    echo $val;
}

the result is:

mp3mp3

Why is it not:

mp3wma

dgrinberg

Because you are not looping through the resultset. You are only getting one row.

Try something like:


while ($row = mysql_fetch_array($result))
{
    echo $row[0];
}

mysql_fetch_array only gets one row at a time.

lives4him06

i copied and pasted this code and it only prints:

wma

dgrinberg

Sorry...

Remove the first call of mysql_fetch_array.

Full code should be

 $query = "select distinct type from files;";

$result = mysql_query($query)  or die (mysql_error());

while ($row = mysql_fetch_array($result))
{
    echo $row[0];
}