Codes here !
Moderators: macek, egami, gesf
by Redragon » Wed Oct 23, 2002 6:42 am
I need some help. Is there anyway I can have more than one condition in the WHERE function? Or can I use logical operators in it? I want to search the database for something that mite be in more than one column is there anyway I can do that?
-
Redragon
- New php-forum User

-
- Posts: 2
- Joined: Wed Oct 23, 2002 6:39 am
by Oleg Butuzov » Wed Oct 23, 2002 7:20 am
WHERE `colum` expretion 'condition' // for exemple....
one question : DO YOU READ MANUAL AT THE mysql.com ?
-
Oleg Butuzov
- Last Samuray

-
- Posts: 831
- Joined: Sun Jun 02, 2002 3:09 am
by Redragon » Wed Oct 23, 2002 7:21 am
Yah I got that much but I want to have more than one condition there.
-
Redragon
- New php-forum User

-
- Posts: 2
- Joined: Wed Oct 23, 2002 6:39 am
by Oleg Butuzov » Wed Oct 23, 2002 10:17 am
so use more =)
WHERE `id` = '1' AND WHERE `color` = '407090'
for exemple =)
-
Oleg Butuzov
- Last Samuray

-
- Posts: 831
- Joined: Sun Jun 02, 2002 3:09 am
by Jay » Thu Oct 24, 2002 2:13 am
Pejone wrote:so use more =)
WHERE `id` = '1' AND WHERE `color` = '407090'
for exemple =)
or WHERE (`id`=1 and `color` = `407090`)
-
Jay
-
Return to mySQL & php coding
Who is online
Users browsing this forum: No registered users and 1 guest