SiteScripts
SiteScripts - PHP Scripts, CGI Scripts, Free Javascript & ASP Scripts.
Search in 6,514 resources in 345 categories
Search on SiteScripts:
Distinct / Unique
Distinct / Unique
Having a problem getting DISTINCT or DISTINCTROW to work right? Probably because you are trying to SELECT more than one field, right? We had the same problem. If you are trying to only show unique records in combination with SELECT'ing more than one field, and/or trying to ORDER BY at the same time, then using DISTINCT in your SELECT statement becomes useless. There is a simple workaround however, you just need to set a variable with the field you are trying to call, and make sure that it does not match itself during the recordset retrieval loop.
- Price: Free
- Updated: 10/12/03
- Visits: 12