) // $SQL will contain
"penpals.agegroup IN ( 00,01"
CALL FUNCTION ('check04','04',',', $First) // $SQL will contain
"penpals.agegroup IN ( 00,01,04"
$SQL .= " )"; // $SQL will cont
On 19-Jun-2003 vernon wrote:
>
> OK, I've done this.
>
> Problem occurs when a user selects 1 and 9.
>
> The SQL statement I have reads like so:
>
> if (isset($HTTP_GET_VARS['check00'])) {
> $age00 = '00';
> $s_age00 = "penpals.agegroup = $age00 AND";
> }
>
> Problem is the AND s
ny checks, and because you rip the last or
and replace it with an and, you are always Ok for what follows.
> -Original Message-
> From: vernon [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 19, 2003 1:49 PM
> To: Mike Hillyer
> Subject: RE: Complex SQL involving 10
best regards
Peter
- Original Message -
From: "Mike Hillyer" <[EMAIL PROTECTED]>
To: "vernon" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, June 19, 2003 8:57 PM
Subject: RE: Complex SQL involving 10 checkboxes
Well, if one checkbox represents ages
long to more than one agegroup. If so you better
post what the table looks like.
Regards,
Mike Hillyer
> -Original Message-
> From: vernon [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 19, 2003 1:25 PM
> To: [EMAIL PROTECTED]
> Subject: RE: Complex SQL involvin
nse?
-- Original Message ---
From: "Mike Hillyer" <[EMAIL PROTECTED]>
To: "vernon" <[EMAIL PROTECTED]>,
Sent: Thu, 19 Jun 2003 12:57:20 -0600
Subject: RE: Complex SQL involving 10 checkboxes
> Well, if one checkbox represents ages 1-5, anot
nd send the
resulting string to the server.
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: vernon [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 19, 2003 12:53 PM
> To: [EMAIL PROTECTED]
> Subject: Complex SQL involving 10 checkboxes
>
&g
I'm trying to setup a SQL statement that involes using 10 different
checkboxes. The checkboxes repersent age groups that I need to forward to an
SQL statement. What would be the easiest way to do this?
As I think this through I'm thinking I have to check it 1 and 2 are checked
and not 3-9 and
