Help Please!

phpn00bf4life

<html>  

<title>BT SQUAD...CURRENTLY RECRUITING!</TITLE>
<body>

<table border="1" cellpadding="4" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1" height="497">
  <tr>
    <td width="100%" height="19" colspan="2">
    <p align="center">&nbsp;</td>
  </tr>
  <tr>
    <td width="100%" height="19" colspan="2">
    <p align="center">&nbsp;</td>
  </tr>
  <tr>
    <td width="15%" height="457" valign="top">Main ++<p><a href="http://icihost.cwhq.net/phptest/bt/index.php">-Home</a></p>
    <p>-<a href="http://silent-sceptiks.com/mmsforumsf/">Forums</a></p>
    <p>-<a href="http://icihost.cwhq.net/phptest/bt/news.php">News</a></p>
    <p>-<a href="http://icihost.cwhq.net/phptest/bt/files.php">Files</a></p>
    <p>Squad Interaction ++</p>
    <p>-<a href="http://icihost.cwhq.net/phptest/bt/challenge.php">Challenge</a></p>
    <p>-<a href="http://icihost.cwhq.net/phptest/bt/join.php">Join</a></p>
    <p>-<a href="http://icihost.cwhq.net/phptest/bt/roster.php">Roster</a></p>
    <p>-<a href="http://icihost.cwhq.net/phptest/bt/record.php">Record</a></p>
    <p>Other ++</p>
    <p>-<a href="http://icihost.cwhq.net/phptest/bt/about.php">About</a></p>
    <p>-<a href="http://icihost.cwhq.net/phptest/bt/squadlogin.php">Squad Login</a></p>
    <p>-<a href="http://icihost.cwhq.net/phptest/bt/script.php">Custom Scripts</a></p>
    <p>&nbsp;</td>
    <td width="85%" height="457" valign="top">
<html>  

<title>BT SQUAD...CURRENTLY RECRUITING!</TITLE>
<body>

<?php
/*We need to connect to a database, and display the info in table format for the users 
liking, we don't want confusion by the users, and we need to keep this stuff in a mysql so this can be
displayed on a admin page...we need the echo codes to do the html, and we need to connect to the roster 
table of the mysql*/



$db = mysql_connect("localhost");



mysql_select_db("General",$db);



//We're going to pull out the info

$result = mysql_query("SELECT * FROM 'roster'",$db);



//Okay let's display what we've pulled out now
//First we need to make the table
//We'll do this by echo's

echo "<table border=1>\n";


echo "<tr><td>Tag</td><td>email</td><td>aim</td><td>yim</td><td>msnm</td><td>Roll</td></tr>\n";



//Now we will display what we've pulled out 
//by using a while loop.


while($myrow = mysql_fetch_array($result)) {


printf("<tr><td>$myrow[Tag]</td><td>$myrow[email]</td><td>$myrow[aim]</td><td>$myrow[yim]</td><td>$myrow[msnm]</td><td>$myrow[Roll]</td></tr>\n");
}

echo "</table>\n";
?>







</td>
  </tr>
</table>

<p><font size="1">Site design by BT BlimpQuick --
<a href="http://www.btsquad.com">[url]www.btsquad.com[/url]</a>&nbsp; --&nbsp; my personal 
site...<a href="http://blimpquick.btsquad.com"> [url]http://blimpquick.btsquad.com[/url]</a> 
and custom scripting:&nbsp; <a href="http://custom.btsquad.com">
[url]http://custom.btsquad.com[/url]</a>&nbsp; </font></p>
<p><font size="1">Admin login here&nbsp; </font></p>

</body>
</html>
</td>
  </tr>
</table>



</body>
</html>

I keep on getting this error with this code: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/htdocs/zp/phptest/bt/roster.php on line 71

Here is the link or URL: http://icihost.cwhq.net/phptest/bt/roster.php

How may i solve this error ? what am i doing wrong?

phpn00bf4life

this is a script for a roster...like a gaming squad or clan roster!

TheDefender

Remove the quotes from around the table name in your query.

$result = mysql_query("SELECT * FROM roster",$db);

Also, you need to define the username and password in your connection...

$db = mysql_connect("localhost", "?", "?");

