Find the problem in this code
Posted: Sat Aug 26, 2006 8:44 am
feyd | Please use
Everah | Removed DB connection details. PLEASE DO NOT INCLUDE YOUR ACTUAL CONNECTION DETAILS.
feyd | Please use
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
Dear All,
I have the following code,if i run this program the error is " Unable to excute the query:"
Can any one fix the problem
code :Code: Select all
<?
session_start();
$msg_pass="india";
$msg_user="umapathy ";
error_reporting(e_all);
//include("dbconnect.php");
if($_POST['login'])
$username=trim($_POST['username']);
$password=trim($_POST['password']);
echo $username;
echo $password;
if($username && $password)
{
//include database
$con1=mysql_connect("********","****","****");
mysql_select_db("****",$con1);
$sql="SELECT * FROM member WHERE username='".$username."'";
$result=mysql_query($sql,$con1) or die() ;
//echo $result;
if($result)
$count=mysql_num_rows($resulr);
if($count>0)
{
$data=mysql_fetch_assoc($result);
if($data["password"]==$password)
{
$_SESSION["user"]=$username;
echo "true";
}
else
{
$msg_pass="Wrong Password,Please Try again";
}
}
if($user==$username && $pass ==$password and $username !=NULL)
{
if($disable=='Yes')
{
echo "Your account has been disabled";
exit;
}
}
}
else
{
echo "Unable to excute the query:".mysql_errno($con);
}
###########################################
?>
<fieldset>
<legend>Please Login</legend>
<form name="login" method="post" action="<?echo $PHP_SELF ?>">
<?
echo ($msg_user)?"<br/>".$msg_user."<br/>":"";
?>
Username:<input type="text" name="username" maxlength="120"/><br/>
<?
echo($msg_pass)?"<br/>".$msg_pass."<br/>":"";
?>
Password:<input type="password" name="password" maxlength="120" /><br/>
<input type="submit" name="login" value="login"/>
</form></fieldset>feyd | Please use
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]