RE: [PHP-DB] Check Boxes
| From: | balwantsingh | Date: | Wed, 18 Aug 2004 09:31:01 +0000 |
| Subject: | RE: [PHP-DB] Check Boxes | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-35773@lists.php.net to get a copy of this message | ||
i am using following coding
$a1 = $_POST['ch1'];
$a2 = $_POST['ch2'];
$a3 = $_POST['ch3'];
if ($a1 or $a2 or $a3) {
$query = "SELECT $a1, $a2, $a3 FROM form";
$result=@mysql_query ($query);
}
Enter_Date<input type="checkbox" name="ch1" value="Enter_Date">
Opening_Units<input type="checkbox" name="ch2"
value="Opening_Units">
Unit_Consumed<input type="checkbox" name="ch3"
value="Unit_Consumed">
-----Original Message-----
From: John Holmes [mailto:holmes072000@charter.net]
Sent: Wednesday, August 18, 2004 5:43 PM
To: balwantsingh@indoasian.com
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] Check Boxes
balwantsingh wrote:
> can somebody advise me
> i want to use checkboxes on my website, i want that if user selects some
> checkboxes (there will be more than 20 checkboxes), checkbox's value will
be
> stored in variables and than SELECT query command will be run using these
> variables through PHP. but my problem is that in SELECT query command
after
> each column name comma (,) is required and if i use the same than it is
> displaying "You have an error in your SQL syntax near 'FROM form' at line
> 1"
How about showing us some code.... kind of hard to help without that...
--
---John Holmes...
Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/
php|architect: The Magazine for PHP Professionals – www.phparch.com