how to select only one value sql

by 

Table - User
_______________
|id   |  Name | 
|1    | Joe   |
|2    | Mike  |


Table - Contact
__________________________
|id   | Phone | contactID|
|1    | 1234  | 1        |
|2    | 5678  | 1        |
|3    | 9999  | 2        |
|4    | 8888  | 2        |
|5    | 7777  | 2        |

First you have to run mysql query

SELECT u.Name, c.Phone 
FROM User u 
INNER JOIN Contact c ON c.contactID = u.id 
GROUP BY u.id;

Now you store your mysql query result and run a loop to print every name only one phone number

More Related Contents:

  1. How to create codeigniter dynamic menu from single table
  2. Comma separated numeric values – PHP CodeIgniter
  3. CodeIgniter – foreach loop
  4. PHP – Change value y,n in database [closed]
  5. How to insert multiple rows from array using CodeIgniter framework?
  6. strange character encoding of stored data , old script is showing them fine new one doesn’t
  7. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  8. Find total number of results in mySQL query with offset+limit
  9. How can I Use Prepared Statements in CodeIgniter
  10. Grouping WHERE clauses in Codeigniter
  11. What are the differences between backtick and single quote? Can I use IF statement in a query as above?
  12. How to create Codeigniter language files from database?
  13. Trying to get property of non-object – CodeIgniter
  14. Codeigniter Transactions
  15. Inserting NOW() into Database with CodeIgniter’s Active Record
  16. How to select rows where column value IS NOT NULL using CodeIgniter’s ActiveRecord?
  17. Escaping SQL queries in Codeigniter
  18. I can’t view the database content on a php page [closed]
  19. mysqli or PDO – what are the pros and cons? [closed]
  20. Maximum execution time in phpMyadmin
  21. PHP PDO – Num Rows
  22. CodeIgniter: 404 Page Not Found on Live Server
  23. How do I set the selected item in a drop down box
  24. Fatal error: Call to undefined function mysqli_result()
  25. access denied for user @ ‘localhost’ to database ” [closed]
  26. How can I employ “if exists” for creating or dropping an index in MySQL?
  27. codeigniter check for user session in every controller
  28. PHP MySQL pagination with random ordering
  29. SQL Query with binary data (PHP and MySQL)
  30. Save array in mysql database

Leave a Comment