RE: [PHP-DB] Delete by date?

2002-12-08 Thread John W. Holmes
> 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?

2002-12-08 Thread Chris Payne
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?

2002-12-08 Thread Chris Payne
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?

2002-12-08 Thread John W. Holmes
> 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?

2002-12-08 Thread Chris Payne
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