$result=execute_query("select invoice_id from invoice_per_client order by record_num","select"); if($invoice_id=='') $invoice_id=$result[count($result)-1][invoice_id]+1;