Đã Đóng

mysql query

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 [url removed, login to view] user.user_id

AND [url removed, login to view] '".$_SESSION['useris']."'"

but it didn't work. obviously:)

Kĩ năng: Xử lí dữ liệu, PHP

Xem nhiều hơn: n query, simple query, query table, Mysql, mysql query, data query, c++ mysql, C# MySQL, c mysql, php mysql join table, mysql join table, mysql table join, tried, mysql users, mysql user, variable mysql, quot php mysql, query query, simple mysql processing, mysql query php

Về Bên Thuê:
( 6 nhận xét ) Toronto, Canada

ID dự án: #32077