mysql - mysql_fetch_assoc to echo linked table results with php -

using php, trying link results 3 tables connected same value. each dynamic set of related results repeat while loop on page. result like:

artist->

series1->piece1, piece2
series2->piece3, piece4

artists , series tables share matched column named 'artist'. series , piece table have matched column name 'series'. know these tables linked through same matched value in database on page cascade delete working.

currently shows series echo repeat loop no artist or piece related on either side. so: http://www.exhibitjewellery.com/artistindex.php

whether mysql_fetch_assoc right way, not sure. confused whether tables linking correctly @ or if problem how have divided body section formatting. have feeling multidimensional array may or nesting tables haven't quite grasped how details combine throughout each section of code. please help!

php above head:

<?php mysql_select_db($database_connectmysql, $connectmysql); $query_artistrecordset = "select * artists order artist asc"; $artistrecordset = mysql_query($query_artistrecordset, $connectmysql) or die(mysql_error()); $row_artistrecordset = mysql_fetch_assoc($artistrecordset); $totalrows_artistrecordset = mysql_num_rows($artistrecordset);  mysql_select_db($database_connectmysql, $connectmysql); $query_seriesrecordset = "select * series, artists series.artist=artists.artist order exhibition asc"; $seriesrecordset = mysql_query($query_seriesrecordset, $connectmysql) or die(mysql_error()); $resultseries = mysql_query($query_seriesrecordset); $row_seriesrecordset = mysql_fetch_assoc($resultseries); $totalrows_seriesrecordset = mysql_num_rows($seriesrecordset);  mysql_select_db($database_connectmysql, $connectmysql); $query_piecerecordset = "select * pieces,series pieces.piece=series.series order piece asc"; $piecerecordset = mysql_query($query_piecerecordset, $connectmysql) or die(mysql_error()); $resultpiece = mysql_query($query_piecerecordset); $row_piecerecordset = mysql_fetch_assoc($resultpiece); $totalrows_piecerecordset = mysql_num_rows($piecerecordset);   ?> 

this how have tried echo in body:

<div id="serieslist" align="right">      <?php echo $row_artistrecordset['artist']; ?><br />      <?php echo $row_artistrecordset['website']; ?><br />      <?php echo $row_artistrecordset['artist_statement']; ?><br />    <?php { ?>      <?php echo $row_seriesrecordset['series']; ?><br />      <?php echo $row_seriesrecordset['exhibition']; ?><br />      <?php echo $row_seriesrecordset['series_statement']; ?><br /> <?php { ?>       <?php echo $row_piecerecordset['piece']; ?><br />       <?php echo $row_piecerecordset['description']; ?><br />       <?php echo $row_piecerecordset['category']; ?><br />       <?php echo $row_piecerecordset['dimensions']; ?><br />       <?php echo $row_piecerecordset['price']; ?><br />           add collection button<br />            <?php } while ($row_piecerecordset = mysql_fetch_assoc($resultpiece)); ?>     <?php } while ($row_seriesrecordset = mysql_fetch_assoc($resultseries)); ?>       </div> </body> </html> <?php mysql_free_result($artistrecordset); mysql_free_result($seriesrecordset); mysql_free_result($piecerecordset); ?> 

any appreciated have been working on days!

firs recommend use object oriented php. keep on separate, secure page called db.php, or something:

//db.php <?php   function db(){     return new mysqli('replacewithhostname', 'relacewithusername', 'replacewithpassword', 'replacewithdatebasename');   } ?> 

now other page:

//other.php <?php include('db.php'); $db = db(); $nr = 'no results found'; $od = '<div>'; $cd = '</div>'; $br = '<br />'; $ar = $sr = $pr = ''; $artistrecordset = $db->query('select * artists order artist asc'); if(!$artistrecordset)die($db->error); if($artistrecordset->num_rows > 0){   while($row_ar = $artistrecordset->fetch_assoc()){     $ar .= $od.$row_ar['artist'].$br.$row_ar['website'].$br.$row_ar['artist_statement'].$cd;   }   $artistrecordset->free(); } else){   die($nr); } $seriesrecordset = $db->query('select * series, artists series.artist=artists.artist order exhibition asc'); if(!$seriesrecordset)die($db->error); if($seriesrecordset->num_rows > 0){   while($row_sr = $seriesrecordset->fetch_assoc()){     $sr .= $od.$row_sr['series'].$br.$row_sr['exhibition'].$br.$row_sr['series_statement'].$cd;   }   $seriesrecordset->free(); } else){   die($nr); } $piecerecordset = $db->query('select * pieces,series pieces.piece=series.series order piece asc'); if(!$piecerecordset)die($db->error); if($piecerecordset->num_rows > 0){   while($row_pr = $piecerecordset->fetch_assoc()){     $pr .= $od.$row_pr['piece'].$br.$row_pr['description'].$br.$row_pr['category'].$br.$row_pr['dimensions'].$br.$row_pr['price'].$cd;   }   $piecerecordset->free(); } else){   die($nr); } $db->close(); $head = '<html><head></head><body>'; //this other info echo "$head<div id='serieslist' align='right'>$ar$sr$pr$cd". "<script type='text/javascript'>/*you should put javascript here*/</script>". '</body></html>'; ?> 

really, should use external src javascript it's cached. sorry, if format hard read. use scrollbars.