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
$query = mysql_query("SELECT * from gig WHERE gigName='$gig_name' OR WHERE
gig_fdate='$sdate'");
This one.
I'd suggest you get a book to help you with the basics, something like
this should do (first hit in amazon, haven't actually read this
particular book):
http://www.amazon.com/Learni
In MySQL, both "OR" and "||" are valid logical or operators. You can only
have one Where clause, thus your last example is correct.
--GREG
On Wed, Feb 27, 2008 at 6:44 PM, Nasreen Laghari <[EMAIL PROTECTED]>
wrote:
> Hi All,
>
> Thank you for increasing my knowledge about PHP/MYSQL.
>
> I am cr
Greg Bowser wrote:
In MySQL, both "OR" and "||" are valid logical or operators. You can only
have one Where clause, thus your last example is correct.
Though in postgresql and db2 (and some other dbs) "||" means
"concatenate" so stick with using the word "OR" in this situation
otherwise you'
On Wed, Feb 27, 2008 at 6:44 PM, Nasreen Laghari
<[EMAIL PROTECTED]> wrote:
> 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 inf
On 27 Feb 2008, at 23:44, Nasreen Laghari wrote:
Thank you for increasing my knowledge about PHP/MYSQL.
The question you ask below is basic SQL syntax. Please read the MySQL
manual before asking here - answers at this level are all in there.
http://mysql.com/doc
Oh, and once you have it wo
the struggle against bad code
http://www.fortheloveofgeeks.com
I¹m a geek and I¹m OK!
--
> From: Nasreen Laghari <[EMAIL PROTECTED]>
> Date: Wed, 27 Feb 2008 15:44:23 -0800 (PST)
> To:
> Subject: [PHP-DB] SELECT query with multiple "WHERE" Clause
>
>
>
l Message -
From: Nasreen Laghari <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Date: Wed, 27 Feb 2008 15:44:23 -0800 (PST)
Subject: [PHP-DB] SELECT query with multiple "WHERE" Clause
> Hi All,
>
> Thank you for increasing my knowledge about PHP/MYSQL.
>
> I am creati