MySQL Forums
Forum List  »  Knowledge Base

Query logic
Posted by: Anthony Duncan
Date: August 13, 2009 01:38PM

I have a page with three recordsets (member, company, news). To get to this page a member logs in and creates a session variable to view his or her information. From this page the member can edit their information (name, username, password, affiliated company, news, etc.). I want to display the news currently tied to that member's company on this page, but I'm not sure how to display it. When I filter the news recordset by the session id, it doesn't display correctly.

The id of the company table is stored as a foreign id in both the member and news tables.

I feel like I'm on the verge of figuring this out, but not quite there.

Options: ReplyQuote

Written By
Query logic
August 13, 2009 01:38PM
August 27, 2009 02:42AM
August 31, 2009 08:27AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.