What I mean is I can register and login fine when it's on localhost. When I upload it, it still lets me register and everything goes into the database fine, but when trying to login it executes this part of code:
echo "You entered an invalid username and/or password.<br />";
echo "<a href='login.php'>Please try again</a>";
If you look in my login_select.php this is my else statement to the if which checks the number of 'affected_rows'. I'm not sure why there are no affected_rows, I have also tried num_rows and it still doesn't work. The passwords both get concatenated with the random string and sent to the sha1() function before being used in any query... and the username matches fine because in my do_login script, I check if the user input matches a username.
I also took a note of the mysql and php versions which my domain is using:
PHP version: 5.3.14
MySQL version: 5.5.10
I also noticed it has magic quotes and magic quotes gpc turned on. They sound familiar i'll have a read into them. Not sure if they could be a possible issue?