Hi all, Well, I played about abit more and discivered that I as overcomplicating things by specifying the tablename in field to be displayed. Once I set it to just display the fieldname it worked swimmingly. Now I can really get going. George ----- Original Message ----- From: George Pitcher <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 20, 2001 1:57 PM Subject: displaying related data from MySQL > Hi all, > > This sounds to me like a common question but I haven't found quite what I > want anywaher (maybe I've been looking in the wrong place). So apologies > from a complete newbie. > > I have built a database with 6 tables. The Master table contains keys to the > other 5 tables. I want to be able to display related data when I display > search results. > > This is the code I've been using (trial and error) but although I get a row > for each fount record, I get an error in every table cell. > > > $result=mysql_query ("select * from MASTER,ACFTREF > where MASTER.MFR_MDL_CODE=ACFTREF.CODE > AND MASTER.N_NUMBER LIKE '$Serial%' > AND MASTER.SERIAL_NUMBER LIKE '$Con%' > ORDER BY MASTER.N_NUMBER" > ); > ?> > <table width=100% tr valign=top> > <td colwidth=15%>Serial > <td colwidth=35% align=right>Maufacturer > <td colwidth=35% align=left>Model > <td colwidth=15%>Con > </td></tr> > <?php > if ($row = mysql_fetch_array($result)) { > do { > print ("<TR valign=top><TD bgcolor=yellow>N"); > print $row['MASTER.N_NUMBER']; > print ("<td>"); > print $row['ACFTREF.MFR_NAME']; > print ("<td>"); > print $row['ACFTREF.TYPE_ACFT']; > print ("<td>"); > print $row['MASTER.SERIAL_NUMBER']; > print ("<p></TD></TR>"); > } while ($row = mysql_fetch_array($result)) ; > } else {print "Sorry, no results found!";} > } > ?> > > Just for info, the Master db holds 340,000+ records. > > MTIA > > George in Edinburgh > _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]