select and show total

[techker]

Hey guys i have a portal that im doing for invoicing..

 

i have a page that shows all the unpaid invoices..

 

i put a check box next in the form...how can i select multiple selection and print the total amount of the selected with the invoice numbers.??

 

like

 

check box. invoice 2122  total 200$

check box. invoice 2123  total 200$

check box. invoice 2124  total 200$

check box. invoice 2125  total 200$

check box. invoice 2126  total 200$

 

 

so the print out would be

 

invoices:

2122-2123-2124-2125-2126 total before tax:1000$

 

 

 

[fenway]

Not sure what you're asking -- client-side or server-side -- but in any event, it's not directly mysql related (since you obviously queried the table successfully to show the info in the first place).

[techker]

well ya?it needs to take the id's select search the database and calculate the total amount..?no

[Jessica]

Do the math in PHP, or use SUM

[Barand]

First, the checkbox values should be the respective invoice numbers

 

<input type='checkbox' name='selectedInvoice[]' value='$invnumber'>

 

To process

$list = join(',', array_map('intval', $_POST['selectedInvoice']));

 

the query

SELECT
   GROUP_CONCAT(invoicenumber SEPARATOR '-') AS invoices,
   SUM(invoicetotal) AS total
FROM invoices
WHERE invoicenumber IN ($list)