date conversion from mysql

[diasansley]

hey guys the date stored in mysql is yyyy-mm-dd i need to convert it to do a string compare i have used the following

 

$query = "SELECT * FROM booking where id=$sel"; 
            $result = mysql_query($query);
           while ($row = mysql_fetch_array($result))
           { $num1=$row['no_rooms'];
               $from1=$row['from'];
               $to=$row['to'];
               $sel1=$row['room_type'];
               $date = date('d-m-y', strtotime($from1)); 
             
              }
                 echo "$date";

it prints 01-01-70 can any1 tell me where is the error?

 

thanks

[bh]

Hi,

 

becouse you use mysql_fetch_array your $row value has numerical indexes, its not an associative array. So you have $row[0], $row[1] but not $row['to'], $row['from']

use instead mysql_fetch_assoc