warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/u641301104/public_html/ch-ro-pr/submit.php on line 18
eto po ung code
<?php
require('includes/config.php');
$dbactive = $row['active'];
$user = $_post['user'];
$enroll = $_post['enroll'];
$pass = $_post['pass'];
$re_pass = $_post['re-pass'];
if($user=="" || $pass=="" || $re_pass == "" || $enroll == "" )
header('location:reg.php?err=0');
// echo $user." ".$pass." ".$re_pass
else
if($pass!=$re_pass)
header('location:reg.php?err=1');
else {
$sql = "select null from stud_data where usr_name='".$user."' or usr_roll='".$enroll."'";
$result=mysql_query($sql);
if ($result==false)
{
die(mysql_error());
}
$count = mysql_num_rows($result);
if($count>0)
header('location:reg.php?err=2');
else {
$pass = md5("5".$pass."@");
$sql = "insert into stud_data (usr_name,usr_roll,usr_pass) values('".$user."','".$enroll."','".$pass."')";
mysql_query($sql);
echo "registered successfully, <a href='index.php'>login</a>";
}
}
?>
eto po ung code
<?php
require('includes/config.php');
$dbactive = $row['active'];
$user = $_post['user'];
$enroll = $_post['enroll'];
$pass = $_post['pass'];
$re_pass = $_post['re-pass'];
if($user=="" || $pass=="" || $re_pass == "" || $enroll == "" )
header('location:reg.php?err=0');
// echo $user." ".$pass." ".$re_pass
else
if($pass!=$re_pass)
header('location:reg.php?err=1');
else {
$sql = "select null from stud_data where usr_name='".$user."' or usr_roll='".$enroll."'";
$result=mysql_query($sql);
if ($result==false)
{
die(mysql_error());
}
$count = mysql_num_rows($result);
if($count>0)
header('location:reg.php?err=2');
else {
$pass = md5("5".$pass."@");
$sql = "insert into stud_data (usr_name,usr_roll,usr_pass) values('".$user."','".$enroll."','".$pass."')";
mysql_query($sql);
echo "registered successfully, <a href='index.php'>login</a>";
}
}
?>