Miscellany

    $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)) {  ?>  <tr>      <td><div align="center"><?=$row['tid'];?></div></td>      <td><div align="center"><?=$row['descr'];?></div></td>      <td><div align="center"><?=$row['qty'];?></div></td>      <td><div align="center"><?=$row['uprice'];?></div></td>      <td><div align="center"><?=$row['price'];?></div></td>  </tr>  <?  draw_tprice($price);  ?>  </table>  <?}?>