Everything looks ok in @row. Only $row[6] is undef.
Here is my output:
$VAR1 = [ '26928', 'normal', '2002-04-29 15:17:06-04', '2002-04-29 15:
+19:04-04', '12', '12', 'asdfsad' ]; 2002-04-29 15:17 15:19 12:12 asd
+fsad $VAR1 = [ '26929', 'normal', '2002-04-29 17:18:23-04', '2002-04-
+29 17:18:42-04', '12', '12', '' ];
2002-04-29 17:18 17:18 12:12 $VAR1 = [ '26930', 'normal', '2002-05-0
+1 16:36:47-04', '2002-05-01 16:37:24-04', '14', '15', '' ];
2002-05-01 16:36 16:37 14:15 $VAR1 = [ '26931', 'normal', '2002-05-0
+3 15:57:20-04', '2002-05-03 16:44:32-04', '12', '12', '' ];
2002-05-03 15:57 16:44 12:12 $VAR1 = [ '26932', 'normal', '2002-05-0
+3 16:44:37-04', '2002-05-03 16:44:44-04', '12', '12', '' ];
2002-05-03 16:44 16:44 12:12 $VAR1 = [ '26933', 'normal', '2002-05-0
+3 16:46:42-04', '2002-05-03 17:29:08-04', '12', '12', '' ];
2002-05-03 16:46 17:29 12:12 $VAR1 = [ '26934', 'normal', '2002-05-0
+3 17:29:12-04', '2002-05-03 17:29:19-04', '12', '12', '' ];
2002-05-03 17:29 17:29 12:12 $VAR1 = [ '26935', 'normal', '2002-05-0
+3 17:57:24-04', '2002-05-03 18:05:10-04', '13', '14', '' ];
Perhaps my SELECT statement would help?
$main::SQL="SELECT oid,* FROM timeclock WHERE username = '$username' A
+ND start_stamp >= '$start_date' AND end_stamp <= '$end_date' ORDER BY
+ start_stamp";
|