Just solved it (i hope)
PHP Code:
$query=" SELECT * FROM quartertime WHERE user='$user'"; $result=mysql_query($query);
$num=mysql_numrows($result);
if ($num !=0){
//Amend
} else {
// Create new record
}
The underlying problem was that i had a ; further down in the script preventing it from creating new records <---- DOH
One other thing i need to do though, is check that $quartertime conforms to some criteria
it's a number figure to two decimal places....must be higher than 6, and in the followin format eg. 10.30, 11.99, 9.35 you get the idea, not overly sure how to check that.
Thanks for your assistance guys