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($de lSQL,$connectio nID)
or die ("Query failed");


}

[Jochen Buennagel]

Re: mysql_query function

haref wrote:[color=blue]
> can anybody helps me with this
> function ? it does not work ...[/color]

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]

Re: mysql_query function

Jochen Buennagel <zang@buennagel .com> wrote in message news:<bi2mps$8e n$05$1@news.t-online.com>...[color=blue]
> haref wrote:[color=green]
> > can anybody helps me with this
> > function ? it does not work ...[/color]
>
> 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[/color]

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