List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:March 8 2006 3:08pm
Subject:Re: query problem
View as plain text  
ross@stripped wrote:
> I am fairly new to sql and am now getting into the area of slightly 
> more complex queries.
>
> At present my query is
>
> $query = "SELECT * FROM $table_name WHERE sname LIKE '$search_string%' 
> ORDER BY fname $type";
>
> but I have two other filters which may or may not be chosen. (area, 
> and interest).
>
> $query = "SELECT * FROM $table_name WHERE sname LIKE '$search_string%' 
> AND area='area' AND interest='interest' ORDER BY fname $type";
>
> but what if nether is chosen, or only one? Is there an AND/OR operator 
> or similar in mysql?
No AND/OR. It's the job of the front-end, ie your app, to assemble to 
correct number of Where clauses.

PB

>


-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 268.2.0/275 - Release Date: 3/6/2006

Thread
Data type in MySQL / ASP.netDewald Troskie29 Nov
  • Re: Data type in MySQL / ASP.netStephen Moretti29 Nov
  • query problemross8 Mar
    • Re: query problemPeter Brawley8 Mar
    • Re: query problemDon Read12 Mar