RE: [PHP-DB] Delete by date?
> How would I do that? I just did this: > > $date = date("Y-m-d"); > > and changed my date field in my MySQL DB to use the Date format, I don't > know if that's correct though? Then how would I get to delete all before > the current date? DELETE FROM table WHERE date_column < CURDATE() ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Delete by date?
Sorry, ignore the last message it's working now :-) Thanks for your help though John, got me looking in the right direction. Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Delete by date?
Hi there, How would I do that? I just did this: $date = date("Y-m-d"); and changed my date field in my MySQL DB to use the Date format, I don't know if that's correct though? Then how would I get to delete all before the current date? Sorry to be a pain, date stuff really throws me :-( Chris > > I use the following to store the current date in my db: > > > > $date = date("mdY"); > > > > then to decrease the day by -1 I use the following: > > > > $date = date("Y"); > > $date2 = date("m"); > > $date3 = date("d")-1; > > > > $dateb = '$date$date2$date3'; > > > > Now what I need to do, is when a DB operation is run it checks the DB > to > > see > > if there are any dates that match $dateb or less (Yesterday or before) > and > > then delete those only, leaving todays in the DB, I tried the > following > > with > > no success: > > > > mysql_query ("DELETE FROM orderstemp WHERE < '$dateb' > > "); > > > > This query works if I do a delete by id, but not how i'm doing it > here, > > does > > anyone have any ideas? Be gentle with me, dates are newish to me :-) > > Well, in that case, I recommend you get in the habit of storing your > dates in either the native format of your database or in a unix > timestamp format. You will save yourself tons of work by doing it the > right way. > > The say that you have it now, you'll have to explode that date string > apart into each of it's components, day, month, year, and compare all of > them. Probably easier to do it all in PHP if you're going to do it this > way. > > ---John W. Holmes... > > PHP Architect - A monthly magazine for PHP Professionals. Get your copy > today. http://www.phparch.com/ > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Delete by date?
> I use the following to store the current date in my db: > > $date = date("mdY"); > > then to decrease the day by -1 I use the following: > > $date = date("Y"); > $date2 = date("m"); > $date3 = date("d")-1; > > $dateb = '$date$date2$date3'; > > Now what I need to do, is when a DB operation is run it checks the DB to > see > if there are any dates that match $dateb or less (Yesterday or before) and > then delete those only, leaving todays in the DB, I tried the following > with > no success: > > mysql_query ("DELETE FROM orderstemp WHERE < '$dateb' > "); > > This query works if I do a delete by id, but not how i'm doing it here, > does > anyone have any ideas? Be gentle with me, dates are newish to me :-) Well, in that case, I recommend you get in the habit of storing your dates in either the native format of your database or in a unix timestamp format. You will save yourself tons of work by doing it the right way. The say that you have it now, you'll have to explode that date string apart into each of it's components, day, month, year, and compare all of them. Probably easier to do it all in PHP if you're going to do it this way. ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Delete by date?
Hi there everyone, I use the following to store the current date in my db: $date = date("mdY"); then to decrease the day by -1 I use the following: $date = date("Y"); $date2 = date("m"); $date3 = date("d")-1; $dateb = '$date$date2$date3'; Now what I need to do, is when a DB operation is run it checks the DB to see if there are any dates that match $dateb or less (Yesterday or before) and then delete those only, leaving todays in the DB, I tried the following with no success: mysql_query ("DELETE FROM orderstemp WHERE < '$dateb' "); This query works if I do a delete by id, but not how i'm doing it here, does anyone have any ideas? Be gentle with me, dates are newish to me :-) Thanks. Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php