This is the issue:
I have a variable: "$LastDownload" which is the last record in a table that identifies the last time a particular query was executed.
I also have a column in another table called "LastAction" which indicates the last time a user updated their information.
Both fields are Date/Time fields and capture the date in the following format:
Code: Select all
$Time = date("Y-m-d H:i:s");Code: Select all
// Select ALL Changed Records:
$UserDataQry = "SELECT * FROM MembersData
WHERE 'LastAction' > '$LastDownload'
ORDER BY UserID";
$UserData = mysql_query($UserDataQry) or die("Error: " . mysql_error());