Php help manual fetch?

Hi Trac,

With that code do you mean it doesn't passes data to the database?? I want a line that passes data from the form to the mysql database to the selected checkbox category_name.

Quote:

---

Originally Posted by traq

if, say, you want the value to be 5, just write it that way:

PHP Code:

---

$input = '<label><input type="checkbox" name="5">'.$r['category_name'].'</label>'; 


---

but in doing so, you've lost the association with the original database record.

---

if, on each <input>, you use the category_id as the name, then when the form is submitted you will know which category that checkbox belongs to. But if you use some other value (like name="othername"), then you wouldn't be able to tell.

Personally, I would build each input like this:

PHP Code:

---

'<label><input type="checkbox" name="category[]" value="'.$r['category_id'].'">'.$r['category_name'].'</label>'; 


---

using the same name (the [] make it an array) for each make it easier to access once the form is submitted.