determine checkbox status

[Bob_Loblaw]

I have a simple mySql table:

Proj_name - string
startdate - date
enddate - date
complete - boolean

I would like to use this (or similar) query to retrieve the data to display:

SELECT *
FROM test_projects
ORDER BY
CASE complete
WHEN 0
THEN startdate
ELSE enddate
END

(This should cause the non-complete projects to be listed first followed by the completed projects. The non-completed projects are sorted by start date and the completed are sorted by enddate.)

I will use a checkbox to display the complete state of the project.

When the user has made modifications to the page, how should I go about detecting checkboxes that were checked are no longer, as well as the newly checked boxes?

Thanks!

[Define-web_com]

a normal forms checkbox found with use of

if (isset($_POST['cb_name'])) {
// actions here for Checked , User has checked the checkbox.
} else {
// Check box is not checked actions code here, whatever you need to do because check was is not set
}

so in above example you are calling to check the checkbox that aname is 'cb_name' inside a form that was submited to the page. make sure to use the POST method for the <FORM>