Suzanne — Wed, 03 Dec 2003 01:05:44 +0000

http://ca3.php.net/manual/en/ref.mysql.php this may help with other mysql_* functions.

Also: http://ca3.php.net/manual/en/function.count.php if you count after getting the results, if you want to count the number of items that are returned in the array.

Suzanne — Wed, 03 Dec 2003 00:58:10 +0000

<?php
// I'm assuming you actually need a number, no? 
// And so your query is ...mysql_query(\"SELECT
// COUNT(*) FROM ... right?

// if you're using COUNT(*) then you won't have an array?
$result = mysql_fetch_array($query) or die(mysql_error()); 
 
// You should have a while loop here if you are getting an array
// If you are just counting, this should work

if ($result >= 1) { 
    $doit = mysql_query(\"DELETE * 
        FROM news 
        WHERE date='$_POST[date]' 
        AND text='$_POST[text]'\"); 
    if (!$doit) {
        echo mysql_error();
    }
}
?>

When in doubt, echo the $result and see what you're getting.