Code:
//Insert the values into the correct database with the right fields
$result = $db->sql_query ("INSERT INTO " . $prefix . "_milpacs_members (uniqueid, name, uniform, rank_id, flag, location, status, p_mos, unit_id, reports, position, weapon_id, enlistment_dt, icq, bio)".
"VALUES ('NULL','$soldierName','$uniform', $rank_id, '$flag', '$location', '$status', '$p_mos', $unit_id, '$reports', '$position', $weapon_id, '$enlistment_dt', '$icq', '$bio')");
if (!$result) {
echo("<p>Error adding Soldier!" . mysql_error() . "</p>");
}
// else {
// $result = $db->sql_query($sql);
// echo "<META HTTP-EQUIV=\"refresh\" content=\"0;URL=modules.php?name=MILPACS&file=roster\">";
// }
}
|