it still only returns one record then breaks this is 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