Jump to content

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result

tobimichigan

By tobimichigan
in PHP Coding Help

Recommended Posts

tobimichigan Member

tobimichigan

Posted
Posted

Code Gurus,

Please kindly help me identify what line 21 is doing to hurt the free flow of traffic.

This part of my app happens to be the edit_profile page. It echos the current $result row in html-form then on submit click, it is supposed to update the stored procedures in the table.

Heres the code

 

<?php
$select=mysql_query("SELECT (*) FROM user_table WHERE pfno=$pfno");
$result = mysql_fetch_assoc($select);
//$num=mysql_num_rows($result);
?>
<form action='RegisterMembers_Action.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=<?php echo $result["pfno"]?>>
        </font></td>
    </tr>
    <tr>
      <td height='28'><font size='2' face='verdana'>LEDGER NO.</font></td>
      <td><font size='2' face='verdana'>
        <input type='text' name='ledgerno' value=<?php echo $result["ledgerno"]?>>
        </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= <?php echo $result["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= "<?php echo $result["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="<?php echo $result["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="<?php echo $result["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="<?php echo $result["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="<?php echo $result["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="<?php echo $result["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="<?php echo $result["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="<?php echo $result["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="<?php echo $result["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="<?php echo $result["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="<?php echo $result["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="<?php echo $result["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>

 

the error says Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in line 21, where line 21 is:

 

$result = mysql_fetch_assoc($select);

Please any sharp pointers would be highly appreciated.

halfman Newbie

halfman

Posted
Posted

First

echo $select="SELECT (*) FROM user_table WHERE pfno=$pfno";

 

Run the echo directly from your mysql if everything is ok then

 

$select = mysql_query($select) or die(mysql_error());

 

Dump the error in here and see if you can solve it in here

 

 

 

 

bundyxc Member

bundyxc

Posted
Posted 
<?php
$select= "SELECT * FROM user_table WHERE pfno=$pfno";
$result = mysql_fetch_assoc($select);
$num=mysql_num_rows($result);
?>
<form action='RegisterMembers_Action.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=<?php echo $result["pfno"]?>>
        </font></td>
    </tr>
    <tr>
      <td height='28'><font size='2' face='verdana'>LEDGER NO.</font></td>
      <td><font size='2' face='verdana'>
        <input type='text' name='ledgerno' value=<?php echo $result["ledgerno"]?>>
        </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= <?php echo $result["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= "<?php echo $result["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="<?php echo $result["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="<?php echo $result["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="<?php echo $result["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="<?php echo $result["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="<?php echo $result["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="<?php echo $result["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="<?php echo $result["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="<?php echo $result["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="<?php echo $result["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="<?php echo $result["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="<?php echo $result["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>

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.