Bloody Hit counter again..

[uatec]

for some reason the following code does everything except what is it intended for. It is designed to reset a hit counter. However it it not doing so.

any ideas??

---

$link = mysql_connect("...","**","**");
mysql_select_db("mdateam",$link) or die(mysql_error());

$query = "DELETE FROM counter1";
$counter = mysql_query($query) or die(mysql_error());
$query = "INSERT INTO counter1 VALUES(" . $POST['count'] . ")";
echo $query;
$counter = mysql_query($query) or die(mysql_error());
echo "Counter set to " . $POST['count'];

[Anon]

The $counter is just set into memory, but it does not execute.

Either write just the mysql_query ... (without asigning it to $counter)

or

do this:
$counter ="DELETE FROM ...";
if ($counter) {
echo "deleted";
}
else {
echo "could not delete";
}

... and do the same in the second $counter

regards Thomas