Just an IF statement with numbers like 20061028025416 ...

[karthikeyan_coder]

Hello,
        i am getting the values from mysql table... that field type is "TEXT" values are most likely "20061028025416" .. i need to check weater this value is lesser than or equal to 20061108025416 how it is possible? once i cast it as (int) then all of my values are tured in to "2147483647 " 

Thank you.

[ToonMariner]

Use the datatime type in your database table and use the query to make the comparisons - mysql's support for date/time manipulation/calculations is far greater than php's

[karthikeyan_coder]

ohh ok... so i have to convert my script to
$today = date("YmdHis");
$sql = "SELECT * FROM `articles` WHERE `date`<='$today'";

Thanks ToonMariner :)

[karthikeyan_coder]

sorry it is $today = date("YnjHis");