From: Nayyar Ahmed <nayyares@xxxxxxxxx>
Reply-To: Nayyar Ahmed <nayyares@xxxxxxxxx>
To: php-db@xxxxxxxxxxxxx
Subject: help newbies :)
Date: Thu, 23 Dec 2004 20:54:23 +0500
Hello All,
I am developing attendence mangement system, its my first application
in PHP, I want to compaire the input text box value with table records
the follwing is the code
_____________index.htm_______________
..........
<form name = 'loginfrm' method = post action = "index.php" >
<pre> </td>
</tr>
<tr>
<td width="100%" height="115"><html>
<body>
<div style="mso-border-alt: solid #AAAAFF .75pt; width: 675; height:
234; border: 1.0pt solid #AAAAFF; padding: 6.0pt; background:
#EEEEFF">
<table border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse" bordercolor="#111111" width="100%"
id="AutoNumber2">
<tr>
<td width="25%"><font size="4">User Name:</font></td>
<td width="25%">
<p><input name = "uname" type = "text" size="20"></p>
</td>
<td width="25%"><font size="4">
Class:</font></td>
<td width="25%"> <select name= "class">
<option value = "BBA"> BBA</option>
<option value = "BBA-IT"> BBA-IT</option>
<option value = "BCS"> BCS</option>
<option value = "B.Sc"> B.Sc</option>
<option value = "MBA"> MBA</option>
<option value = "MBA-IT"> MBA-IT</option>
<option value = "MS-IT"> MS-IT</option>
<option value = "MS-CS"> MS-CS</option>
<option value = "Admin"> Admin</option>
</select> </td>
<td width="25%"><font size="4">Password:</font></td>
<td width="25%"><input name ="passwd" type = "password" size="20">
</td>
etc. etc. .......
_____________________________________________________
_________index.php_____________
<?php
$db= mysql_connect("localhost","root","masood");
mysql_select_db("attendence",$db);
$result= mysql_query("select uname,upasswd from user",$db);
while ($myrow = mysql_fetch_array($result))
{
if(($uname == $myrow["uname"]) && ($upasswd == $myrow["uname"]));
{
echo $myrow["uname"];
echo $myrow["upasswd"];
}
}
?>
</body>
</html>
this give me error no 13, with uname,upasswd undefined, please help me out,
TIA
--
Nayyar Ahmad
Lecturer
Faculty Of Computer Science,
Institute Of Management Sciences,
Hayat Abad Peshawar , Pakistan.
Office : 92-091-9217404 , 9217452
Cell : 92-0333-9139461
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
