Warning: mysql_fetch_array():
Posted: Tue Jul 30, 2002 8:13 pm
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/rsl/public_html/lance/View.php on line 14
I hae no Idea what is wrong...
Code: Select all
<?php
mysql_pconnect("localhost", "username", "pass");
mysql_select_db("Users");
$result = mysql_query("SELECT * FROM users ORDER BY name DESC");
?>
<table width=500 border=0 cellspacing=1 cellpadding=4>
<tr>
<td bgcolor="#DDDDDD" align=center><b>ID:</b></td>
<td bgcolor="#DDDDDD" align=center><b>BattleStats ID:</b></td>
<td bgcolor="#DDDDDD" align=center><b>Name:</b></td>
<td bgcolor="#DDDDDD" align=center><b>E-Mail:</b></td>
<td bgcolor="#DDDDDD" align=center><b>Rank:</b></td>
<td bgcolor="#DDDDDD" align=center><b>Flight:</b></td>
<td bgcolor="#DDDDDD" align=center><b>Zone Name:</b></td>
<td bgcolor="#DDDDDD" align=center><b>Pilot Slot:</b></td>
</tr>
<?php
while($row = mysql_fetch_array($result)) {
?>
<tr>
<td><?php echo $rowї"ID"]; ?></td>
<td><?php echo $rowї"BSID"]; ?></td>
<td><?php echo $rowї"NAME"]; ?></td>
<td><?php echo $rowї"EMAIL"]; ?></td>
<td><?php echo $rowї"RANK"]; ?></td>
<td><?php echo $rowї"FLIGHT"]; ?></td>
<td><?php echo $rowї"ZONENAME"]; ?></td>
<td><?php echo $rowї"PILOTSLOT"]; ?></td>
</tr>
<?php
}
?>
</table>