JipThePeople

I am running php 5.4, IIS 7.5 on WinServer 2008 R2 box. I want to retrieve all subfolder names in a directory using PHP. I can successfully perform this task IF the target folder exists on the same drive as the php code, which is on c:\. However, I need to retrieve subfolder names from the e:\ drive on the same server. I have the permissions properly set for IUSR and IIS_IUSRS (read & exe, modify) for the target and parent folders but of course I don't have those permissions all the way to the root of e:\ drive. Using scandir(), I get "Access is denied. (code: 5)" but I have tried glob() and RecursiveDirectoryIterator to no avail. I have not been able to find a solution or an example so perhaps it is not possible. Any recommendations are greatly appreciated.

To complete the query I had to add the code: AND `t2`.`userid` = '599zxj' to the WHERE statement or it would retrieve archived projects NOT assigned to user '599zxj'. SELECT `t1`.`id`, `t1`.`name`, `t3`.`status`, `t5`.`access_start_date` FROM `project_info` as `t1` LEFT JOIN `user_assignments` as `t2` ON `t1`.`id` = `t2`.`propid` JOIN `status` AS `t3` ON `t1`.`status` = `t3`.`id` LEFT JOIN `archive_expiration` AS `t5` ON `t1`.`id` = `t5`.`propid` AND `t5`.`userid` = '599zxj' WHERE `t1`.`archived` = '1' AND `t2`.`userid` = '599zxj' GROUP BY `t1`.`id` ORDER BY `t1`.`name`

Thanks so much for the recommendation. The group by t1.id was the solution. Many thanks to you as well as the others who posted a response. SELECT `t1`.`id`, `t1`.`name`, `t3`.`status`, `t5`.`access_start_date` FROM `project_info` as `t1` LEFT JOIN `user_assignments` as `t2` ON `t1`.`id` = `t2`.`propid` JOIN `status` AS `t3` ON `t1`.`status` = `t3`.`id` LEFT JOIN `archive_expiration` AS `t5` ON `t1`.`id` = `t5`.`propid` AND `t5`.`userid` = '599zxj' WHERE `t1`.`archived` = '1' GROUP BY `t1`.`id` ORDER BY `t1`.`name`

Thanks for the response. So integrating your recommendation, the updated query is now: SELECT `t1`.`id`, `t1`.`name`, `t3`.`status`, `t5`.`access_start_date` FROM `project_info` as `t1` LEFT JOIN `user_assignments` as `t2` ON `t1`.`id` = `t2`.`propid` JOIN `status` AS `t3` ON `t1`.`status` = `t3`.`id` LEFT JOIN `archive_expiration` AS `t5` ON `t1`.`id` = `t5`.`propid` AND `t5`.`userid` = '599zxj' WHERE `t1`.`archived` = '1' GROUP BY `t5`.`propid` ORDER BY `t1`.`name` User '599zxj' is assigned to 3 archived projects, one of which has a corresponding record in the archive_expiation table, This revised query will retrieve 2 of the 3 records, but if I remove the corresponding record in the archive_expiation table, it will only retrieve 1 of the 3 records. Any other recommendations are greatly appreciated.

Thanks for the response. The archive_expiration table is required because certain users when added to a project, have their access limited to 180 days, Therefore, an access start time record is inserted into the archive_expiration table and is used when determining project access by comparing the access start date to the current date.

