Search results for query: *

it also calculates how many days is left before expiration at the same time. And I display that later using days[$i]

That was inside a for loop with the size of array as a limiter.

I go tit ... here is what I did: $mydate= explode("-",$DBDate[$i]); $year=$mydate[0]+1; $month=$mydate[1]; $day=$mydate[2]; $expiredate=$year."-".$month."-".$day; $today = date("Y-m-d"); $days[$i] = floor((strtotime(date("Y-m-d")) - strtotime($expiredate)) / (60 * 60 * 24 * -1) )...

I don't want it a mysql function...I need it a php function so I can tell the user that that particular product they purchased is expired (they will have more than one product purchased.)

I have a date comming from mysql yyyy-mm-dd I need to be able to distinguish if this date is over 1 year old. The date is also in an array: $mydate[$i] = yyyy-mm-dd; I need a function that will return a true or false if each date in the array is a year old. Thaks, Mike

Thank you

when I add a second WHERE I get an sql error msg $sql = "SELECT * FROM login WHERE (Email = '$email') WHERE crsnum NOT IN (1,4,9,17,19) ORDER BY ID DESC";

I have multiple items that I don't want selected in my select statement...I can get ONE to work here is a sample: $sql = "SELECT * FROM login WHERE (Email = '$email') HAVING Crsnum != 1 ORDER BY ID DESC"; This will not select any Crsnum that =1... The problem I am having is I have multiple...