Where clause query question

[michaelkirby]

Hi all,

 

I'm creating a query as follows:

 

$query ="select * from brief, subscriptions where brief.briefid = subscriptions.briefid";

 

What I'm trying to achieve is I have a many to many relationship and want to be able to display that tables details which is called subscriptions.

 

As only the brief id is stored in subscriptions I join the tables to get the name of the brief from brief table.

 

This all works fine but I need some advice on adding another where clause in.

 

I want to be able to select the above data but for the user logged in. So I have the user id in the session but how do I append it to the end of the query as I was getting errors doing it.

 

Any one able to help??

 

 

[schilly]

post the query giving the error.

[michaelkirby]

$query ="select * from brief, subscriptions where brief.briefid = subscriptions.briefid and userid = $userid";

 

Error reads...

 

Unable to preform query.br /> select * from brief, subscriptions where brief.briefid = subscriptions.briefid and userid = 1

Column 'userid' in where clause is ambiguous

[Mchl]

You have to indicate in which table is the userid column you're refering to.

[michaelkirby]

Thanks very much I knew I would be missing something small!!!

 

Thanks