Update page with multiple check boxes
Hi
First let me say I'm brand new to PHP and MySQL so my problem might seem ridiculus to some.
I have problem with retrieving results, from previously correctly inserted data to database from a checkbox group on an insert page, back to the update page. This is what I've succeeded with this far:
- Created wizard generated pages with insert, update, search, delete pages etc.
- I have a group checkbox with name genre[] that send its values in array to a coma separated list to a single column in database:
<?php echo ((isset($_POST["genre"]))?implode(", ", $_POST["genre"]):""); ?>
This works just fine.
Now I just don't know how to retrive the previously inserted data to be able to update (change) the checkbox group alternatives from the update page?
I tried the following on the update page for each input box but it did not work:
exemple 1st input checkbox:
<input type="checkbox" name="genre[]" value="movietitle" id="genre_0" <?php echo((in_array("movietitle", explode(", ",
$row_RecordsetName['ColumnName'])))?"checked=checked":""); ?>/>
I got the following error messege:
Notice: Undefined variable: row_RecordsetName in C:\xampp\htdocs\my_domain\mytable_Update.php
Please give me some input in how to solve this!
Problem solved! Forgot to change server behaviour in update page!