Re: Pulling a data from array of checkboxes
| From: | Richard Lynch | Date: | Mon, 29 Jul 2002 09:20:55 +0000 |
| Subject: | Re: Pulling a data from array of checkboxes | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-110132@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?
<?php
if (isset($chk) && is_array($chk)){
$ids = implode(', ', $chk);
$query = "select whatever from sometable where id in ($ids)";
mysql_query($query, $connection) or error_log(mysql_error());
...
}
?>
By the way:
1. If you're Gibson the guitar maker, send me one :-)
2. There's no friggin' way I'm downloading a new version of IE just to view
your site. Get real :-)
3. And on my *other* computer, IE isn't even an option. And your error page
doesn't actually display any info about my browser.
You *really* need to support more than just the most recent version of IE if
you expect to get traffic... :-)
--
Like Music? http://l-i-e.com/artists.htm
I'm looking for a PRO QUALITY two-input sound card supported by Linux (any
major distro). Need to record live events (mixed already) to stereo
CD-quality. Soundcard Recommendations?
Software to handle the recording? Don't need fancy mixer stuff. Zero (0)
post-production time. Just raw PCM/WAV/AIFF 16+ bit, 44.1KHz, Stereo
audio-to-disk.