Jessica

I think you'll have to do several queries - but then you can just add up the numbers to get the total.

If all of your inserts have the or die() part, and you don't get any errors, then it's being inserted.

http://us3.php.net/str_replace See also str_ireplace(), substr_replace(), preg_replace(), and strtr(). Try that first one. i in a function like that normally indicated case-Insensitive

If you're counting Sunday as the beginning of the week, check if it's already sunday today using date(), and if it's not use $sunday = strtotime("last Sunday");

$xx= mysql_query($query); $connection isn't an object, as the error is telling you.

You use ` when the word is a reserved word, such as a field called order. It is a bad idea to have your fields named that way, so you shouldn't generally need to use them. character is a reserved word: http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html You use ' to surround a string. It shouldn't hurt to put single quotes around numbers, as you might get unexpected content, so it can help stop errors.

What are the errors?

mail($addy, $subject, $message, "From: <staff@hobotown.co.uk>")or die(mysql_error()); Firstly, mysql_error() ONLY has to do with MYSQL functions. mail() returns either true or false, based on if it was accepted for delivery. $addy=$object; needs to be $addy=$object['email']; - same with the rest of your arrays[]. It may have gone into your spam folder. If it's not there, contact your webhost, and ask them for help.

Try the Textpad editor, it's a really great one

When you paste your code in here, highlight it and press the # button in the editor to put code tags around it. As ken said, the code is fine. Try using just a plain text editor and writing it, see if that helps.

So during your checking, store the errors into variables. Then check if there are errors. If there are, print the html page with errors, otherwise redirect using header()

Which is line 7? Is that really all of the code? The second call is missing an argument, but that wouldn't show this error. Make 'Dave'); all be on the same line.

You can't use header, you have to use the meta-refresh html tag. Usually you should do all your processing before any html, so you might need to restructure. Also, header has nothing to do with mysql, so why have or die(mysql_error())?

Read the topic about header errors.

what is the primary key? are caveID and tankID set to primary unique keys? If they are, just make them autoincrement and you won't have to send a number for them.

Well what's on line 3 to 14? We can't help if you don't show the code.

You'll need to use the mail() function. There are plenty of tutorials on sending mail with PHP. If you get stuck somewhere, you can post your code and we can help.

Change <input type="checkbox" name="notification_id" value="<? echo $row['id'] ?>"> to <input type="checkbox" name="notification_id[]" value="<? echo $row['id'] ?>">

Can you show an example of what doesn't work? Post your code in code tags. Doing $test = "Text in \\ a File"; should work.

How do you update a page?

GOOGLE for OCTAL TRANSLATOR or OCTAL DECODER

Well we determined it was Octal, and someone already translated it for you. Google will help you find more info.

That doesn't make any sense - you're not calling mysql_fetch_array, you're calling mysql_connect();

$link = mysql_connect('localhost', $mysqluser, $mysqlpass); if (!$link) { $message .= mysql_error($link); This doesn't make any sense, you say if !$link, then try to use $link again. Do this: $link = mysql_connect('localhost', $mysqluser, $mysqlpass) OR die(mysql_error()); Does that print a different error? Is your server localhost, your username and password correct, etc?

It depends on what was used to obfuscate it in the first place.