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]

@bandy
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?)