By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,890 Members | 1,050 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,890 IT Pros & Developers. It's quick & easy.

mysql_query function

P: n/a
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");
}
Jul 16 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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>
*/

Jul 16 '05 #2

P: n/a
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
Jul 16 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.