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
Lance705
Forum Newbie
Posts: 17 Joined: Mon Jul 01, 2002 2:15 am
Post
by Lance705 » 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
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>
I hae no Idea what is wrong...
fatalcure
Forum Contributor
Posts: 141 Joined: Thu Jul 04, 2002 12:57 pm
Contact:
Post
by fatalcure » Tue Jul 30, 2002 8:54 pm
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);
hob_goblin
Forum Regular
Posts: 978 Joined: Sun Apr 28, 2002 9:53 pm
Contact:
Post
by hob_goblin » Tue Jul 30, 2002 8:57 pm
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)) {
?>
<tr>
<td><?=$rowї"ID"]; ?></td>
<td><?=$rowї"BSID"]; ?></td>
<td><?=$rowї"NAME"]; ?></td>
<td><?=$rowї"EMAIL"]; ?></td>
<td><?=$rowї"RANK"]; ?></td>
<td><?=$rowї"FLIGHT"]; ?></td>
<td><?=$rowї"ZONENAME"]; ?></td>
<td><?=$rowї"PILOTSLOT"]; ?></td>
</tr>
<?php
}
?>
</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 » Tue Jul 30, 2002 9:33 pm
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
hob_goblin
Forum Regular
Posts: 978 Joined: Sun Apr 28, 2002 9:53 pm
Contact:
Post
by hob_goblin » Tue Jul 30, 2002 11:20 pm
bah, sorry
mysql_error()
Shadough
Forum Newbie
Posts: 20 Joined: Tue Jun 04, 2002 9:11 pm
Post
by Shadough » Wed Jul 31, 2002 1:02 am
There could be no table that name or it could be empty possibly
twigletmac
Her Royal Site Adminness
Posts: 5371 Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK
Post
by twigletmac » Wed Jul 31, 2002 1:52 am
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