Post
by tobimichigan » Tue Aug 11, 2009 4:37 am
Jack please check out:
[code-php]
<?php
include("cn.php");
$pfno=$_GET['id'];
$row=mysql_query("SELECT (*) FROM user_table WHERE id=$id");
//$result = mysql_fetch_assoc($select);
$num=mysql_fetch_array($row);
//mysql_close();
$i=0;
while ($i < $num) {
$amountd=mysql_result($result,$i,"amountd");
$department=mysql_result($result,$i,"department");
$email=mysql_result($result,$i,"email");
$fname=mysql_result($result,$i,"fname");
$oname=mysql_result($result,$i,"oname");
$lname=mysql_result($result,$i,"lname");
$lga=mysql_result($result,$i,"lga");
$marital=mysql_result($result,$i,"marital");
$Nationalty=mysql_result($result,$i,"Nationalty");
$pfno=mysql_result($result,$i,"pfno");
$residentialadd=mysql_result($result,$i,"residentialadd");
$sex=mysql_result($result,$i,"sex");
$soorigin=mysql_result($result,$i,"soorigin");
$telno=mysql_result($result,$i,"telno");
//Space For Code
$query = ("UPDATE user_table SET amountd = '$amountd', department = '$department', email = '$email', fname = '$fname', lga = '$lga', lname = '$lname',marital='$marital', Nationalty='$Nationalty',oname='$oname', residentialadd='$residentialadd', soorigin='$soorigin',telno='$telno', WHERE pfno = '$pfno'");
mysql_query($query);
echo //"Record Updated";
mysql_close();
++$i;
}
$amountd=$_POST['amountd'];
$department=$_POST['department'];
$email=$_POST['email'];
$fname=$_POST['fname'];
$lga=$_POST['lga'];
$lname=$_POST['lname'];
$marital=$_POST['marital'];
$Nationalty=$_POST['Nationalty'];
$oname=$_POST['oname'];
$residentialadd=$_POST['residentialadd'];
$soorigin=$_POST['soorigin'];
$telno=$_POST['telno'];
?>
<form action='Edit_Profile.php' method='post' enctype='multipart/form-data' name='register'>
<table width='28%' border='0' align='center' cellpadding='0' cellspacing='0'>
<tr>
<td colspan='2'><div align='center'>
<p><font size="2" face="verdana">Edit your Profile</font></p>
</div></td>
</tr>
<tr>
<td width='31%'> </td>
<td width='69%'> </td>
</tr>
<tr>
<td colspan='2'><hr></td>
</tr>
<tr>
<td height='26'><font size='2' face='verdana'>PF NO.</font></td>
<td><font size='2' face='verdana'>
<input name="username" type="text" value="<?php echo $row['pfno'] ?>">
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>FIRST NAME</font></td>
<td><font size='2' face='verdana'>
<input name="username" type="text" value="<?php echo $row['fname'] ?>">
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>OTHER NAMES</font><font size='2' face='verdana'></td>
<td><font size='2' face='verdana'>
<input name="username" type="text" value="<?php echo $row['oname'] ?>">
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>LAST NAME</font></td>
<td><font size='2' face='verdana'>
<input name="username" type="text" value="<?php echo $row['lname'] ?>">
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>STATE OF ORIGIN</font></td>
<td><font size='2' face='verdana'>
<input name="username" type="text" value="<?php echo $row['soorigin'] ?>">
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>LOCAL GOVERNMENT</font></td>
<td><font size='2' face='verdana'>
<input name="username" type="text" value="<?php echo $row['lga'] ?>">
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>NATIONALITY</font></td>
<td><font size='2' face='verdana'>
<input name="username" type="text" value="<?php echo $row['Nationalty'] ?>">
</font></td>
</tr>
<tr>
<td height='26'><font size='2' face='verdana'>Email address</font></td>
<td><font size='2' face='verdana'>
<input name="username" type="text" value="<?php echo $row['email'] ?>">
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>RESIDENTIAL ADDRESS</font></td>
<td><font size='2' face='verdana'>
<input name="username" type="text" value="<?php echo $row['residentialadd'] ?>">
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>TELEPHONE NUMBER</font></td>
<td><font size='2' face='verdana'>
<input name="username" type="text" value="<?php echo $row['telno'] ?>">
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>DEPARTMENT</font></td>
<td><font size='2' face='verdana'>
<input name="username" type="text" value="<?php echo $row['department'] ?>">
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>MARITAL STATUS</font></td>
<td><font size='2' face='verdana'>
<input name="username" type="text" value="<?php echo $row['marital'] ?>">
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>SEX</font></td>
<td><font size='2' face='verdana'>
<input name="username" type="text" value="<?php echo $row['sex'] ?>">
</font></td>
</tr>
<tr>
<td height='25'><font size='2' face='verdana'>AMOUNT DEDUCTIBLE</font></td>
<td><font size='2' face='verdana'>
<input name="username" type="text" value="<?php echo $row['amountd'] ?>">
</font></td>
</tr>
<tr>
<td> </td>
<td><font size='2' face='verdana'>
<input type='submit' name='Submit' value='Update'>
</font></td>
</tr>
<tr>
<td colspan='2'><hr></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
</table>
</form><div align='center'><font size='1' face='verdana'><a href='Admin_Login.php'>Back to login page</a></font></div>
<td colspan='2'><div align='center'><font size='1' face='verdana'>TM</font></div></td>
<td colspan='2'> </td>
</body>
</html>
Is an edit_profile code, which is meant to display existing member information from the database and after editing the info update a table. But its not showing the exisitng data much less updating.
Besides, its morelike show at the top of the browser:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in line24="$num=mysql_fetch_array($row);"
Please any valid pointers would be appreciated. Thanks...