goto Detail Page does not work right

Going to the first record is usually improper filtering of the SQL statement
or an improper request.


--
Nancy Gill
Adobe Community Expert
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: Dreamweaver CS3: The Missing Manual,
DMX 2004: The Complete Reference, DMX 2004: A Beginner's Guide
Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

"Deon" <deonNOSPAM@sincro.co.za> wrote in message
news:Xns998F3D98EA71EdeonNOSPAMsincrocoza@216.104.212.96...
> Hi there,
>
> DM CS3 and PHP with mySQL database. I have downloaded from
> http://www.dengjie.com wich appears to work fine.
>
> I got this right but after upgrading to CS3 from version 8, my goto
> detail page does not work.
>
> I have a results page which works fine.
> I have a link on the results page that says: mere details >>
> For this "Goto Details page" I have used the SB above.
> When I hover my mouse over the link, it displays the correct ID of the
> products who's details I want to display.
>
> BUT, when clicking on the more details >> link, it takes me to the very
> first record; everytime.
>
> Can someone please shed some light here for me, please. It's very
> frustrating getting this right a couple of times and now cannot find the
> fault.
>
> Regards,
> Deon

"Nancy - Adobe Comm. Expert" <nancy@webwish.com> wrote in
news:fa3d9p$mgl$1@forums.macromedia.com:

Nancy,
thank you, I think I fixed this.
Next problem ... Details page does not show any data.
I have a details page. This is the SQL for the details page:
SELECT *
FROM alternators
WHERE p_ID = colname

Variables as follows:
Name: colname
Type: Text
Default Value: -1
Runtime-Value: $_GET['p_ID']

The mySQL DB has a Primary Key for p_ID.
My go to details page has the correct link, but it displays no data. I
did bind words to the different fields in the RS.

I will really appreciate any suggestions.

Regards,
Deon