Hi,

I'm attempting to insert a record into my openjobs table which is comprised of openjobid, jobid, DateOpened, DateFilled, isactive.

The goal is to have the user select one or more checkboxes for the job types they want to post and select the restaurant from the dropdown list. The submit button should execute the mysqli_prepare statement. The page loads correctly but no record is inserted. Here's my code:
Code:
<form id="frmSelStore" method="post" action ="<?php 
$restaurantid = $_POST['ddlStore'];
$jobtype = $_POST['jobs'];
$stmt = mysqli_stmt_init($mysqli);
$sql = 'Insert into `OpenJobs`(`restaurantid`,`jobid`) Values($restaurantid,$jobtype)';
if(mysqli_stmt_prepare($stmt,$sql))
{
	mysqli_stmt_bind_param("ss",$restaurantid,$jobtype);
	mysqli_stmt_execute($stmt);
	printf("%d Row Inserted.\n", mysqli_stmt_affected_rows($stmt));
	mysqli_stmt_close($stmt);
}

?>">
<fieldset><?php 
	$query="SELECT restaurantid,location from restaurant";
	$result = mysqli_query($mysqli,$query);
	echo '<select name="ddlStore">';
	while($row=mysqli_fetch_array($result))
	{
		echo '<option value="' . htmlspecialchars($row['restaurantid']) . '">' .
		 htmlspecialchars($row['location']) . 
		'</option>';
	}
	echo '</select>';
?>
<h2>Step 2:  Please Select the Jobs to be Posted</h2>
<input type="checkbox" name='[jobs]'  value="2" id="cbJobs1">Host/Hostess
</input><br/>
<input type="checkbox" name='[jobs]' value="4" id="cbJob2">Bartender</input><br/>
<input type="checkbox" name='[jobs]' value="1" id="cbJob3">Server</input><br/>
<input type="checkbox" name='[jobs]' value="3" id="cbJobs4">Cook</input><br/>

<input type="submit" id="submit"/>
</fieldset>
</form>
How should I modify the above code to ensure that the prepared statement is processed correctly?

Thanks,
Sid