Need Simple PHP Help
My code for the validate.php file is below, if someone can point out the error in the code that would be great its not that long of string of code.....
-----------------
<?php
include "conn.php";
$vcode=$_GET[vcode];
$sql1 = "Select * from members where status='Verified'";
$rec1 = mysql_query($sql1,$db) or die (mysql_error());
$trows1 = mysql_numrows($rec1);
$sql = "Select * from members where vcode='$vcode'";
$rs = mysql_query($sql,$db) or die(mysql_error());
$tr=mysql_numrows($rs);
$datas = mysql_fetch_array($rs);
if($tr>0)
{
$sq = "UPDATE members SET status = 'Verified' , vcode='Done' WHERE vcode = '$vcode'";
mysql_query($sq) or dier(mysql_error());
$contents = "<font size='4'> Thank You! Your account is now confirmed... </font><br/><br/><p> <b>You can login now from the "Login" link located to your left under the Members drop down menu.</b>
<br>
";
}
else
{
$contents = "Sorry but we can't complete your request... There are some reason why: <p> <li>Incorrect verification URL </li><li>This account is already verified</li><li>Or This account was banned</li><p>
<br>
If you have questions please send email to webmaster@$domain
";
}
include "template.php";
?>
--------------
Thanks for any help...........
-
kuzmanin -
Thanks - 1 reply
{{ DiscussionBoard.errors[1277813].message }}-
Steve Wells -
Thanks - 1 reply
SignatureNeed Custom Graphics Work? - Message Me For A Design Quote!{{ DiscussionBoard.errors[1277910].message }}-
Bruce Hearder -
[ 1 ] Thanks - 1 reply
{{ DiscussionBoard.errors[1277945].message }}-
Steve Wells -
Thanks - 1 reply
SignatureNeed Custom Graphics Work? - Message Me For A Design Quote!{{ DiscussionBoard.errors[1277973].message }}-
Bruce Hearder -
Thanks
{{ DiscussionBoard.errors[1277989].message }} -
-
-
-
-