[date format question]

hi, i got a DB field that is a DATETIME format and is automatically entered when a user registers. how do i change format from 2003-10-22 10:05:06

 

to something like 10/22/2003 10:05 ??

 

can i modify the existing mysql format?

[assigning query results to variables]

one more question, so if i want to display real name for example after doing the query, i would do this?

 

 

$real_name = $info[\'real_name\']

echo \"your real name is:\" $real_name;

[assigning query results to variables]

great! ill try that, thank you!

[assigning query results to variables]

hi guys got a quick ??

 

i have a database with 4 columns: username, real_name, age and sex

 

the user logs into the site and does an automatic query of his information

 

i need to display to the user an output report which looks something like this:

 

Welcome <? $username ?> //username variable comes from login session

 

Your real name is <? $real_name ?>

Your age is <? $age ?>

etc..

 

all these variables are from the database query // Select * from users where username = $username

 

how do i assign the query results to the output variables ? thanks