Select and copy to MySQL table PHP
- by Liju
Can insert the table1 value to Table2 like the follows.. based on Name Date.
Table1
Id Date Name time
1 20/11/2010 Tom 08:00
2 20/11/2010 Tom 08:30
3 20/11/2010 Tom 09:00
4 20/11/2010 Tom 09:30
5 20/11/2010 Tom 10:00
6 20/11/2010 Tom 10:30
7 20/11/2010 Tom 11:30
8 20/11/2010 Tom 14:30
9 20/11/2010 John 08:10
10 20/11/2010 John 09:30
11 20/11/2010 John 11:00
12 20/11/2010 John 13:00
13 20/11/2010 John 14:30
14 20/11/2010 John 16:00
15 20/11/2010 John 17:30
16 20/11/2010 John 19:00
17 20/11/2010 Ram 08:05
18 20/11/2010 Ram 08:30
19 20/11/2010 Ram 09:00
20 20/11/2010 Ram 09:45
21 20/11/2010 Ram 12:00
22 20/11/2010 Ram 13:30
23 20/11/2010 Ram 15:00
Table2
Id Date Name Time In1 Time Out1 Time In1 Time Out1 Time In1 Time Out1 Time In4 Time Out4
1 20/11/2010 Tom 08:00 08:30 09:00 09:30 10:00 10:30 11:30 14:30
2 20/11/2011 John 08:10 09:30 11:00 13:00 14:30 16:00 17:30 19:00
3 20/11/2012 Ram 08:05 08:30 09:00 09:45 12:00 13:30 15:00 Null
Help me Please...
Liju