Time format for my sql

[itohideo]

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

[Sarah]

Hmm strange as your date_format part seems to be correct, although you should be calling mtime not msgtime (you have used an alias)

also I presume that you are doing a full sql query and results set using while and just have not included that part of the code?

$sql="select name,location,url,comments,date_format(msgtime, \"%Y/%m/%d %H:%i:%s\") as mtime 
from guestbook order by msgtime desc";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
echo $row["mtime"];
} 

If that still doesn't work check what table heading and type you are using? datetime should be the correct one?

Sarah