Home | How it works | Projects archive | Contact Us
Air Compressor Bot
 
The Career Path of Freelance Programming Jobs 

   mysql query

Bidding Time:
04/11/2005 22:38 - 14/11/2005 00:00
Budget:
$30-100
Status:
Closed

Job Type:
PHP, Data Processing
Description:



i need a simple mysql query.
there are two tables. one is user (id, name) the other one is blocked (blocker,
blocked)

i need a query that selects users from the user table that are NOT blocked by a
certain user (whose id is stored in a session variable)

i tried
$query="SELECT user.user_username, user.user_id
FROM blocked
LEFT JOIN (user ON blocked.blocked user.user_id
AND blocked.blocker '".$_SESSION['useris']."'"

but it didn't work. obviously:)

Get $20 Off Panda Internet Security 2008. Coupon Code: WOWPISUSD20.

Related Projects:
20 to 35 Articles on Breastfeeding
Website From Template & SEO
Php Auction Customization/Add On's - Urgent !!
Double sided A6 Leaflet design
Link exchange....

This project is the proprietary information of . Click here to remove this project from OUR database.
Operating System:
(None)
Database System:
MySQL
<<< back

Recent Projects Archive:

Thursday - Wednesday - Tuesday - Monday - Sunday - Saturday - Friday

View all freelance web projects

 
Home | Projects archive | RSS | Resources | Links | Contact Us © 2004-2009 ProjectsList.biz /0.063