Alrighty...well, I got some awesome help earlier this week concerning taking a datetime field and putting it into human form. As was discussed, any row left NULL would result in a return of 12/31/1969. Unfortunately the database datetime field will have to have NULL values, and all records must be returned with a date. (Hence, you'll see some records with a correct date, and others with the 12/31/1969 date)
Well, as a work around to this, is there a way I can have PHP look at the results, do it's conversion to human form, then evaluate whether or not 12/31/1969 is present, and if so, replace it with something else, or if not, display date?
I know logically what I want it to do, I'm just not versed enough in the ways of PHP to code it out. It's hard to look for resources when you don't know what functions to look up. =/
Any and all help is once again greatly appreciated.
Current code snippet:
$sql = "select UNIX_TIMESTAMP(L_DATE) AS L_DATE FROM table";
results grabbed and converted with:
echo "<td valign=top>".date("m/d/Y",$row["L_DATE"])." </td>";
