PHP & mysql - Select all cols from 1 row - not working?

If your query returns only 1 row you can still use the while loop it will just stop after the first row. To be sure you only get one row append "and rownum < 2" to your where clause.