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