Encerrado

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

Habilidades: Processamento de dados, PHP

Ver mais: 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, select name, php mysql quot, mysql work, mysql join, php join tables

Acerca do Empregador:
( 6 comentários ) Toronto, Canada

ID do Projeto: #32077