[SOLVED] No errors but doesn't work . . .

[Styles2304]

I'm just trying to clean out my announcement section based on how old the post is.

 

Here's the code:

<?php
include "conn.inc.php";

$query = "DELETE FROM Announcements WHERE (DAY(CURRENT_DATE)-DAY(EntryDate)) > 14;";

mysql_query($query, $link) or die(mysql_error());
?>

 

Everything entered in for $query is right because if I copy and paste it directly into php myadmin, it deletes the rows accordingly.

 

All the login info is stored in conn.inc.php and it works right, it's how I run all my other mysql functions. $link is the mysql_connect statement.

[marcus]

Is the database selected?

[Styles2304]

yes, everything as far connecting to the database and all that crap is good. If I had a select statement in the query and echo'd something, it would work just fine.

[Styles2304]

Ok, just thought I would include this so as to clerify a little maybe?

 

Here is the conn.inc.php:

 

<?php
$link = mysql_connect("localhost","username","password")
  or die(mysql_error());
mysql_select_db("styles_controlpanel")
  or die(mysql_error());
?>

[Styles2304]

o . . . k . . . dunno why this made a difference but I changed it to:

 

DELETE FROM Announcements WHERE (DAYOFYEAR(CURRENT_DATE) - DAYOFYEAR(EntryDate)) > 14;

 

and it works now . . . the other way I had it worked fine in phpMyAdmin, dunno why it wouldn't work in php.