Stupidity should be painful.

I'm just learning Java and I am starting with Java Foundations: Introduction to Program Design and Data Structures (2nd Edition) by John Lewis, Peter DePasquale, and Joseph Chase (Amazon Link). What I've read so far has been easy to follow and understand. I am also following Java Code Conventions from Oracle. Afterwards I will be reading Effective Java.

tuck

Sorry I was a little vague in the last reply. Mysqli is support in Mysql version 4.1 and above.

Your php.ini file most likely has the mysqli extension commented out. Open your php.ini file and look for extension=php_mysqli.dll. It probably looks like ;extension=php_mysqli.dll. Just remove the ; to uncomment the line. You should also have a [MYSQLI] block.

Hope that helps.

Look at your php.ini file for mysqli. Sounds like your mysqli is commented out in your php.ini file.

I'll try to help, but still noobish with php code. So I'll apologize now for any noobish errors.

Looks like you changed your UPDATE statement to omit the IN clause. Wouldn't it be a better choice to use a prepared statement that you could use potentially for all 'Invoicing' type updates? Be it invoiced, not invoiced, collections, etc.... Then change a variable to reflect what you wanted to set that field too. Something like...

// update expense table to show items as invoiced
$invoice_type = 'invoiced'; // could be set to 'invoiced', NULL, 'collections', etc...
// connect to database 
$mysqli = new mysqli($dbhost,$user,$pass,$db);
// check connection
if (mysqli_connect_errno()) {printf("Connect failed: %s\n", mysqli_connect_error());exit();}

// Add invoiced data
if ($stmt = $mysqli->prepare("UPDATE Expenses SET invoiced = ? WHERE expenseID = ?"))
{
	// bind parameters
	$stmt->bind_param("si", $v1, $v2 );
	foreach ($_POST['expenseChecked'] as $addExpense) {
		// set variables
		$v1 = $invoice_type;
		$v2 = $addExpense;
		// execute query
		$stmt->execute();
	}
	// close statement
	$stmt->close();
}
// close connection
$mysqli->close();