Sorry I did mean num_rows...lol had affected_rows in my head..
I must say I haven't found any other forum really which has supported my questions as well as CF has which is why I frequent here. Help is always appreciated taking into account you guys don't really need to be sat there going through someone elses work, especially when it turns into a topic like mine ;p
I've just taken a look and I was checking the $stmt with print_r BEFORE executing. I printed afterwards and it seems to just be printing 0 now and not -1....I can't seem to get the error back, sorry.
Just about to put it live again and re-test it.
Will report back in 20.