I have Dreamweaver MX 2004 and I am just learning how to use php. I am trying to create a search of the database. When I do not use a filter for the recordset it pulls up everything on the database but when I try to filter it by the primary column it pulls up nothing - except when I hit the "test" button, available for creating recordsets, then it works fine.

Also, another separate but possibly related problem, when I try to use a "Go to detail page" for that same column on my table it will only pull up the same record. I cannot select the other records.

Any help would be appreciated.

Thanks