fokuhn7lil
New Member
Hi I have a table with names and numbers entered along with other data . The table called events contains many instances where the name and numbers are the same but the other entries are different. I want to perform a search using names so I can display the number. But in my search I only need to return one instance of a name . The table is like this \[code\] Name Number Responisble Position Paul 8455 Chorley t7 Dave 3821 PR south f5 Paul 8455 PR North p9 Paul 8455 Leyland t6 Dave 3821 Ribbleton r4\[/code\]and my script is this \[code\] $condition = "name LIKE 'Paul' "; $result = mysql_query("SELECT * FROM events WHERE $condition ") ; while($row = mysql_fetch_array($result)) { \[/code\]The script is not complete but I hope you can see that the results would return 3 results but what i want is a result with just one for each name I hope this makes sense ! thanks for any help