count deleted rows

I am trying to get the number of rows deleted my code is simple but it always seems to return a 0 value

can you help ??

$conn = db_connect();

$conn->query(“delete from dayofdata
where username = '”.$username."’");

printf(“Records deleted: %d\n”, mysql_affected_rows());

Sponsor our Newsletter | Privacy Policy | Terms of Service