This content has been marked as final. Show 2 replies
Going to the first record is usually improper filtering of the SQL statement
or an improper request.
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
> 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
"Nancy - Adobe Comm. Expert" <firstname.lastname@example.org> wrote in
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:
WHERE p_ID = colname
Variables as follows:
Default Value: -1
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.