Selecting checkboxes based on SQL query

From: Date: Thu, 23 Feb 2012 18:49:22 +0000
Subject: Selecting checkboxes based on SQL query
Groups: php.general 
Request: Send a blank email to php-general+get-316765@lists.php.net to get a copy of this message
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

« previous php.general (#316765) next »