Powered by InterCreatives | Site Map
Search:
NewSourceMedia Popular Tutorials: PHP Javascripts Web Hosting
SoftwareTutorials
CATEGORIES
Job Listings
 
Home / PHP / MySQL / Database

MySQL DISTINCT to Remove Duplicate Listing


This is for removing duplicated results in order to gain unique listings from your database table using the DISTINCT keyword in your MySQL select statement .

For example if you ran this:

Select Cars FROM Cars_Listing
======== Results =======
BMW
BMW
HONDA
BENZ
BENZ
BMW
FORD
FORD
=======================

Notice how there is more then one BMW.

Here is how to clean up that result by using the DISTINCT keyword in your MySQL select statement

Select DISTINCT Cars FROM Cars_Listing
======== Results =======
BMW
HONDA
BENZ
FORD
=======================

Next PHP Page:
1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  [30]  31  32 





Hosting by iPowerWeb.com - 50 Gb for $7.95