Re: Selecting checkboxes based on SQL query

I should have been more explicit in my description... The SQL command that returns the array is not the same one that creates the checkboxes.... they are two different sql queries and I would prefer to keep them that way. I actually have it working for a form submit with a custom function I got off the web. But the custom function relies on the array it's working on to look like this: [cb] => Array ( [0] => 1 [1] => 6 [2] => 2 [3] => 4 [4] => 3 ) So, to use my existing function, how do I get the following array to look like the above one: Array ( [0] => Array ( [cb] => 2 ) [1] => Array ( [cb] => 6 ) [2] => Array ( [cb] => 1 ) ) --Rick On Feb 23, 2012, at 2:08 PM, Fatih P. wrote:

On Thu, Feb 23, 2012 at 8:49 PM, Rick Dwyer <rpdwyer@earthlink.net> wrote:

Hello all. I perform a SQL query like the following: $sql = 'select * from my_table where id="10" It returns the the following array for 3 records: Array ( [0] => Array ( [cb] => 2 ) [1] => Array ( [cb] => 6 ) [2] => Array ( [cb] => 1 ) ) The values of CB in the above array are the values of html checkboxes on a page. input type="checkbox" name="cb[ ]" value="1"... input type="checkbox" name="cb[ ]" value="2"... input type="checkbox" name="cb[ ]" value="3"... input type="checkbox" name="cb[ ]" value="4"... etc If the above array's cb value matches the value of a checkbox on the page, I need the default state of the checkbox to be checked.... so I know I'm going to have some ternary logic in each html checkbox. But I don't know how to create a custom function from the above array to provide that logic. I've tried some tutorials, but with no success as the array I am receiving is not like those in the tutorials. Any help would be greatly appreciated. Thank you. --Rick -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

replace the name part as following input type="checkbox" name="cb[put_the_id_here]" value="1". when dumping into html from array foreach ($sql_result as $value) { if ($value == $selected) {

          input type checkbox name=cb[$value['id']] value=$value['id']

checked=checked } else {

       input type checkbox name=cb[$value['id']]   value=$value['id']

} } hope this helps