php - Get count and show order number to display -

i have table pulls this:

 $nurse_query = "select * patientinfo schdt = '$currentdate'  , surgeon not 'not on file' or schdt = '$currentdate' , task  'clinic%'  order colby_arrival_time_1,schtm asc"; 

it displays surgeries have day ordered arrival time , surgery time. works well. want me order number of patient based on surgeon , surgery time. example:

if first 6 surgeries are:

patient       surgery time        surgeon smith          0800                lees johnson        0815                kaiser minnie         0800                pappy niehaus        0900                pappy kurle          0930                lees kusiek         1000                kaiser johnson        1000                pappy 

i display this

surgery time       patient        surgeon      order 0800               smith           lees          1 0800               minnie          pappy         1 0815               johnson         kaiser        1 0900               niehaus         pappy         2 0930               kurle           lees          2 1000               kusiek          kaiser        2 1000               johnson         pappy         3 

when new patient added, should automatically reorder order number.

maybe table data want show

patient surgery     time surgeon smith lees          0800  johnson kaiser      0815  minnie pappy        0800  niehaus pappy       0900  kurle lees          0930  kusiek kaiser       1000  johnson pappy       1000    surgery time    patient         surgeon order  0800            smith lees      1  0800            minnie  pappy   1  0815            johnson kaiser  1  0900            niehaus pappy   2  0930            kurle lees      2 1000            kusiek kaiser   2  1000            johnson pappy   3 

to use this, try here