[SOLVED] PHP/MySQL mysql_fetch_array() error

[talas]

Hello all,

I am in need.  I am programming a page where leaders of a club can look over and accept new members, but I am always getting a fetch_array error.

 

Here is the error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/ftpgroup/flh/public_html/ams/admin/apps.php on line 37

 

Here is the block of code I am using:

$sql = 'SELECT name FROM about WHERE flh=nonmember';
$result = mysql_query($sql,$con);

echo'
<table>
<tr>
       <th>In-Process Applications</th>
</tr>';

while($row = mysql_fetch_array($result,MYSQL_BOTH)){
extract($row);
echo'
<tr>
       <td><a href="?member=$data">$data</a></td>
</tr>';
}
echo'</table>'; 

 

Any help to solve this would be appreciated!

[NorthWestSimulations]

Try this I have the same error not 5 minutes ago.

$sql = "SELECT `name` FROM `about` WHERE flh = 'nonmember'";
$result = mysql_query($sql,$con);

echo'
<table>
<tr>
       <th>In-Process Applications</th>
</tr>';

while($row = mysql_fetch_array($result,MYSQL_BOTH)){
extract($row);
echo'
<tr>
       <td><a href="?member=$data">$data</a></td>
</tr>';
}
echo'</table>'; 

[talas]

No, still is giving me that error.

[talas]

I got it figured out, I just modified the code from http://www.phpfreaks.com/forums/index.php/topic,95443.0.html and made it do what I wanted.  Now working on additional things for the system I am building.