Board index   FAQ   Search  
Register  Login
Board index php forum :: Database mySQL & php coding

Help Retreiving Information from Database

Codes here !

Moderators: macek, egami, gesf

Help Retreiving Information from Database

Postby 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
New php-forum User
 
Posts: 2
Joined: Wed Oct 23, 2002 6:39 am

Postby 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
Last Samuray
 
Posts: 831
Joined: Sun Jun 02, 2002 3:09 am

Postby 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
New php-forum User
 
Posts: 2
Joined: Wed Oct 23, 2002 6:39 am

Postby 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
Last Samuray
 
Posts: 831
Joined: Sun Jun 02, 2002 3:09 am

Postby 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 0 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.