PHP Script Problem

Anon

Hi,

I have this script to automate standings of a backgammon league. It pulls info from the played matches table and displays points totals and player names.

Unfortunately, it is not working. I'm very new to this stuff and I cannot figure out what is wrong with it. Please help if you can.

Thank You
Rhyan

// create connection
// test connection
// select database
// test selection

$query = "SELECT Winner,SUM(Wins) as sWins FROM submitwk1 GROUP BY Winner ORDER BY sWins DESC";

$mysql_result = mysql_query($query,$connection);
print ("") ;
print ("<Center>");
print ("<TABLE BORDER=\"4\">\n");
print ("<TR>\n");
print ("<TD BGCOLOR=\"#cccccc\">Member Name</TD>\n");
print ("<TD BGCOLOR=\"#cccccc\">Points</TD>\n");

print ("<TR>\n");

$mytable = md5(uniqid(rand())); #create a unique name
$sql = "CREATE TABLE $mytable (name varchar(100),Wins int(10));";
$result = mysql_query($sql,$connection);

while ($row = mysql_fetch_array($mysql_result))
{
$name = $row[0];
$Wins = $row[1];

$query2 = "SELECT SUM(Losses) FROM submitwk1 WHERE Loser = '$name'"; # now create a sql query to get a summary of wins from all lost games

$mysql_result2 = mysql_query($query2,$connection);
$row1 = mysql_fetch_row($mysql_result2);

$SumWins = $Wins+$row1[0]; #here we have the summary of all wins per Player!

$sql = "INSERT INTO $mytable (name,Wins) VALUE ('$name','$Wins');";
$result = mysql_query($sql,$connection);

}

$sql = "SELECT * FROM $mytable ORDER BY Wins;";
$result = mysql_query($sql,$connection);
while ($row = mysql_fetch_array($result))
{
$name = $row[0];
$Wins = $row[1];

print ("<TR>\n");
print ("<TD>$name</TD>\n");
print ("<TD>$SumWins</TD>\n");
print ("<TR>\n");

}
$sql = "DROP TABLE $mytable;";
$result = mysql_query($sql,$connection);

// free resources and close connection
mysql_free_result($sql_result);
mysql_close($connection);

Anon

What is not working? Which part? - please be a little more specific.

Anon

The results of the script I posted, are just the headings, none of the information is displayed. Also, no error message is displayed.

Thank you

Anon

hi rhyan ,

did you test your variable $connection before ?

If you whant error message you should created them like ,
$result= mysql_query($query, $connection);
if ($result)
if (!mysql_query($query, $connection));
{
printError(sprintf(" problem with the variable result));
printerror(sprintf("error:%d %s", mysql_errno($link), mysql_error($link)));
exit();
}

and you have to parse your script of this kind of error checker every where you declare a variable by connection to mysql..

see ya,

jerry

Anon

Have you tried looking at the HTML source?

You aren't closing your table, but more importantly, even if you were, if there
were an error before you closed the table
than the closing the table code wouldn't
be reached by PHP.

If you are getting a blank page, try
looking at the HTML source to see if
there is an error occuring.