Hi, I\'m using Dreamweaver to connect to a MySQL/PHP database running on a Linux server. I need to search on a few fields and display the results in table form which I have partialy accomplished. I have a search form that searches by STATE. In the results.php page I hava table populated with recordset fields. I would like one of the fields to link to a contacts.php page to an associated record. I got it to display the contacts.php page but with no data. Here is the code for the link:
<td><a href=\"contacts.php?MLA_NO= <?php echo $row_rscontacts[\'MLA_NO\']; ?>\"><?php echo $row_rscompanies[\'MLA_NO\']; ?></a></font></td>
MLA_NO is the unique field in both recordsets
The url in the address bar for the contacts page with no data is:
http://domain.com/sitefolder/contacts.php?MLA_NO=
if I manually type in a mla_no in the address bar, it will return correct data. Any help would be appreciated.
Thanks