Jump to content

Archived

This topic is now archived and is closed to further replies.

Plazman65

Master/detail page

Recommended Posts

Hi all, First off thank you for taking the time to read this. I did search for this problem on this site and several other areas and couldnt find anything. So hopefully I am not repeating another topic that in my frustration I cant find.
So here's my problem;
1st problem, I'm new at this which leads to the second problem.

I want to create a master/detail pages one that lists all the cities in a county then when for the details it would go a a city page. That part I got but when I set up the master detail page.
the master page looks like I want but in preview I click on a 'city" and I get
[b]"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Name = '' LIMIT 0, 10' at line 1"[/b]
the code for the master page is:
<table border="1" align="center">
<tr>
<td>county</td>
<td>CityName</td>
</tr>
<?php do { ?>
<tr>
<td><?php echo $row_Recordset1['county']; ?>&nbsp; </td>
<td><a href="adamscities.php?recordID=<?php echo $row_Recordset1['CityName']; ?>"> <?php echo $row_Recordset1['CityName']; ?>&nbsp; </a> </td>
</tr>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</table>
<br>
<?php echo $totalRows_Recordset1 ?> Records Total
the code for the detail page is
<tr>
<td>county</td>
<td><?php echo $row_DetailRS1['county']; ?> </td>
</tr>
<tr>
<td>CityName</td>
<td><?php echo $row_DetailRS1['CityName']; ?> </td>
</tr>
<tr>

I have no clue what to do, I have used the wizard/set it up block by block.
any help, suggestions, ideas would be greatly appreciated.
Thanks, Michelle

Share this post


Link to post
Share on other sites
you need to show us your SQL lines of code. i have the feeling that you are posting the code right after the problem. It sounds to me kinda you are missing a " somewhere or they are just missplaced.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.