mysql_query function

[haref]

Hi ng,
can anybody helps me with this
function ? it does not work ...
i have the connectionID and what does not work is the :

$delSQL = "DELETE FROM data WHERE abmonat < '$month' AND abtag < '$day'";

what is wrong with the $delSQL - Function ?

Here is the function :
....

function delete_old ()
{
$day = date("d");
$month = date("m");
$connectionID = OpenDatabase ();
$delSQL = "DELETE FROM data WHERE abmonat < '$month' AND abtag < '$day'";
$result = mysql_query($delSQL,$connectionID)
or die ("Query failed");
}

[Jochen Buennagel]

haref wrote:

can anybody helps me with this
function ? it does not work ...

Before I even try to test the code: can you specify "does not work"?
Does it output an error? What error? Or does it just not do what you want?

Jochen

--
/**
* @author Jochen Buennagel <zang at buennagel dot com>
*/

[haref]

Jochen Buennagel <za**@buennagel.com> wrote in message news:<bi*************@news.t-online.com>...

haref wrote:

can anybody helps me with this
function ? it does not work ...

Before I even try to test the code: can you specify "does not work"?
Does it output an error? What error? Or does it just not do what you want?

Jochen

Hi Jochen,

It does not do what I want it to do.
It should delete all datasets, which are
not aktual anymore.
(Thats why the "d" and "m" Function)
Thanks for answer.

Regards

Andy