time format

Hi how are you doing? I would like to format time for my guestbook. but I get error

I did like this



$sql="select name,location,url,comments,date_format(msgtime, \"%Y/%m/%d %H:%i:%s\") as mtime from guestbook order by msgtime desc";

and
and take out time from my database
echo $row["msgtime"];



I got an error.

Notice: Undefined index: msgtime in c:\ito\guestbookview.php on line 23


Could you tell me the right command to format date?

Thanks all

The SQL query looks okay, it's maybe just that you retrieve the formated value "as mtime", so you have to access this value by using "mtime" as the index, like:


echo $row["mtime"];