mcerveni Posted October 2, 2009 Share Posted October 2, 2009 Here's the example site: www.rimdev.sgspoint.com/agentcenter username: CA705556 leave the password blank, press login. create a password and press finish. it does nothing...lol whyyy. i can't figure it out. i'm connecting to 2 different databases. the username/pass for them are in a functions include page i have. code below: <?php include("header.php"); $ca = $_GET['ca']; $pass = $_GET['pass']; $date = date('l F j, Y'); $handle = mysql_connect($host,$user,$pwd); mysql_select_db($stats, $handle); mysql_query("USE $stats",$handle); $query = "SELECT * FROM employee_compo WHERE EmpID = '$ca'"; $result = mysql_query($query) or die(mysql_error()); $row=mysql_fetch_array($result); $agentName = $row['AgentName']; $email = $row['email']; $empID = $ca; if($row['Email'] == $email && $row['Position'] == "FLA" || $row['Position'] == "PRS" ) { $picture = "pic"; $activated = "yes"; $handle2 = mysql_connect($host,$user,$pwd); mysql_select_db($agentcenter_database, $handle2); mysql_query("USE $agentcenter_database",$handle2); $sql = "INSERT INTO users ( user_id, email, empID, AgentName, password, date, activated, picture) VALUES(0, '$email', '$empID', '$agentName', '$pass', '$date', '$activated', '$picture')"; $insertUser = mysql_query($sql) or die(mysql_error()); $to= "mcervena@sympatico.ca"; $subject = "Activation Email"; $body= "<br><br> You have recently registered to the Agent Support Center. <b> Activate your account below. </b> <br> <br> "; $headers = "From: Agent Support Center \r\n"; $headers .= "MIME-Version: 1.0\r\n"; $headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n"; mail($to, $subject, $body, $headers); echo "You have been sent an email to activate your account! "; } else { echo $ca; echo $pass; echo " <br> <br> <span style='font-size:17px'> <img src='images/invalid.JPG'> <center><a href='index.php'> Error: Try Again </a> </center> </span> "; } ?> Quote Link to comment Share on other sites More sharing options...
btherl Posted October 2, 2009 Share Posted October 2, 2009 $agentName = $row['AgentName']; $email = $row['email']; # <--- $empID = $ca; # vvvvvv if($row['Email'] == $email && $row['Position'] == "FLA" || $row['Position'] == "PRS" ) { I've marked two pieces of code here - one references $row['email'], the other $row['Email']. That looks sus to me. The lowercase one is probably correct. This may lead to the insert query not being executed at all. The other sus thing there is that you probably should write this: if($row['Email'] == $email && ($row['Position'] == "FLA" || $row['Position'] == "PRS" )) { With brackets to tell php exactly how you want that "and/or" to be interpreted. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.