help with a select
Posted: Wed Mar 30, 2005 1:34 am
i am making this select :
the thing is that i make a search here on an order_id that another user have made, but i check if my user have prviliges
to access this order_id :
the thing is that the query is ok but the name that is return
from the users table is mine and the the original user that made the order!!!
how do i fix it!
thnaks in advance
PEleg
Code: Select all
SELECT * from order_header,users WHERE
order_id='544' AND firm_id=2 AND
(users.user_name='peleg' AND find_in_set('12',users.dep_list)) ORDER BY order_id DESCthe thing is that i make a search here on an order_id that another user have made, but i check if my user have prviliges
to access this order_id :
(users.user_name='peleg' AND find_in_set('12',users.dep_list))
the thing is that the query is ok but the name that is return
from the users table is mine and the the original user that made the order!!!
how do i fix it!
thnaks in advance
PEleg