phpn00bf4life

i'm still getting a error. click the link above in one of my earlier posts to help me out...y won't it except me !?!?!?!

phpn00bf4life

Here's code now:

<html>  

<title>BT SQUAD...CURRENTLY RECRUITING!</TITLE>
<body>

<table border="1" cellpadding="4" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1" height="497">
  <tr>
    <td width="100%" height="19" colspan="2">
    <p align="center">&nbsp;</td>
  </tr>
  <tr>
    <td width="100%" height="19" colspan="2">
    <p align="center">&nbsp;</td>
  </tr>
  <tr>
    <td width="15%" height="457" valign="top">Main ++<p><a href="http://icihost.cwhq.net/phptest/bt/index.php">-Home</a></p>
    <p>-<a href="http://silent-sceptiks.com/mmsforumsf/">Forums</a></p>
    <p>-<a href="http://icihost.cwhq.net/phptest/bt/news.php">News</a></p>
    <p>-<a href="http://icihost.cwhq.net/phptest/bt/files.php">Files</a></p>
    <p>Squad Interaction ++</p>
    <p>-<a href="http://icihost.cwhq.net/phptest/bt/challenge.php">Challenge</a></p>
    <p>-<a href="http://icihost.cwhq.net/phptest/bt/join.php">Join</a></p>
    <p>-<a href="http://icihost.cwhq.net/phptest/bt/roster.php">Roster</a></p>
    <p>-<a href="http://icihost.cwhq.net/phptest/bt/record.php">Record</a></p>
    <p>Other ++</p>
    <p>-<a href="http://icihost.cwhq.net/phptest/bt/about.php">About</a></p>
    <p>-<a href="http://icihost.cwhq.net/phptest/bt/squadlogin.php">Squad Login</a></p>
    <p>-<a href="http://icihost.cwhq.net/phptest/bt/script.php">Custom Scripts</a></p>
    <p>&nbsp;</td>
    <td width="85%" height="457" valign="top">
<html>  

<title>BT SQUAD...CURRENTLY RECRUITING!</TITLE>
<body>

<?php
/*We need to connect to a database, and display the info in table format for the users 
liking, we don't want confusion by the users, and we need to keep this stuff in a mysql so this can be
displayed on a admin page...we need the echo codes to do the html, and we need to connect to the roster 
table of the mysql*/



$db = mysql_connect("http://cwhq.net","admin123","******");



mysql_select_db("General",$db);



//We're going to pull out the info

$result = mysql_query("SELECT * FROM roster",$db);



//Okay let's display what we've pulled out now
//First we need to make the table
//We'll do this by echo's

echo "<table border=1>\n";


echo "<tr><td>Tag</td><td>email</td><td>aim</td><td>yim</td><td>msnm</td><td>Roll</td></tr>\n";



//Now we will display what we've pulled out 
//by using a while loop.


while($myrow = mysql_fetch_array($result)) {


printf("<tr><td>$myrow[Tag]</td><td>$myrow[email]</td><td>$myrow[aim]</td><td>$myrow[yim]</td><td>$myrow[msnm]</td><td>$myrow[Roll]</td></tr>\n");
}

echo "</table>\n";
?>







</td>
  </tr>
</table>

<p><font size="1">Site design by BT BlimpQuick --
<a href="http://www.btsquad.com">[url]www.btsquad.com[/url]</a>&nbsp; --&nbsp; my personal 
site...<a href="http://blimpquick.btsquad.com"> [url]http://blimpquick.btsquad.com[/url]</a> 
and custom scripting:&nbsp; <a href="http://custom.btsquad.com">
[url]http://custom.btsquad.com[/url]</a>&nbsp; </font></p>
<p><font size="1">Admin login here&nbsp; </font></p>

</body>
</html>
</td>
  </tr>
</table>



</body>
</html>

TheDefender

This should be localhost or something along those lines, not the URL for the website:

$db = mysql_connect("http://cwhq.net","admin123","******"); 
// Should be more like:
$db = mysql_connect("localhost","admin123","******");

Also use die() for debugging...

mysql_connect(yadda yadda) or die(mysql_error());
mysql_query(yadday yadda) or die(mysql_error());
etc...