Jump to content

Existing user? Sign In
Sign In

Remember me Not recommended on shared computers

Forgot your password?
Sign Up

Browse
- Forums
- Staff
- Leaderboard
- Guidelines
- Terms of Service
- More
Activity
- All Activity
- Search
- More
Join our Discord!
More
- More

PHP Coding Help

4 of the same number in the database, but only want to show one of them.

jon4433

By jon4433
March 23, 2012 in PHP Coding Help

Start new topic

Recommended Posts

jon4433

Member

jon4433

Posted March 23, 2012

- Share

Posted March 23, 2012

Like the title says. I have 4 of the same number in my database, but I only want my website to display one of the 4.

How can I do something like this?

Link to comment

https://forums.phpfreaks.com/topic/259564-4-of-the-same-number-in-the-database-but-only-want-to-show-one-of-them/

Share on other sites

smerny

Advanced Member

smerny

Posted March 23, 2012

- Share

Posted March 23, 2012

cant be specific since you weren't really... but your keyword will be DISTINCT

SELECT DISTINCT column FROM table

Link to comment

https://forums.phpfreaks.com/topic/259564-4-of-the-same-number-in-the-database-but-only-want-to-show-one-of-them/#findComment-1330511

Share on other sites

jon4433

Member

jon4433

Posted March 23, 2012

Author

- Share

Posted March 23, 2012

Thank you. Works fine now

Link to comment

https://forums.phpfreaks.com/topic/259564-4-of-the-same-number-in-the-database-but-only-want-to-show-one-of-them/#findComment-1330517

Share on other sites

Archived

This topic is now archived and is closed to further replies.

Go to topic listing

×

Browse
- Back
- Forums
- Staff
- Leaderboard
- Guidelines
- Terms of Service
Activity
- Back
- All Activity
- Search
Join our Discord!

×

Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.