Ok it's logging in on localhost returning num_rows and affected_rows with 1 for both.
On my live host, it is returning 0.
Does this mean a difference in versions? The select query in the login_select.php file is what it should be. I've echo'd out the password which I use to query the database just before executing the statement and it matches the correct password.
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?