Select From MySQL PHP
- by Liju
Sir,
 I have one Database Table named "table1" with 8 column, that is Date, Time, Name, t1, t2, t3, t4, t5. I want to update the same table like the following...
my existing table:-
Date        Time   Name    t1   t2   t3   t4  t5
10/11/2010  08:00  bob
10/11/2010  09:00  bob
10/11/2010  10:00  bob
10/11/2010  13:00  bob
10/11/2010  10:00  john
10/11/2010  12:00  john
10/11/2010  14:00  john
12/11/2010  08:00  bob
12/11/2010  09:00  bob
12/11/2010  10:00  bob
12/11/2010  13:00  bob
12/11/2010  10:00  john
12/11/2010  12:00  john
12/11/2010  14:00  john
12/11/2010  16:00  john 
I want to update this as follows :-
Date        Time   Name    t1      t2      t3      t4     t5
10/11/2010  08:00  bob     08:00   09:00   10:00   13:00
10/11/2010  10:00  john    10:00   12:00   14:00
12/11/2010  08:00  bob     08:00   09:00   10:00   13:00
12/11/2010  10:00  john    10:00   12:00   14:00   16:00
is it posible to update like this please help me..
Liju