I have the following four tables. The query below is supposed to retrieve all projects and related data in associated tables where the project has been archived (i.e., archive field in project_info table set to '1') and user ID = '599zxj'. While user '599zxj' is assigned to 3 projects that have been archived, only one record is returned and it is the project that has a record in the archive_expiration table for user ID = '599zxj'. SELECT `t1`.`id`, `t1`.`name`, `t3`.`status`, `t5`.`access_start_date` FROM `project_info` as `t1` LEFT JOIN `user_assignments` as `t2` ON `t1`.`id` = `t2`.`propid` JOIN `status` AS `t3` ON `t1`.`status` = `t3`.`id` LEFT JOIN `archive_expiration` AS `t5` ON `t1`.`id` = `t5`.`propid` WHERE `t5`.`userid` = '599zxj' AND `t1`.`archived` = '1' GROUP BY `t5`.`propid` ORDER BY `t1`.`name` project_info table - archived field will be '1' when archived ----------------------------------- id | name | status | archived ----------------------------------- 1 | Proj A | 4 | 1 2 | Proj B | 5 | 1 3 | Proj C | 2 | 1 4 | Proj D | 3 | 0 5 | Proj E | 1 | 0 status table - Provides project status referenced in project_info table --------------------------- id | status | sortorder --------------------------- 1 | prelim | 1 2 | stage 1 | 2 3 | stage 2 | 3 4 | stage 3 | 4 5 | submitted | 5 user_assignments table - Associates a user id with a project id to determine project access ------------------------ id | userid | propid ------------------------ 1 | 599zxj | 1 2 | 599zxj | 2 3 | zrt321 | 2 4 | 599zxj | 3 5 | 765xzg | 3 archive_expiration table - Applies only to archived projects; access can expire for users with records in this table --------------------------------------------- id | userid | propid | access_start_date --------------------------------------------- 1 | zrt321 | 2 | 2014-01-15 09:22:56 2 | 599zxj | 3 | 2014-09-08 15:45:14 Any recommendations will be greatly appreciated.

Thank you! That is a good solution.

I have a table with lots of records. My table has the following field, with records containing either NULL or '1' that I need to modify. -- Current `archived` int(1) unsigned DEFAULT NULL But I need to modify it so that it is NOT NULL and defaults to '0'. I have tried the following but it throws an error. -- Error "#1265 - Data truncated for column 'archived' at row 1" ALTER TABLE `proposal_info` MODIFY `archived` INT( 1 ) UNSIGNED NOT NULL DEFAULT '0' -- SAME AS ABOVE EXCEPT NO QUOTES AROUND 0 - Error "#1265 - Data truncated for column 'archived' at row 1" ALTER TABLE `proposal_info` MODIFY `archived` INT( 1 ) UNSIGNED NOT NULL DEFAULT 0 I need to modify the table so that the records that are NULL for that field, will be updated to '0'. I need the records that are currently '1', to retain that value.

Thx for all the replies. I got it worked out. I appreciate the help!

Thanks for your response. I'm not sure a JOIN is required since all the data required is in the user_assignments table. I need a list of propids where user 'abc123' does not have a matching record for that project. All that info is contained in the user_assignments table. Here is the user_assignments table. CREATE TABLE IF NOT EXISTS `user_assignments` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `userid` varchar(100) NOT NULL DEFAULT '', `propid` int(10) unsigned NOT NULL DEFAULT '0', `security_level` int(10) unsigned NOT NULL DEFAULT '0', `role` int(10) unsigned DEFAULT '0', `custom_security` int(10) unsigned DEFAULT '0', PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; I ran the query you suggested and it returned an empty set which is not correct because there are projects not assigned to user 'abc123'. Does this additional information clarify my problem a little more? I really appreciate you taking the time to review my issue.

Server version: 5.5.23 - MySQL Community Server I have a table containing project assignments represented by a projectid column and a user_assignment column which contains the user's unique userid. A user is assigned to a project if they have a record in the user assignment table associated with the project id. I want retrieve all the projects that a specific user is NOT assigned to without getting duplicate records since there are many users assigned to projects. While these examples will retrieve only one record per project, it returns projects that user 'abc123' is and is NOT assigned to. I need to retrieve the project ids that the user is NOT assigned to. SELECT DISTINCT `propid` FROM `user_assignments` WHERE `userid` <> 'abc123' ORDER BY `propid` ASC SELECT DISTINCT `propid` FROM `user_assignments` WHERE (`userid` <> 'abc123') ORDER BY `propid` ASC I also tried a sub-query but it locks up mySQL in phpMyAdmin and never returns any records which is telling me there is something really wrong with this. SELECT DISTINCT `propid` FROM `user_assignments` WHERE `propid` NOT IN (SELECT `propid` FROM `user_assignments` WHERE `userid` = 'abc123') ORDER BY `propid` I have limited experience with writing SQL so I would really appreciate any recommendations. I am sure there is a very simple solution but I am not seeing it.

Thx much!

