[RESOLVED] Implode works but problem in how it displays

[MystedVeil]

      echo"<b>Genre</b>:";
 $result = mysql_query("SELECT wgenre.*, wrelgenre.*  FROM wgenre, wrelgenre WHERE wrelgenre.wcontent_id = $row[wcontent_id] AND wrelgenre.wgenre_id=wgenre.wgenre_id "); 

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

foreach ($genre as $key => $value) {
   if ($value == NULL) { unset($genre[$key]); }
}

$data = implode(", ", $genre); 

 echo"$data";

Now it is showing the data as
Genre: 1, 10

I would like it to display as
Genre: Adult, Mature

if anyone could point in the right direction it would be greatly appreciated.
The tables are wgenre (wgenre_id, genre) and the relation table which links it to content wrelgenre (wrelgenre_id, wgenre_id, wcontent_id) as many pieces will contain multiple genres.

[devinemke]

1. your code is displaying the wgenre_id numbers, not the genre name because that is the first field in the table (which you specified by using $row[0]).

2. there is no reason to do the NULL check in PHP, do it in the query itself

$result = mysql_query('SELECT wgenre.*, wrelgenre.* FROM wgenre, wrelgenre WHERE wrelgenre.wcontent_id = ' . $row['wcontent_id'] . ' AND wrelgenre.wgenre_id = wgenre.wgenre_id AND wgenre.genre IS NOT NULL') or exit(mysql_error());
$genre = array();
while ($row = mysql_fetch_assoc($result)) {$genre[] = $row['genre'];}
echo '<b>Genre</b>: ' . implode(',', $genre);

[MystedVeil]

It works, thank you very much. Still learning and every bit helps!

[Weedpacket]

If all you're fetching is the genre then there's no point in selecting every field from both tables; the only reason you might need to do that is if you really do want every field from both tables and you don't know exactly what those fields are.

SELECT wgenre.genre FROM ....

Then you could have used $row[0].