Dreamweaver - master/detail pages

Author

master/detail pages

plazman65

2006-02-12, 6:43 pm

ok Here is my problem
One, Im new at this which leads to my second problem. I chose Dreamweaver
because I am in the learning mode for code and dont have the time to learn the
ins and outs right away so I have to learn as I go.
I am trying to create a master/details pages- Ive done it both ways (wizard, &
block by block)
I need the first page to give a list of cities in certain counties then when
you click on the cities you get that city information.
The master page does exaclty what I want but when I click on the 'detail link"
for the cities I get this error-

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 1Text

I also get this error directly from the detail page in preview mode so here's
the code if that helps
<tr>
<td>idcode</td>
<td><?php echo $row_DetailRS1; ?> </td>
</tr>
<tr>
<td>county</td>
<td><?php echo $row_DetailRS1; ?> </td>
</tr>
<tr>
<td>CityName</td>
<td><?php echo $row_DetailRS1; ?> </td>
</tr>
<tr>
<td>ChiefName</td>
<td><?php echo $row_DetailRS1; ?> </td>
</tr>
<tr>
<td>address</td>
<td><?php echo $row_DetailRS1; ?> </td>
</tr>
<tr>
<td>cityphone</td>
<td><?php echo $row_DetailRS1; ?> </td>
</tr>
<tr>
<td>entrycontact</td>
<td><?php echo $row_DetailRS1; ?> </td>
</tr>
<tr>
<td>lateralcontact</td>
<td><?php echo $row_DetailRS1; ?> </td>
</tr>
<tr>
<td>citypopulation</td>
<td><?php echo $row_DetailRS1; ?> </td>
</tr>
<tr>
<td>medianhouserange</td>
<td><?php echo $row_DetailRS1; ?> </td>
</tr>
<tr>
<td>mediansalary</td>
<td><?php echo $row_DetailRS1; ?> </td>
</tr>
<tr>
<td>history</td>
<td><?php echo $row_DetailRS1; ?> </td>
</tr>
<tr>
<td>departmentsize</td>
<td><?php echo $row_DetailRS1; ?> </td>
</tr>
<tr>
<td>benefits</td>
<td><?php echo $row_DetailRS1; ?> </td>
</tr>
<tr>
<td>nowhiring</td>
<td><?php echo $row_DetailRS1; ?> </td>
</tr>
<tr>
<td>startdate</td>
<td><?php echo $row_DetailRS1; ?> </td>
</tr>
<tr>
<td>payrange</td>
<td><?php echo $row_DetailRS1; ?> </td>
</tr>
<tr>
<td>qualificationsentry</td>
<td><?php echo $row_DetailRS1; ?> </td>
</tr>
<tr>
<td>F18</td>
<td><?php echo $row_DetailRS1; ?> </td>
</tr>
<tr>
<td>qualificationslateral</td>
<td><?php echo $row_DetailRS1; ?> </td>
</tr>
<tr>
<td>testingprocedure</td>
<td><?php echo $row_DetailRS1; ?> </td>
</tr>

</table>

I did find some info on this for Dreamweavermx but Im using 8. I know I have
to be missing SOMETHING,please help. thank you

Jo Cala

2006-02-12, 6:43 pm

Hi,

I'm sorry I can't answer your question directly, but may I suggest posting it
on the Dreamweaver Application Development forum instead of the Dreamweaver
General Discussion forum, because that's where the PHP programmers would hang
out. It would help them if you included the code from your page that includes
the SQL query, because that is what is producing the error. In your page code
the SQL query looks something like this:

$variablename = "SELECT x FROM y WHERE.....";
$result = mysql_query($variablename);

PeteC

2006-02-12, 6:43 pm

Jo Cala wrote:
> that's where the
> PHP programmers would hang out. It would help them if you included
> the code from your page that includes the SQL query, because that is
> what is producing the error. In your page code the SQL query looks
> something like this:
>
> $variablename = "SELECT x FROM y WHERE.....";
> $result = mysql_query($variablename);

Damn! All that time, and I've been in the wrong place! <g>

I agree that the error is in the select statement, though I wouldn't want to
guess without seeing the source - otherwise the issue just gets confused
with possible answers.

Lets see some source, please.

Regards,

Pete.
--
Peter Connolly
http://www.acutecomputing.co.uk
Derby
UK
Skype ID: acutecomputing