RE: [PHP] Pulling a data from array of checkboxes
| From: | John Holmes | Date: | Sat, 27 Jul 2002 22:41:06 +0000 |
| Subject: | RE: [PHP] Pulling a data from array of checkboxes | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-110007@lists.php.net to get a copy of this message | ||
> I am passing a value of checkboxes in a form to a new page like this
(see
> example here: http://www.gibsonusa.com/test/check/)
> In a new page how can I pull the data from a MySQL database according
to
> each value I passed from a previous page? In other words: Assume that
the
> value of a checkbox equal to the ID of the record in a database. The
value
> of checkbox 1 (for example) is 12345 and the value of checkbox2 is
67890.
> After passing those values to a new page how can I pull the rest of
the
> information from a database for those values?
<?
$IDs = implode(",",$_GET['chk']);
$Result = MySQL_query("SELECT * FROM your_table WHERE ID IN ($IDs)");
...
That's assuming your chk[] values in the database are an integer or
float type. If they are string, then use:
$IDs = "'" . implode("','",$_GET['chk']) .
"'";
---John Holmes...