Queries for member accounts

[dave1236]

Quick question for group...

I am in the process of adding the ability for my registered members to check their accounts, and am struggling with the proper way to wirte a query that will pull the relevant records based on a users loginname.

Any advice is greatly appreciated.

[dreamcatcher]

SELECT * FROM table WHERE username = 'name' LIMIT 1

dc