Forums
This topic is locked
Detail Page can't filter ID
Posted 28 Nov 2003 07:58:25
1
has voted
28 Nov 2003 07:58:25 marcos martinez posted:
Hi everyone. Im doing a PHP MySQL website with Dreamweaver MX, and I'm not much of a coder myself(coming from the graphic design arena i'm afraid).The problem that I have is that when I create the recordset for the detail page, the option to filter by ID doesn't show up, so that means that all the elements in the master page link to the same field in the detail page (which of course is the first one of the table).
Any idea why I can't filter the recordset?
Thanks for any help you can give me guys,
Marcos
Replies
Replied 02 Dec 2003 13:28:48
02 Dec 2003 13:28:48 Nozomi Kugita replied:
Check your SQL statement:
Is it filtered by URL parameter or form variable or else? Is the variable name to filter correct?
If it's still not working and if ID is not selected for a recordset, include "ID" column to select for the recordset.
I'm just guessing the problem...
- Noz
Is it filtered by URL parameter or form variable or else? Is the variable name to filter correct?
If it's still not working and if ID is not selected for a recordset, include "ID" column to select for the recordset.
I'm just guessing the problem...
- Noz