Hi there, hopefully someone knows the answer to this one:
I have a blog with a personal page where users can edit their information.
On this page I need to sort out the unique logged in user in a recordset and at the same time join information from another table.
Have two tables, one for user login info - Users
and one for contactinformation - Contact
Have tried this:
SELECT *
FROM Users, Contact
WHERE Users.ID=Contact.UserID AND Username = MMColParam
Users.ID and Contact.UserID are both PK
No luck, just getting an empty return.
Using Dreamweaver, Access and Asp.
I have a blog with a personal page where users can edit their information.
On this page I need to sort out the unique logged in user in a recordset and at the same time join information from another table.
Have two tables, one for user login info - Users
and one for contactinformation - Contact
Have tried this:
SELECT *
FROM Users, Contact
WHERE Users.ID=Contact.UserID AND Username = MMColParam
Users.ID and Contact.UserID are both PK
No luck, just getting an empty return.
Using Dreamweaver, Access and Asp.