Tjenare, fattar inte riktigt vad jag gjort för fel här.
Felmeddelande:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/hemsidan/standings.php on line 44
Och här är php koden:
<?php
// Open the database
require 'inc/db.php';
// Count the players
$get = mysql_query("SELECT * FROM Participants");
$rowCount = mysql_num_rows($get);
{
echo "There is a total of $rowCount players.<br>";
}
// Show the players
$get = mysql_query("SELECT * FROM RMRParticipants ORDER BY group");
$previous = "";
while($userRow = mysql_fetch_array($get))
{
$group = $userRow['group'];
$nick = $userRow['nick'];
$frags = $userRow['frags'];
$id = $userRow['id'];
if ($previous != $group)
{
$previous = $group;
echo "<br>Group $group<br>";
echo "$nick<br>";
}
else
{
echo "$nick<br>";
}
}
// Close the database
mysql_close($open);
?>
Sedan kommer här det andra stycket som inte funkar.
Felmeddelande:
You have an error in your SQL syntax near 'group='a', frags='1' WHERE id = '1'' at line
Och här är php koden:
<?php
// Open the database
require '../inc/db.php';
// Edit
$update = "UPDATE Participants SET nick='$_POST[nick]', group='$_POST[group]', frags='$_POST[frags]' WHERE id = '$id'";
$update2 = mysql_query($update) or die (mysql_error());
// Then redirect
echo "<script language=JavaScript>";
echo "self.location.replace('admin.php')";
echo "</script>";
// Close the database
mysql_close();
?>