[PHP & mssql]email verifcation with mssql [REZOLVED]

Quote:

---

Originally Posted by Popa Andrei

Thanks a lot kutsumo,in a bit i will remain at the pc ant start implementing this and i will come with update.Thanks a lot for the help untill now.

Ok i manged to set up mi script to send the email.Now i am facing a big question.What do i do with the stored procedure?
Isnt it simplier to make the confirmation.php page rung the sp if everithyng is ok and the mail is confirmed?

---

That is up to you , you asked for an e-mail confirmation script , not a register script :D

Right now the confirmation.php will display to the user

PHP Code:

---

echo "Your account has been activated"; 


---

use

Code:

---

session_start();

---

Code:

---

session_register();

---

and

Code:

---

if_session_registered();

---

to redirect user upon login to the desired page , or something similar .... look it up on google.

Quote:

---

Originally Posted by Vusion

MSSQL code.

Code:

---

USE [Your Database name]
ALTER TABLE YOURTABLEHERE ADD AccActive int

---

And on the login function, add something like this:

Code:

---

$q = mssql_query("SELECT AccActive FROM YOURTABLE WHERE UserID = '".$_POST['iguess']."'");

if(mssql_result($q, 0, 'AccActive') != 1)
{
  //throw out your message saying it isn't active.
}

---

---

if(mssql_result($q, 0, 'AccActive') != 1)

Can you please tell me what reprezents the red bolded caracter.




EDIT: a big thanks to all who helped.I succesfully made the register function after 2 hard days of work but it worth it :D
Again thanks a lot.

i need help // i need ur script//
we made but its having email problem its work good in website server linux
but its not work windows server 2008 with appserver
need help urget
niravmehta2009@gmail.com

Have you heard of Hooked on phonics?
Didn't think so.
If your thread is "REZOLVED" You might was well cloze it.