Multiple Records being returned in search
I used data assist to search a database and it returns multiple copies of the same record.
CPO_Name.php and tpye in "Da Puzzo" for an example.
the link you provide does not work.
can you also send a copy of the search and results page in a zip archive.
do you also have a working link?
the files you attached are not the original php files?
I need to see the PHP files that have the recordset for the results page in order to inspect the code.
The code on your page looks correct, it must be that there are multiple records in the Certified_Planning_Officials table where the last name column has the value Da Puzzo,
I'm sure if you where to access the MySQL Database using PHP MyAdmin or another MySQL GUI utility and run the following query:
SELECT * FROM Certified_Planning_Officials WHERE Last_Name LIKE '%Da Puzzo%'
you would get the same results.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.