Log.php returning 'Invalid User' from MySQL database -

i hosting website local computer (using mamp pro on mac), , need switch hosting local mac. have copied across of files website, , mysql tables, , checked server , mysql running ok. seems fine, except login system returning "invalid user" when try log in, though entering correct user info (i have tried few users sure).

the log.php handles login looks this:

<? session_name("mylogin"); session_start();  if($_get['action'] == "login") { $conn = mysql_connect("localhost","root","password"); // mysql connection data $db = mysql_select_db("nick"); //put database name in here  $name = $_post['user']; $q_user = mysql_query("select * users login='$name'");  if(mysql_num_rows($q_user) == 1) {  $query = mysql_query("select * users login='$name'"); $data = mysql_fetch_array($query); if($_post['pwd'] == $data['password']) {  $_session["name"] = $name; header("location: http://monthlymixup.com/may.php"); // success page. put url want  exit; } else { header("location: login.php?login=failed&cause=".urlencode('wrong password')); exit; } } else { header("location: login.php?login=failed&cause=".urlencode('invalid user')); exit; } }  // if session not registered if(session_is_registered("name") == false) { header("location: login.php"); }  ?> 

i have temporarily removed password in above code.

i wonder steps can take troubleshoot issue, , grateful help.

thanks,

nick

a few common techniques when encounter issue.

1. output generated sql , test hand - echo $query;
2. see if mysql_error() outputs after run queries.
3. use var_dump() , print_r() on data objects ensure expected.
4. comment out redirects , exit() lines can determine script breaking.

fix or comment determined above.