selecting date from table problem

[tchick]

Hi All,

 

I am trying to pull a record from my table using the date of birth column (which is a date column) like so..

 

$birthday = ('1936-08-21');
$query = "Select * from my_table where dob = $birthday";
$result = mysql_query($query);
       while ($row = mysql_fetch_array($result)){
        echo "Name is - " .$row['name'];
    }

 

I know there is a record in the table with a date of birth(dob) value of 1936-08-21 but it does not return any records ?

 

thanks for looking, Tony

 

 

[Muddy_Funster]

$query = "Select name from my_table where dob = '$birthday'";

should do it, dates need to be wraped in single quotes within the sql.

[tchick]

Thanks Muddy_Funster, that sorted it.