Please excuse the bad code:
Code: Select all
mysql_query("INSERT INTO invoice_child (interest, parent, item, unitprice, qty, author) VALUES ('". $_POST['vat'.$i.''] ."', '". $_POST['invoiceid'] ."', '". $_POST['item'.$i.''] ."', '". $_POST['unitprice'.$i.''] ."', '". $_POST['qty'.$i.''] ."', '". $_POST['author'] ."')")or die(mysql_error()); }At the moment everything is working except the 'interest'. Nothing gets inserted into that field but there's no error. At first I thought maybe the $_POST wasn't sending but by changing it to a string I've realised that's not getting inserted either.
Thanks in advance