problem in fetching date from database

[bandy]

There is a date column in database table in the format as "2010-05-12 15:35:08". I am trying to fetch this field using:

 while($res =  mysql_fetch_array($sql))
  {
   $data = $res['LoginDate']; 
  }

It does not work.

[chathura86]

What was the output you got? Are you sure that you have records for the query? Try the below and post the result:

 while($res =  mysql_fetch_array($sql))
  {
   var_dump($res); 
  }

[Atli]

Hi there,

There is a date column in database table in the format as "2010-05-12 15:35:08"

Iam trying to fetch this field using

 while($res =  mysql_fetch_array($sql))
  {
   $data = $res['LoginDate']; 
  }

not able to get it.

Please help

Hey.

You will have to be more specific. What you posted is far from being enough for us to actually reply with anything useful. We need details, like:

What did you expect this to do? What did it actually do?
Did you get any errors? Warnings? (Are they even turned on?)