I can successfully concatenate strings and vars to assemble a php var using an echo statement like this: echo "<input type='radio' id='radio_btn_" . $Row['question_number'] . "_0' name='question[question_" . $Row['question_number'] . "]' value='0' checked='checked' />"; However, when attempting to reference the same var in an IF statement, I can't seem to get the syntax right. I know this syntax is wrong, but I list it for reference to describe the issue I am trying to solve. if ($_POST['radio_btn_' . $Row['question_number'] . '_0'] == '0'){ I also tried curly braces but can't arrive at a solution. Any advise would be appreciated.

Can you please provide one more example since the last one didn't return any records? If you have any other ideas, I would greatly appreciate it.

Yes, there are matching rows representing the most recent score for each unique file id. So if I remove that portion of the code, we are left with this. SELECT `t1`.`id`, `t1`.`filename`, `t1`.`filegrade_id`, `t1`.`percent_id`, `t2`.`process` FROM `proposal_files` AS `t1` JOIN `prop_file_processes` AS `t2` ON ( `t1`.`process` = `t2`.`id`) WHERE `t1`.`propid` = '209' GROUP BY t1.id ORDER BY t1.filename ASC Can you please give an example of flipping the derived table in the query? Also I determined that it was necessary to have the GROUP BY in the query or else it would only return a single record.

Thx for the help and the time spent. Unfortunately, it yielded an empty result set (i.e., zero rows). The code below (an excerpt taken from your latest recommended code) yields three records correctly (per most recent submit date) when executed separately: SELECT a.filegrade_id, a.file_id, a.score, a.submit_date FROM `file_grade_answers` AS a LEFT JOIN `file_grade_answers` AS b ON ( ( a.file_id ) = ( b.file_id ) AND a.submit_date < b.submit_date ) WHERE b.submit_date IS NULL But the entire code when executed together does not yields any records. Any suggestions?

I will give it a shot. Thx.

I didn't write the original query so I am not sure what the other guy was thinking regarding the GROUP BY which is what I stated earlier. I am seeking help here because I am not an SQL expert and I do appreciate your time and help. Regarding your recommendation (need to join in the second query as a derived table, using filegrade_id as the join condition -- but drop the GROUP BY), can you please provide an example? I have exhausted my ideas and the syntax is one of my main issues when trying to make these two queries work together. I have also not worked with derived tables before. Thx again for your time.

The file_grade_answers table relates to the proposal_files table via the field "filegrade_id".

I did not write the original query and since the file id fields are always unique, I don't know why you would include a GROUP BY either. This query is used to retrieve data about all files for a given prop_id. It will populate an html table with info on each file.

