1604
zyspec i made some adjustment to your code and now its working ..thank you again for the help
// first get a list of department IDs
$result=$GLOBALS['xoopsDB']->query("SELECT DEPTID FROM ".$xoopsDB->prefix("mydepartments")."");
while($row=$GLOBALS['xoopsDB']->fetchArray($result))
{$deptId[]=$row['DEPTID'];}
$deptIdArray = implode(', ', $deptId);
// connect to the Access dB
$conn = odbc_connect('mydata','','');
if (!$conn) {
exit("Connection Failed: " . $conn);
}
// now get the Access dB departments not in XOOPS
$accessQuery = "SELECT DEPTID, DEPTNAME FROM DEPARTMENTS WHERE DEPTID NOT IN ($deptIdArray)";
$rs = odbc_exec($conn, $accessQuery);
if (!$rs) {
exit("Error in SQL");
}
// now put new departments into 'mydepartments' table
while(odbc_fetch_row($rs)){
$deptId=odbc_result($rs,"DEPTID");
$deptName=odbc_result($rs,"DEPTNAME");
$resultx= $GLOBALS['xoopsDB']->query("INSERT INTO ".$xoopsDB->prefix("mydepartments")."(`DEPTID`, `DEPTNAME`)
VALUES ('$deptId','$deptName')");
if (!$resultx) {
redirect_header($_SERVER['PHP_SELF'], 2, 'Error inserting new department');
exit();
}
++$i;
}
redirect_header($_SERVER['PHP_SELF'], 2, "{$i} new departments entered into the database");
exit();
