$q = "SELECT invoice_id FROM invoices ORDER by invoice_id DESC LIMIT 1"; $res = pg_query($q); if (!$res) { $message = 'Invalid query: ' . pg_last_error() . "\n"; $message .= 'Whole query: ' . $query; die($message); } $i_id = pg_result_seek($res,0); do { $i = 0; if ($_POST['description']) { $tid = $i; $descr[$i] = $_POST['description']; $qty[$i] = $_POST['qty']; $uprice[$i] = $_POST['uprice']; $price[$i] = $qty[$i] * $uprice[$i]; $sql = "INSERT into invoices ( invoice_id, tid, descr, qty, uprice, price ) VALUES ( '".$i_id."','".$tid."','".$descr[$i]."','".$qty[$i]."','".$uprice[$i]."','".$price[$i]."' ); "; $result = pg_query($sql); if (!$result) { $message = 'Invalid query: ' . pg_last_error() . "\n"; $message .= 'Whole query: ' . $sql; die($message); } draw_form(); $i = $i + 1; } else { draw_form(); } } while ($_POST['aline'] == 'yes'); draw_header($i_id); $sql2 = "SELECT * FROM invoices where invoice_id = '".$i_id."';"; $res2 = pg_query($sql2); if (!$res2) { $message = 'Invalid query: ' . pg_last_error() . "\n"; $message .= 'Whole query: ' . $sql2; die($message); } while ($row = pg_fetch_assoc($res2)) { ?>