How to show same username of each row all the values from table in php?

Question

I have table of 7 columns and one of it is username and want to show all rows which has same username xy.

Answer 1

select * from users where username="xy"

Answer 2

Sorry for it but got answer from Stackoverflow..
http://stackoverflow.com/questions/32318108/php-select-multiple-rows-from-mysql