Re: 1 more thing with a query
If your inserting a new 'Ship Type' into the table it would be somthing like this.
$name=$_POST['name'];
$q=$db->query("SELECT * FROM ships_types WHERE shipid={$_POST['id']}");
$old=$db->fetch_row($q);
$db->query("INSERT INTO ships_types VALUES('', '{$_POST['name']}', '{$_POST['desc']}','{$_POST['shipCOST']}','{$_POST['shipACC']}','{$_POST['shipHAN']}','{$_POST['shipsPD']}','{$_POST['shipsHD']}','{$_POST['shipBUYABLE']}')");
If you editing a 'Ship Type' you would hav to do something like this.
$name=$_POST['name'];
$q=$db->query("SELECT * FROM ships_types WHERE shipid={$_POST['id']}");
$old=$db->fetch_row($q);
$db->query("UPDATE ships_types SET SHIPNAME='{$_POST['name']}', SHIPDECRIPTION='{$_POST['desc']}', SHIPCOST='{$_POST['shipCOST']}', and so on...
You would need to replace the SHIPNAME, SHIPDECRIPTION, SHIPCOST and all that with the names in the database.. for example for crimes it would be:
crimeNAME='{$_POST['crimeNAME']}', crimePERCFORM='{$_POST['crimePERCFORM']}',
ECT.