a complicated query

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
User avatar
shiznatix
DevNet Master
Posts: 2745
Joined: Tue Dec 28, 2004 5:57 pm
Location: Tallinn, Estonia
Contact:

a complicated query

Post by shiznatix »

i need to make this query work

Code: Select all

$query = "SELECT * FROM mdl_sm_info WHERE fk_target_group_id='$_SESSION[fk_group_id]'";
	$query .= " OR fk_target_user_id='$_SESSION[user_id]' OR WHERE fk_target_user_id='0'";
	$query .= " AND fk_target_group_id='0' ORDER BY message_id DESC";
but the OR WHERE is giving me a sql syntax error. how should i do that query to make it all work
User avatar
hawleyjr
BeerMod
Posts: 2170
Joined: Tue Jan 13, 2004 4:58 pm
Location: Jax FL & Spokane WA USA

Post by hawleyjr »

Only use WHERE once. use () if you need to group items.
User avatar
shiznatix
DevNet Master
Posts: 2745
Joined: Tue Dec 28, 2004 5:57 pm
Location: Tallinn, Estonia
Contact:

Post by shiznatix »

thanks much
Post Reply