Warning: mysql_fetch_array():

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
Lance705
Forum Newbie
Posts: 17
Joined: Mon Jul 01, 2002 2:15 am

Warning: mysql_fetch_array():

Post 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...
fatalcure
Forum Contributor
Posts: 141
Joined: Thu Jul 04, 2002 12:57 pm
Contact:

Post 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);
User avatar
hob_goblin
Forum Regular
Posts: 978
Joined: Sun Apr 28, 2002 9:53 pm
Contact:

Post 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...
Lance705
Forum Newbie
Posts: 17
Joined: Mon Jul 01, 2002 2:15 am

Post 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
User avatar
hob_goblin
Forum Regular
Posts: 978
Joined: Sun Apr 28, 2002 9:53 pm
Contact:

Post by hob_goblin »

bah, sorry

mysql_error()
Shadough
Forum Newbie
Posts: 20
Joined: Tue Jun 04, 2002 9:11 pm

Post by Shadough »

There could be no table that name or it could be empty possibly :?:
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post 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
Post Reply