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]
