2 WHERE clauses

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
Jim_Bo
Forum Contributor
Posts: 390
Joined: Sat Oct 02, 2004 3:04 pm

2 WHERE clauses

Post by Jim_Bo »

Hey,

I have a search query that I also need to filter down to userid ..

Code: Select all

$sql = "SELECT id, userid, first_name, last_name, home_no, cell_no, work_no, email FROM address_book WHERE (first_name LIKE('$search%') OR last_name LIKE('%$search%')) ORDER BY first_name ASC";
But I also need to add:

Code: Select all

WHERE `userid` = '{$_SESSIONї'userid']}'
Not sure how to go about it ..

Thanks
User avatar
n00b Saibot
DevNet Resident
Posts: 1452
Joined: Fri Dec 24, 2004 2:59 am
Location: Lucknow, UP, India
Contact:

Post by n00b Saibot »

(untested)

Code: Select all

$sql = "SELECT id, userid, first_name, last_name, home_no, cell_no, work_no, email FROM address_book WHERE (first_name LIKE('$search%') OR last_name LIKE('%$search%')) HAVING `userid` = '{$_SESSIONї'userid']}' ORDER BY first_name ASC";
Try if this works for you...
quarry_06
Forum Newbie
Posts: 2
Joined: Wed Feb 16, 2005 6:37 am

Re: 2 WHERE clauses

Post by quarry_06 »

Jim_Bo wrote:Hey,

I have a search query that I also need to filter down to userid ..

Code: Select all

$sql = "SELECT id, userid, first_name, last_name, home_no, cell_no, work_no, email FROM address_book WHERE (first_name LIKE('$search%') OR last_name LIKE('%$search%')) ORDER BY first_name ASC";
But I also need to add:

Code: Select all

WHERE `userid` = '{$_SESSIONї'userid']}'
Not sure how to go about it ..

Thanks
I'd simply say:

Code: Select all

$sql = "SELECT id, userid, first_name, last_name, home_no, cell_no, work_no, email FROM address_book WHERE (first_name LIKE('$search%') OR last_name LIKE('%$search%')) AND `userid` = '{$_SESSIONї'userid']}' ORDER BY first_name ASC";
User avatar
Maugrim_The_Reaper
DevNet Master
Posts: 2704
Joined: Tue Nov 02, 2004 5:43 am
Location: Ireland

Post by Maugrim_The_Reaper »

As above - place OR expressions in brackets to force the order of evaluation. Same as in basic maths...:)
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

in math you also have

(a and b) or (c and b) <=> (a or c) and b
User avatar
Maugrim_The_Reaper
DevNet Master
Posts: 2704
Joined: Tue Nov 02, 2004 5:43 am
Location: Ireland

Post by Maugrim_The_Reaper »

As I said - basic maths... :wink:
Jim_Bo
Forum Contributor
Posts: 390
Joined: Sat Oct 02, 2004 3:04 pm

Post by Jim_Bo »

Hey,

Thanks guys ..

Code: Select all

$sql = "SELECT id, userid, first_name, last_name, home_no, cell_no, work_no, email FROM address_book WHERE (first_name LIKE('$search%') OR last_name LIKE('%$search%')) HAVING `userid` = '&#123;$_SESSION&#1111;'userid']&#125;' ORDER BY first_name ASC";
seems to work


Thanks
User avatar
n00b Saibot
DevNet Resident
Posts: 1452
Joined: Fri Dec 24, 2004 2:59 am
Location: Lucknow, UP, India
Contact:

Post by n00b Saibot »

Heh Heh Heh 8)
Post Reply