[Resolved] checkbox

[kav]

When i add data in the add record form, if the public holiday checkbox is checked , it will have a different calculation compare to other days. The data entered will then be stored in db.

At the main page, all the data will be retrive from the db.

Displaying all the rows, including the EDIT and DELETE at the very end of each row.

The problem is when i click the EDIT link, it will popup a window using href="javascript:......" i would like to have the check box at the popup window being checked or not checked depending on whether that row of data is a public holiday.

Also, because the data is just simply retrive from db, i have no idea how to know which is the public holiday although all the data is being displayed according to its column.

How do i track it? add another column in db to track it?

[leatherback]

Hi,

Please reread your post, and try to imagine what it look slike to somebody who has no clue as to what you are working on...

Anyway:
If there is no way to know wether a day is a public holiday, you cannot check for it, and thus cannot respond to it: You need to add an colum to your database, true/false, which will tell you wether a day is a public holiday (Unless there is a way to test for it).

THen, you can easily test, while you are retrieving the data from the database:

something like:

while ($row = mysql_fetch_array($results))
  {
  if($row[holiday] == 1)
    {
    $checked = "checked" ;
    }
     else
    {
     $checked="";
    }
   $checkboxlist .="<input type=checkbox $checked name=\"somename\" >";
  }

[kav]

very sorry about it. i knew it was hard to imagine. At first i was thinking to paste my whole code here but it will be too long. so i try to describe it. guess in the future i would add the code along.

Thanks too. guess i will need another column to check whether the day is a public holiday.

cheers