$new_row = serialize($entry); //$entry is an ADODB object, returned from a MySQL search $query =sprintf("INSERT INTO %s VALUES %s)", mysql_real_escape_string( $project_id_tables[$i] ), mysql_real_escape_string( $new_row ) ); echo "$query"; INSERT INTO mantis_bug_table VALUES a:54:{i:0;s:1:\"1\";s:2:\"id\";s:1:\"1\";i:1;s:1:\"1\";s:10:\"project_id\";s:1:\"1\";i:2;s:1:\"1\";s:11:\"reporter_id\";s:1:\"1\";i:3;s:1:\"0\";s:10:\"handler_id\";s:1:\"0\";i:4;s:1:\"0\";s:12:\"duplicate_id\";s:1:\"0\";i:5;s:2:\"30\";s:8:\"priority\";s:2:\"30\";i:6;s:2:\"50\";s:8:\"severity\";s:2:\"50\";i:7;s:2:\"70\";s:15:\"reproducibility\";s:2:\"70\";i:8;s:2:\"10\";s:6:\"status\";s:2:\"10\";i:9;s:2:\"10\";s:10:\"resolution\";s:2:\"10\";i:10;s:2:\"10\";s:10:\"projection\";s:2:\"10\";i:11;s:0:\"\";s:8:\"category\";s:0:\"\";i:12;s:19:\"2006-06-22 14:28:03\";s:14:\"date_submitted\";s:19:\"2006-06-22 14:28:03\";i:13;s:19:\"2006-06-22 14:39:21\";s:12:\"last_updated\";s:19:\"2006-06-22 14:39:21\";i:14;s:2:\"10\";s:3:\"eta\";s:2:\"10\";i:15;s:1:\"1\";s:11:\"bug_text_id\";s:1:\"1\";i:16;s:0:\"\";s:2:\"os\";s:0:\"\";i:17;s:0:\"\";s:8:\"os_build\";s:0:\"\";i:18;s:0:\"\";s:8:\"platform\";s:0:\"\";i:19;s:0:\"\";s:7:\"version\";s:0:\"\";i:20;s:0:\"\";s:16:\"fixed_in_version\";s:0:\"\";i:21;s:0:\"\";s:5:\"build\";s:0:\"\";i:22;s:1:\"0\";s:10:\"profile_id\";s:1:\"0\";i:23;s:2:\"10\";s:10:\"view_state\";s:2:\"10\";i:24;s:7:\"issue 1\";s:7:\"summary\";s:7:\"issue 1\";i:25;s:1:\"0\";s:17:\"sponsorship_total\";s:1:\"0\";i:26;s:1:\"0\";s:6:\"sticky\";s:1:\"0\";})