I have the following query (no issues) and now I need to add code to SELECT additional data from another table. The big picture is that a file is assigned a score which is written to the file_grade_answers table. The most recent score needs to be retrieved, which I can do but I can't integrate this query into the original query. For reference: MySQL client version: mysqlnd 5.0.7-dev - 091210 - $Revision: 304625 $ Here is the original query which retrieves misc data about a file from multiple tables via JOINS: SELECT `t1`.`id`, `t1`.`filename`, `t1`.`filegrade_id`, `t1`.`percent_id`, `t2`.`process` FROM (`proposal_files` AS `t1` JOIN `prop_file_processes` AS `t2` ON `t1`.`process` = `t2`.`id`) WHERE `t1`.`propid` = '209' GROUP BY t1.id ORDER BY t1.filename ASC I have a new table (file_grade_answers) that contains records and I need to only select the most recent record. I have a query that will successfully retrieve the most recent record for each "file_id", but my issue is I don't know how to integrate it into my original query. However, this query will need tweaking to make it work in context of the original query. That is the snag for me. I don't know how to make it only retrieve one record in context of the complex JOIN in the original query. When I tried to integrate it, I got the #1241 - Operand should contain 1 column(s) error, and that is because it IS returning multiple records (the most recent record per each file id). This query will successfully retrieve one record (most recent record per "submit_date" col) per "file_id", and it will return three records since there are three unique file IDs in the records. NOTE: There are duplicate file IDs because a history must be maintained every time a file is assigned a score. SELECT a.file_id, a.score, a.submit_date FROM `file_grade_answers` AS a LEFT JOIN `file_grade_answers` AS b ON ( ( a.file_id ) = ( b.file_id ) AND a.submit_date < b.submit_date ) WHERE b.submit_date IS NULL Creating the `file_grade_answers` table: CREATE TABLE IF NOT EXISTS `file_grade_answers` ( `filegrade_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `file_id` int(10) unsigned NOT NULL, `reviewer_id` varchar(100) NOT NULL, `owner_at_review` varchar(100) NOT NULL, `process_at_review` int(10) unsigned NOT NULL, `question_ids` varchar(100) NOT NULL, `answers` varchar(100) NOT NULL, `recommendations` blob NOT NULL, `submit_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `possible_points` int(10) unsigned NOT NULL, `actual_points` int(10) unsigned NOT NULL, `score` int(10) unsigned NOT NULL, PRIMARY KEY (`filegrade_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ; -- -- Dumping data for table `file_grade_answers` -- INSERT INTO `file_grade_answers` (`filegrade_id`, `file_id`, `reviewer_id`, `owner_at_review`, `process_at_review`, `question_ids`, `answers`, `recommendations`, `submit_date`, `possible_points`, `actual_points`, `score`) VALUES (1, 451, 'smith', 'smith', 2, '1,2,3,4', '2,1,1,2', 0x54657374696e6720313233, '2011-08-24 09:27:33', 20, 6, 30), (2, 453, 'smith', 'smith', 11, '1,2,3', '4,4,4', '', '2011-08-24 10:58:05', 15, 12, 80), (3, 452, 'smith', 'smith', 5, '1,2,3,4,5,6,7', '3,2,1,1,2,3,1', '', '2011-08-24 10:59:39', 35, 13, 37), (4, 452, 'smith', 'smith', 5, '1,2,3,4,5,6,7', '4,5,4,5,5,5,3', '', '2011-08-25 09:39:39', 35, 31, 89), (5, 451, 'smith', 'smith', 2, '1,2', '4,5', '', '2011-08-25 10:29:13', 10, 9, 90), (6, 452, 'smith', 'smith', 5, '1,2', '3,3', '', '2011-08-26 08:09:20', 10, 6, 60), (7, 452, 'smith', 'smith', 5, '1', '3', '', '2011-08-26 08:09:45', 5, 3, 60), (8, 452, 'smith', 'smith', 10, '1,2,3,4', '5,5,5,5', 0x546869732066696c652069732067726561746e6573732e, '2011-08-29 12:46:20', 20, 20, 100), (9, 453, 'smith', 'smith', 11, '1,2,3,4,6', '4,5,4,5,5', 0x536f6d657468696e672068617320676f6e652061206269742061736b6577206f6e207468652074726564646c652e, '2011-08-29 20:42:56', 25, 23, 92), (10, 451, 'smith', 'smith', 2, '1,2,3,4,5,6,7', '1,2,1,3,5,6,2', 0x4d79207265636f6d6d656e646174696f6e2074657874, '2011-09-06 14:16:23', 35, 20, 57), (11, 451, 'smith', 'smith', 2, '1,2', '2,1', '', '2011-09-08 13:28:44', 10, 3, 30), (12, 452, 'smith', 'smith', 10, '1,2,3,4', '4,1,2,1', '', '2011-09-08 13:29:09', 20, 8, 40), (13, 453, 'smith', 'smith', 11, '1', '1', '', '2011-09-08 13:29:23', 5, 1, 20); Creating Process table: CREATE TABLE IF NOT EXISTS `prop_file_processes` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `process` varchar(100) NOT NULL DEFAULT '', `sortorder` int(2) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ; -- -- Dumping data for table `prop_file_processes` -- INSERT INTO `prop_file_processes` (`id`, `process`, `sortorder`) VALUES (8, 'In Production', 9), (2, 'Writing', 1), (3, 'Ready for Edit', 3), (4, 'Editing File', 4), (5, 'Ready for Review', 5), (6, 'Final', 11), (7, 'Other Collaboration', 2), (10, 'In Review 1', 6), (11, 'In Review 2, 7), (12, 'In Review 3', , (13, 'Signature Required', 10); Proposal File Table: CREATE TABLE IF NOT EXISTS `proposal_files` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `propid` int(10) unsigned NOT NULL DEFAULT '0', `filename` varchar(255) NOT NULL DEFAULT '', `inout` int(10) unsigned NOT NULL DEFAULT '0', `folder` int(10) unsigned NOT NULL DEFAULT '0', `process` int(10) unsigned NOT NULL DEFAULT '0', `userid` varchar(100) NOT NULL DEFAULT '', `owner` varchar(100) NOT NULL DEFAULT '', `filesize` varchar(50) DEFAULT NULL, `pagecount` int(10) unsigned DEFAULT NULL, `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `last_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `filegrade_id` int(10) DEFAULT NULL, `percent_id` int(10) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 ; -- -- Dumping data for table `proposal_files` -- INSERT INTO `proposal_files` (`id`, `propid`, `filename`, `inout`, `folder`, `process`, `userid`, `owner`, `filesize`, `pagecount`, `created`, `last_updated`, `filegrade_id`, `percent_id`) VALUES (464, 209, 'other_architecture.doc', 1, 422, 2, 'smith', 'smith', '237568', 5, '2011-05-04 14:27:43', '2011-05-04 14:27:43', NULL, NULL), (463, 203, 'over.doc', 0, 366, 3, '', 'smith', '1468416', 65, '2011-03-29 09:08:37', '2011-03-29 09:08:37', NULL, NULL), (462, 203, 'tictoc.doc', 0, 366, 2, '', 'smith', '54784', 7, '2011-03-29 09:08:33', '2011-03-29 09:08:33', NULL, NULL), (460, 203, 'generic.docx', 0, 424, 2, '', 'smith', '88591', 1, '2011-03-29 09:08:29', '2011-03-29 09:08:29', NULL, NULL), (456, 209, 'bb.docx', 0, 414, 11, '', 'smith', '27646', 7, '2011-03-28 16:47:02', '2011-03-28 16:47:02', NULL, NULL), (455, 209, 'rb-processes.dotx', 0, 422, 5, '', 'smith', '28575', NULL, '2011-03-28 16:47:02', '2011-03-28 16:47:02', NULL, NULL), (454, 209, 'dds-bbs.docx', 0, 414, 8, '', 'smith', '34191', 3, '2011-03-28 16:46:59', '2011-03-28 16:46:59', NULL, NULL), (453, 209, 'dds-7.docx', 0, 414, 11, '', 'smith', '15860', 3, '2011-03-28 16:46:57', '2011-03-28 16:46:57', NULL, NULL), (457, 203, 'troubleshooting-ds.docx', 0, 366, 7, '', 'smith', '25267', 1, '2011-03-29 09:08:21', '2011-03-29 09:08:21', NULL, NULL), (452, 209, 'troubleshooting-dl.docx', 0, 414, 10, '', 'smith', '25267', 1, '2011-03-28 16:46:55', '2011-03-28 16:46:55', NULL, NULL), (451, 209, 'blue-dds.doc', 1, 422, 2, 'smith', 'smith', '1468416', 65, '2011-03-28 16:46:04', '2011-05-04 09:16:39', NULL, NULL), (461, 203, 'bb.docx', 0, 424, 7, '', 'smith', '27646', 7, '2011-03-29 09:08:31', '2011-03-29 09:08:31', NULL, NULL), (459, 203, 'Process.docx', 0, 366, 2, '', 'smith', '34191', 3, '2011-03-29 09:08:27', '2011-03-29 09:08:27', NULL, NULL), (458, 203, 'md-dds-1.docx', 0, 366, 2, '', 'smith', '15860', 3, '2011-03-29 09:08:25', '2011-03-29 09:08:25', NULL, NULL), (465, 211, 'over-hills.doc', 0, 433, 2, '', 'smith', '1468416', 65, '2011-08-29 12:52:10', '2011-08-29 12:52:10', NULL, NULL), (466, 209, 'croctoc.doc', 0, 414, 2, '', 'smith', '54784', 7, '2011-08-29 12:54:35', '2011-08-29 12:54:35', NULL, NULL), (467, 209, 'md-2-Process.docx', 0, 414, 2, '', 'smith', '1288683', 64, '2011-08-29 12:54:40', '2011-08-29 12:54:40', NULL, NULL), (468, 209, 'more-toc.doc', 0, 414, 2, '', 'smith', '54784', 7, '2011-08-29 12:54:44', '2011-08-29 12:54:44', NULL, NULL), (469, 209, 'DDS-TEMPLATE.dotx', 0, 414, 2, '', 'smith', '30239', NULL, '2011-08-29 12:54:47', '2011-08-29 12:54:47', NULL, NULL); Create the proposal info table (I know the names are crazy, but this is dummy data on a test server): CREATE TABLE IF NOT EXISTS `proposal_info` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL DEFAULT '', `code_name` varchar(100) NOT NULL DEFAULT '', `description` blob NOT NULL, `notes` blob, `start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `submit_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `close_date` datetime DEFAULT NULL, `status` int(10) NOT NULL DEFAULT '0', `region` int(10) NOT NULL DEFAULT '0', `pm` varchar(100) NOT NULL DEFAULT '', `pa` varchar(100) DEFAULT '', `le` varchar(100) DEFAULT '', `designer` varchar(100) DEFAULT '', `cse` varchar(100) NOT NULL DEFAULT '', `sa` varchar(100) DEFAULT '', `bd` varchar(100) DEFAULT NULL, `wk_planner` varchar(100) DEFAULT NULL, `pursuit_manager` varchar(50) DEFAULT NULL, `bid_manager` varchar(50) DEFAULT NULL, `pursuit_id` varchar(100) DEFAULT NULL, `total_cost` varchar(100) DEFAULT '', `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `supp_files_pg` varchar(100) NOT NULL DEFAULT 'pgs_files_support.php', `archived` int(1) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=212 ; -- -- Dumping data for table `proposal_info` -- INSERT INTO `proposal_info` (`id`, `name`, `code_name`, `description`, `notes`, `start_date`, `submit_date`, `close_date`, `status`, `region`, `pm`, `pa`, `le`, `designer`, `cse`, `sa`, `bd`, `wk_planner`, `pursuit_manager`, `bid_manager`, `pursuit_id`, `total_cost`, `created`, `supp_files_pg`, `archived`) VALUES (211, 'Kiev', 'Kiev', 0x426f67757320746573742070726f6a656374, '', '2011-07-01 00:00:00', '2012-07-01 00:00:00', NULL, 3, 4, '', '', '', 'smith', 'smith', '', '', 'Vasilly Zaitzsev', '', '', '', '$1B', '2011-07-25 10:21:37', 'pgs_files_support_v2.php', NULL), (210, 'Spider Lockhart', 'Spider Lockhart', 0x54657374, '', '2011-05-19 00:00:00', '2014-05-19 00:00:00', '2011-05-18 00:00:00', 4, 4, '', '', '', '', 'smith', '', '', '', '', '', '', '', '2011-05-19 10:22:20', 'pgs_files_support_v2.php', NULL), (209, 'Kursk', 'Operation Citadel', 0x54455354204949, '', '2011-03-01 00:00:00', '2012-06-01 00:00:00', NULL, 1, 3, '', '', '', '', 'mathjosh', '', '', '', '', '', '', '', '2011-03-11 10:20:32', 'pgs_files_support_v2.php', NULL), (208, 'P.N. Guinn', 'Mangy Bird', 0x54455354, '', '2011-03-10 00:00:00', '2012-06-10 00:00:00', NULL, 4, 6, '', '', '', '', 'mathjosh', '', '', '', '', '', '', '', '2011-03-11 10:15:42', 'pgs_files_support_v2.php', NULL), (207, 'Splunge', 'Monkey Butt', 0x54657374, '', '2011-03-01 00:00:00', '2011-05-01 00:00:00', NULL, 3, 3, '', '', '', '', 'mathjosh', '', '', '', '', '', '', '$2', '2011-03-08 09:42:58', 'pgs_files_support_v2.php', NULL), (206, 'Glamis', 'Baumgardener', 0x54455354, '', '2011-03-31 00:00:00', '2011-07-31 00:00:00', NULL, 4, 4, '', '', '', '', 'smith', '', '', '', '', '', '', '', '2011-03-07 12:31:52', 'pgs_files_support_v2.php', NULL), (200, 'Manstein', 'Operation Winter Storm', 0x4e65772070726f6a656374, '', '2011-02-16 00:00:00', '2011-05-16 00:00:00', NULL, 3, 6, '', '', '', '', 'smith', '', '', '', '', '', '', '', '2011-02-16 08:09:32', 'pgs_files_support_v2.php', NULL), (203, 'AG South', 'Karkov', 0x54455354, '', '2011-02-01 00:00:00', '2011-04-01 00:00:00', '2011-05-08 00:00:00', 4, 4, '', '', '', '', 'smith', '', '', '', '', '', '', '', '2011-02-22 10:17:18', 'pgs_files_support_v2.php', NULL), (201, 'Eastern Front 1941', 'Operation Barabarossa', 0x426f6775732070726f6a656374, '', '2011-02-17 00:00:00', '2012-06-17 00:00:00', NULL, 12, 4, '', '', '', '', 'smith', '', '', '', '', '', '', '', '2011-02-16 08:40:58', 'pgs_files_support_v2.php', NULL), (202, 'T34', 'Kursk', 0x426f677573, '', '2011-02-01 00:00:00', '2011-05-01 00:00:00', NULL, 5, 1, '', '', '', '', 'smith', '', '', '', '', '', '', '', '2011-02-16 10:32:21', 'pgs_files_support_v2.php', NULL), (204, 'Ritchie Blackmore', 'LA Connection', 0x54455354, '', '2011-02-23 00:00:00', '2012-03-23 00:00:00', NULL, 2, 4, '', '', '', '', 'smith', '', '', '', '', '', '', '', '2011-02-25 12:47:42', 'pgs_files_support_v2.php', NULL), (205, 'Bub Frawley', 'Snitterton Lewis', 0x427562, '', '2011-03-02 00:00:00', '2012-06-02 00:00:00', NULL, 4, 1, '', '', '', '', 'smith', '', '', '', '', '', '', '', '2011-03-02 13:22:59', 'pgs_files_support_v2.php', NULL); Any help will be greatly appreciated.

Thank you so much for your time. That is the solution!

INSERT INTO `file_grade_answers` (`filegrade_id`, `file_id`, `reviewer_id`, `owner_at_review`, `process_at_review`, `question_ids`, `answers`, `recommendations`, `submit_date`, `possible_points`, `actual_points`, `score`) VALUES (1, 451, 'gillian', 'coverdale', 2, '1,2,3,4', '2,1,1,2', 0x54657374696e6720313233, '2011-08-24 09:27:33', 20, 6, 30), (2, 453, 'hughes', 'dimarzio', 11, '1,2,3', '4,4,4', '', '2011-08-24 10:58:05', 15, 12, 80), (3, 452, 'blackmore', 'dimarzio', 5, '1,2,3,4,5,6,7', '3,2,1,1,2,3,1', '', '2011-08-24 10:59:39', 35, 13, 37), (4, 452, 'dimarzio', 'blackmore', 5, '1,2,3,4,5,6,7', '4,5,4,5,5,5,3', '', '2011-08-25 09:39:39', 35, 31, 89), (5, 451, 'dimarzio', 'dimarzio', 2, '1,2', '4,5', '', '2011-08-25 10:29:13', 10, 9, 90), (6, 452, 'dimarzio', 'blackmore', 5, '1,2', '3,3', '', '2011-08-26 08:09:20', 10, 6, 60), (7, 452, 'bolin', 'paice', 5, '1', '3', '', '2011-08-26 08:09:45', 5, 3, 60), (8, 452, 'jlord', 'glover', 10, '1,2,3,4', '5,5,5,5', 0x546869732066696c652069732067726561746e6573732e, '2011-08-29 12:46:20', 20, 20, 100), (9, 453, 'jlord', 'paice', 11, '1,2,3,4,6', '4,5,4,5,5', 0x536f6d657468696e672068617320676f6e652061206269742061736b6577206f6e207468652074726564646c652e, '2011-08-29 20:42:56', 25, 23, 92);

Here is an insert as requested. Thx for your efforts. INSERT INTO `file_grade_answers` (`file_id`, `reviewer_id`, `owner_at_review`, `process_at_review`, `question_ids`, `answers`, `recommendations`, `submit_date`, `possible_points`, `actual_points`, `score`) VALUES ('451', 'blackblue21', 'jrwoodsman24', '2', '1,2,3,4,5,6,7', '1,2,1,3,5,6,2', 'My recommendation text', NOW(), '35', '20', '57')