PHP Code:

// db properties
define('DBHOST','host');
define('DBUSER','user');
define('DBPASS','pass');
define('DBNAME','name');

// make a connection to mysql here
$conn = mysql_connect (DBHOST, DBUSER, DBPASS);
$conn = mysql_select_db (DBNAME);
if(!$conn){
    die( "Sorry! There seems to be a problem connecting to our database.");
}
$sql = mysql_query("SELECT Username, Email FROM sitelok WHERE email='".$_SESSION['ses_slemail']."' AND Username='".$_SESSION["ses_slusername"]."' ")or die(mysql_error());
$n = mysql_num_rows($sql);
if($n == 1){} else {
linklokShowMessage($ErrorTemplate,"The email address provided does not match the one we have on file.<BR><BR>Click your browsers BACK button and try again.");
exit;
} 


what im trying to do is check if an entered email matches with the email of the logged in user...

Are you sure $_SESSION['ses_slemail'] variable is present?
I don't see you have started the session.

my full code is a very long code... i have a session start at the beginning of the code... and also the ses_slemail is present... what shud i do..???


if u want to see the full code here it is http://pastie.org/1099637

Let start from beginning.
Tell us please, what is your expectation, I mean how you expect your code should work? And what messages you've received at the end.

just make sure its executing the if like

PHP Code:

if($n == 1){
echo 'Hello World';
// you code
} 


if it does, then the problem would be in your mail sending code.

From where you are trying run the code, ie from your local or server,

if from local, then have you configured the SMTP host and port properly?

if from server, then check the mail sending functionality by a test page and see whether the mails are sent from your server..

Just to point out -check case sensitivity of fields in MySQL - in your query you refer to selecting the field "Email" - where the field "email" = something... is that intentional?

not it juxt emails the link to any email i enter.. instead i want it to check if the entered email matches with the logged in users email....

and case sensitivity of the SQL fields are ok... i check it.. and if also if its wrong it gives an error....

pls help

What is the error your getting?

Check your http error.log.

its not that im getting an error ... it jux dnt work the way i want it to...
i want it to check if the entered email matches with the email of the logged in user.... but it doesnt...

Originally Posted by luvrockz

my full code is a very long code... i have a session start at the beginning of the code... and also the ses_slemail is present... what shud i do..???


if u want to see the full code here it is http://pastie.org/1099637

I can find the the session_start function call at the beginning, but I can't find the initialization of $_SESSION['ses_slemail'] anywhere in the code? To verify the user input email you must have initialized $_SESSION['ses_slemail'] with one of the elements of $_GET or $_POST or $_REQUEST, where is that line of code?

i dnt understand what you mean... can u explain me a lil bit as i am new to php.... ses_slemail i think is the session email on the user management system....

for example if i want to display the email of the logged in user ...i use this code..

PHP Code:

<?php
require_once("sitelokpw.php");
 echo $slemail; 

?>

what do u think is the probem..
and how can i solve this?