it still only returns one record then breaks that's the way MySQL doc showed to write the query if you want I can take out the while loop

 if I did a SELECT * then it would return all records in the table