Quote:
	
	
		| 
					Originally Posted by Publisher Bucks  How would I go about transfering the dropdown option to the SQL query? JavaScript or? | 
	
 You do it like any other form processing.  Your "<select>" is the html element for a dropdown.
When the form is submitted you capture the POST or GET corresponding to the "select" element.  Then you use that value in your query.
	Quote:
	
	
		| 
					Originally Posted by Publisher Bucks  Sorry, one more question about the total_amount... If a row has -1 would that be taken into account when the code collates the total or, will that just do individual columns?
 (does that make sense?)
 | 
	
 
That does not make sense to me,  not sure what you are asking.
.