SQL Statement

[miztas]

I need to select a users details from a databse where I have the username and need to use it to get the age, sex and email address.

I know its something like

select * from users where Username = $Username

But how do I get the other variables out and print them?

Thanks

[laserlight]

Read up on [man]mysql_fetch_array/man.

Actually, there's already a problem with your query, mainly that $Username should be enclosed in (single) quotes.

I suggest you pick up a PHP book that includes a section on mysql.
Either that, or search for an online tutorial.
PHP Builder might have an article on it too.