reate an a 2 character INT field and populate it with either 0
(no) or -1 (Yes) then you can get them to work quite well. I'm sure that
some guru will have a better idea than that!
What sort of stuff are you doing?
Craig shepherd
> -Original Message-
> From: Chris Becker [ma
49
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: RE: BETWEEN... LIKE query
>
>
> * Craig Shepherd
> > select * from consumers surname BETWEEN '$surname_from' AND
> '$surname_to'
> >
> > assume $surname_from = A and $surname_to = B
&g
ke to include all records where records also start with B.
For example it would return
A
Allan
Anderson
Appleby
B
But I want it to return
A
Allan
Anderson
Appleby
B
Black
Brown
Butterworth
Has anyone any ideas?
Thanks in ant
$surname_all){ //checks to see if the variable is set
> $surname_query = "WHERE surname between $surname_from and $surname_to";
> } else {
> $surname_query = "";
> }
>
> -Original Message-
> From: Craig Shepherd [mailto:[EMAIL PROTECTED]]
> Sent: Monday,
Using UltraDev 4 with Phakt 1.2.1, linking to a MySQL server 3.22.23
I want to develop a SQL SELECT query where I can vary what customers are
listed depending on the value of various form fields.
For example if the check box surname_all is ticked then all customers are
displayed if not then it di
InterAKT produce a Dreamweaver Ultradev extension called Phakt that is
pretty good. It creates PHP scripts that manipulate MySQL databases. It is
free and allows comparable functionality to the 'native' UltraDev languages
(ASP, JSP, Cold Fusion).
For more info - http://www.interakt.ro/products/PHA
InterAKT produce a Dreamweaver Ultradev extension called Phakt that is
pretty good. It creates PHP scripts that manipulate MySQL databases. It is
free and allows comparable functionality to the 'native' UltraDev languages
(ASP, JSP, Cold Fusion).
For more info - http://www.interakt.ro/products/PH