tobimichigan Posted August 10, 2009 Share Posted August 10, 2009 Good day Fellow excellent Code Comrades, Please I am in the middle of creating an edit profile page but when I test run this script, on the html form in the browser, rather than echoing the specific column value, it rather echos this><? echo .$pfno; ?> rather than the actual value stored in the field <?php $pfno=$_GET['pfno']; $result=mysql_query("SELECT (*) FROM user_table WHERE pfno=$pfno"); //$result = mysql_fetch_assoc($select); $num=mysql_num_rows($result); 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 ++$i; } ?> <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 type='text' name='pfno' value="<? echo .$pfno; ?>"> </font></td> </tr> <tr> <td height='25'><font size='2' face='verdana'>FIRST NAME</font></td> <td><font size='2' face='verdana'> <input type='text' name='fname' value= "<? echo $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 type='text' name='oname' value= "<? echo $oname; ?>" > </font></td> </tr> <tr> <td height='25'><font size='2' face='verdana'>LAST NAME</font></td> <td><font size='2' face='verdana'> <input type='text' name='lname' value="<? echo $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 type='text' name='soorigin' value="<? echo $soorigin; ?>" > </font></td> </tr> <tr> <td height='25'><font size='2' face='verdana'>LOCAL GOVERNMENT</font></td> <td><font size='2' face='verdana'> <input type='text' name='lga' value="<? echo $lga; ?>" > </font></td> </tr> <tr> <td height='25'><font size='2' face='verdana'>NATIONALITY</font></td> <td><font size='2' face='verdana'> <input type='text' name='Nationalty' value="<? echo $Nationalty; ?>" > </font></td> </tr> <tr> <td height='26'><font size='2' face='verdana'>Email address</font></td> <td><font size='2' face='verdana'> <input type='text' name='email' value="<? echo $email; ?>" > </font></td> </tr> <tr> <td height='25'><font size='2' face='verdana'>RESIDENTIAL ADDRESS</font></td> <td><font size='2' face='verdana'> <input type='textarea' name='residentialadd' value="<? echo $residentialadd; ?>" > </font></td> </tr> <tr> <td height='25'><font size='2' face='verdana'>TELEPHONE NUMBER</font></td> <td><font size='2' face='verdana'> <input type='text' name='residentialadd' value="<? echo $telno; ?>" > </font></td> </tr> <tr> <td height='25'><font size='2' face='verdana'>DEPARTMENT</font></td> <td><font size='2' face='verdana'> <input type='text' name='department'value="<? echo $department; ?>"" > </font></td> </tr> <tr> <td height='25'><font size='2' face='verdana'>MARITAL STATUS</font></td> <td><font size='2' face='verdana'> <input type='text' name='marital' value="<? echo $marital; ?>" > </font></td> </tr> <tr> <td height='25'><font size='2' face='verdana'>SEX</font></td> <td><font size='2' face='verdana'> <input type='text' name='sex' value="<? echo $sex; ?>" > </font></td> </tr> <tr> <td height='25'><font size='2' face='verdana'>AMOUNT DEDUCTIBLE</font></td> <td><font size='2' face='verdana'> <input type='text' name='amountd' value="<? echo $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> <?php $amountd=$_POST['amountd']; $department=$_POST['department']; $email=$_POST['email']; $fname=$_POST['fname']; $lga=$_POST['lga']; $lname=$_POST['lname']; $Nationalty=$_POST['Nationalty']; $oname=$_POST['oname']; $residentialadd=$_POST['residentialadd']; $soorigin=$_POST['soorigin']; $telno=$_POST['telno']; $query = "UPDATE contacts 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(); ?> Besides, this ugly message "Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in line 23" keeps coming up. =>line 23 = $num=mysql_num_rows($result); These are the 2 issues I'm battling with.. please I need your effective pointers.. Link to comment https://forums.phpfreaks.com/topic/169588-sql-update-member-fields/ Share on other sites More sharing options...
ignace Posted August 10, 2009 Share Posted August 10, 2009 use <?php instead of <? Link to comment https://forums.phpfreaks.com/topic/169588-sql-update-member-fields/#findComment-894769 Share on other sites More sharing options...
tobimichigan Posted August 11, 2009 Author Share Posted August 11, 2009 use <?php instead of <? I did as you can see but its still not going through: Check out: <?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... Link to comment https://forums.phpfreaks.com/topic/169588-sql-update-member-fields/#findComment-895491 Share on other sites More sharing options...
ignace Posted August 16, 2009 Share Posted August 16, 2009 if ($row && mysql_num_rows($row)) { $num = mysql_fetch_array($row); } Link to comment https://forums.phpfreaks.com/topic/169588-sql-update-member-fields/#findComment-899343 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.