Quote:
Originally Posted by LearningCoder
Ok it's logging in on localhost returning num_rows and affected_rows with 1 for both.
|
Ok, thats good..
Quote:
Originally Posted by LearningCoder
On my live host, it is returning 0.
|
Bad..
Quote:
Originally Posted by LearningCoder
Does this mean a difference in versions?
|
Possibly but why it would make a difference I've no idea.
Quote:
Originally Posted by LearningCoder
Really at a hurdle which I can't get over. I've looked over and over the code now as you know for the last 3-4 days maybe even longer. Are there any good free debugging tools that you know of?
|
print(), var_dump(), print_r(), x_debug (may not be installed on your host), your brain or even me via a remote connection

(remember though charges apply - £20 per hour, minimum of one hour with no fix no fee).
Also you could comment out the current code (reinstate it later) and run the query through mysql instead of mysqli and see what happens. This is your best next step from my POV as it allows you to determine if the data is being matched correctly or not.