Ditutup

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:)

Kemahiran: Pemprosesan Data, PHP

Lihat lebih lanjut: n query, simple query, query table, mysql, mysql query, data query, c mysql, php mysql join table, mysql join table, mysql table join, tried, mysql users, mysql user, variable mysql, quot php mysql, simple mysql processing, mysql query php, select name, php mysql quot, mysql work, mysql join, php join tables, wzolka, name select, php mysql table join

Tentang Majikan:
( 6 ulasan ) Toronto, Canada

ID Projek: #32077