Page 1 of 1

Warning: mysql_fetch_array():

Posted: Tue Jul 30, 2002 8:13 pm
by Lance705
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/rsl/public_html/lance/View.php on line 14



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)) &#123; 
?> 
  <tr> 
    <td><?php echo $row&#1111;"ID"]; ?></td> 
    <td><?php echo $row&#1111;"BSID"]; ?></td> 
    <td><?php echo $row&#1111;"NAME"]; ?></td> 
    <td><?php echo $row&#1111;"EMAIL"]; ?></td> 
    <td><?php echo $row&#1111;"RANK"]; ?></td> 
    <td><?php echo $row&#1111;"FLIGHT"]; ?></td> 
    <td><?php echo $row&#1111;"ZONENAME"]; ?></td> 
    <td><?php echo $row&#1111;"PILOTSLOT"]; ?></td> 
  </tr> 
<?php 
&#125; 
?> 
</table>
I hae no Idea what is wrong...

Posted: Tue Jul 30, 2002 8:54 pm
by fatalcure
uhm, you have a Database named "Users" and a table inside the database called "users"?

but neway, try this:

Code: Select all

$connection = mysql_pconnect("localhost", "username", "pass");
mysql_select_db("Users", $connection);

Posted: Tue Jul 30, 2002 8:57 pm
by hob_goblin
try this code:

Code: Select all

<?php 
mysql_connect("localhost", "username", "pass"); 
mysql_select_db("Users"); 

$result = mysql_query("SELECT * FROM users ORDER BY name DESC") or die(mysqlerror());
?> 
<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)) &#123; 
?> 
<tr> 
<td><?=$row&#1111;"ID"]; ?></td> 
<td><?=$row&#1111;"BSID"]; ?></td> 
<td><?=$row&#1111;"NAME"]; ?></td> 
<td><?=$row&#1111;"EMAIL"]; ?></td> 
<td><?=$row&#1111;"RANK"]; ?></td> 
<td><?=$row&#1111;"FLIGHT"]; ?></td> 
<td><?=$row&#1111;"ZONENAME"]; ?></td> 
<td><?=$row&#1111;"PILOTSLOT"]; ?></td> 
</tr> 
<?php 
&#125; 
?> 
</table>
i don't see why you'd want pconnect...

Posted: Tue Jul 30, 2002 9:33 pm
by Lance705
I origanally used $Link =mysql_connect($Host, $User, $Password);

but I saw some examples that did it using pconnect, so I decided to try it that way. Anyways, now I get

Fatal error: Call to undefined function: mysqlerror() in /home/rsl/public_html/lance/View.php on line 5

Posted: Tue Jul 30, 2002 11:20 pm
by hob_goblin
bah, sorry

mysql_error()

Posted: Wed Jul 31, 2002 1:02 am
by Shadough
There could be no table that name or it could be empty possibly :?:

Posted: Wed Jul 31, 2002 1:52 am
by twigletmac
If you don't know what mysql_pconnect() does then use mysql_connect(). It's unlikely that you need a persistant connection to the database. Also have a look in the manual for functions that other people are telling you to use so that you can see what they do (and spot spelling mistakes).

Mac