Hi Barry > $query = "SELECT * FROM xoops_album,xoops_artist WHERE > xoops_album.artist_id = xoops_artist.artist_id";
If you only need two fields, it is not necessary to retrieve all fields $query = "SELECT xoops_album.album, xoops_artist.artist FROM xoops_album, xoops_artist WHERE xoops_album.artist_id = xoops_artist.artist_id"; $albumby = mysql_query($query) or die("Select Failed!"); Your resultset contains then the only two required fields. echo"<td><center>"; if (mysql_num_rows($albumr)) { while ($album = mysql_fetch_array($albumr)) { echo "$album[album] <i>by $album[artist] </i><br>"; // new line } echo "</center></td>"; } Hope it helps Conni -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php