php mysql how to get unique data from table
SELECT DISTINCT Example
The "Persons" table:
| P_Id | LastName | FirstName | Address | City |
|---|---|---|---|---|
| 1 | Hansen | Ola | Timoteivn 10 | Sandnes |
| 2 | Svendson | Tove | Borgvn 23 | Sandnes |
| 3 | Pettersen | Kari | Storgt 20 | Stavanger |
Now we want to select only the distinct values from the column named "City" from the table above.
We use the following SELECT statement:
SELECT DISTINCT City FROM Persons
The result-set will look like this:
| City |
|---|
| Sandnes |
| Stavanger |
x-xmax
Country UNITEDSTATES
City Ohio
Posted On 14/02/2012
5
Other Pages
- php remove class and inline css
- php word limit
- sql replace
- PHP prepend leading zero before single digit number
- All About Mysql with example advance query
- jquery add new input field
- WordPress Get Specific Page content
- WordPress Get resent post
- php whois domain checking simple script
- simple css horizontal menu code
- youtube php api to reading title & length
- div Tab menu using CSS
- Textarea resize on hove and mouse click
- Create Tab Menu Using Div
- simple javascript lightbox code
- Renaming & reading file name using .bat
- simple jquery slider code
- rewrite rules htaccess or how to create short url in php
- php Set Timezone by country
- javascript new tab on popup window code
- simple jquery for date picker
- php remove spacial characters
- single page website
- simple dropdown menu without javascript
- php deleting multiple data using checkbox
- SELECT OR DESELECT Multiple Checkbox
- php image re-size script
- php read file from directory
- php connect to mysql
- PHP tips and tricks
- Get and output the source of the homepage of a website
- php login scrpit
- php image watermark script
- PHP to Force a File Download
- php pagination script
- Use a javascript confirm box to ask the user if they want to delete
- simple php file upload code
- How to set a div to auto adjust it's height with available browser height
- php script send email with attachment
- Testing interview questions and answers
- Mysql interview questions and answers
- CSS3 interview questions and answers
- HTML5 interview questions and answers
- PHP interview questions and answers
- How do I clear all the entries from just one table in MySQL with PHP
- PHP Reading a file line by line
- filter email id from a string
- php mysql how to get unique data from table
- php how to short array by alphabetical order
- javascrpit iframe break code
- php defining maximum character of string
- php Remove extension from a filename
- Do you know you can watch Star wars Text movie from your computer.
- Interesting Computer tricks -- try it
- how to Clear default value of text input using Javascript
- improve your internet speed using gpedit.msc
- php xml site map script