This content has been marked as final.
Show 2 replies
-
1. Re: goto Detail Page does not work right
Newsgroup_User Aug 16, 2007 10:56 PM (in response to Newsgroup_User)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
-
2. Re: goto Detail Page does not work right
Newsgroup_User Aug 16, 2007 11:49 PM (in response to Newsgroup_User)"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