How do I call a php script by clicking a checkbox?

[vigour]

I have a form with several checkboxes. I want to update a mysql table when the user is clicking on a checkbox. I know how to update mysql, but I don't know how a click on the checkbox will call a php script.

[bradgrafelman]

Search the forums and/or Google for "AJAX" - it's basically Javascript code that allows you to make requests back to the server (e.g. to a PHP script).

[sneakyimp]

The basic idea is that each checkbox will need an onChange attribute which calls a function and you'll need to define a javascript function which uses the XMLHttpRequest object:

<script type="text/javascript">
function doQuery(cbox) {
  // your AJAX function here
}
</script>
<input type="checkbox" name="myCheckbox" value="foobar" onChange="doQuery(this);">

AJAX stands for "Asynchronous Javascript and XML" and the basic idea is that Javascript lets your browser make additional requests the server without reloading your entire page by using the XMLHttpRequestObject. Try googling PHP AJAX or some similiar for more info.