just to be more specific the following script is working:
$email=$HTTP_POST_VARS["email"];
$pass=$HTTP_POST_VARS["passw"];
$type1=$HTTP_POST_VARS["type"];
$l="user.htm";
$l2="templogin.htm";
$Connection=odbc_connect("mp","mp","mp");
$in="insert into User values('$email','$pass','$type1')";
$run=odbc_do($Connection,$in);
but this one below, isn't...can someone tell me why cause i dont get it:
$cname =$_POST["name"];
$telno=$_POST["telno"];
$faxno=$_POST["fax"];
$email=$_POST["email"];
$Connection = odbc_connect("mp","mp","mp");
$r="INSERT into Candidate (Tel_No, Name, Fax_No, Email)VALUES($telno,'$cname',$faxno,'$email') where Email=(SELECT Email FROM User where Email='$_SESSION["USER"]')";
$query=odbc_do($Connection, $r);
here telno and faxno are numbers and not strings...as for the echo '$_SESSION["USERNAME"], that too isnt a problem - thats displaying...i really need this to work since my other pages are tied to this...so with this new info, can someone help me out now? mp
|