Hi All,
Thank you for increasing my knowledge about PHP/MYSQL.
I am creating a SEARCH, by only using one table. The search form is same as
Inserting item (search has form of all fields in table ), difference is SEARCH
page doesnt have validation . Therefore user can enter information in any of
field. I would like to know how to write a SELECT query which has multiple
where clause with OR operator.
shall we write:
$query = mysql_query("SELECT * from gig WHERE Name='$name' || WHERE
gig_fdate='$sdate'");
OR
$query = mysql_query("SELECT * from gig WHERE gigName='$gig_name' OR WHERE
gig_fdate='$sdate'");
OR
$query = mysql_query("SELECT * from gig WHERE gigName='$gig_name' ||
gig_fdate='$sdate'");
Regards
Nasreen
____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search.
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
