Fejl i update af db!
her er koden:<body>
<b>Gammel Data!</b>
<?
//Db'en kontaktes!
include("db.php");
$result = mysql_query("SELECT * FROM users order by total_points desc");
?>
<table border="1" cellspacing="3" cellpadding="3">
<?
echo "<tr><td><b>Dríver</b><td><b>Team</b><td><b>Poles</b><td><b>Completed Races</b><td><b>Total Points</b></tr>";
while ($myrow = mysql_fetch_array($result))
{
echo "<tr><td>";
echo $myrow["driver"];
echo "</td>";
echo "<td>";
echo $myrow["team"];
echo "</td>";
echo "<td>";
echo $myrow["poles"];
echo "</td>";
echo "<td>";
echo $myrow["completed_races"];
echo "</td>";
echo "<td>";
echo $myrow["total_points"];
echo "</td>";
}
echo "</table>";
?>
<?
$driver = $_POST['driver'];
?>
<b>NY Data!</b>
<form name="input" method="post" action="data_change.php">
<table width="100%" border="0" cellspacing="0" cellpadding="4">
<tr>
<td width="24%" align="left" valign="top">Poles!</td>
<td width="76%"><input name="poles" type="text" id="poles"></td>
</tr>
<tr>
<td align="left" valign="top">Completed Races</td>
<td><input name="completed_races" type="text" id="completed_races"></td>
</tr>
<tr>
<td align="left" valign="top">Total Points</td>
<td><input name="total_points" type="text" id="total_points"></td>
</tr>
<tr>
<td align="left" valign="top"> </td>
<td><input type="submit" name="Submit" value="Send"></td>
</tr>
</table>
</form>
<?
//Lav variabler fra formen på siden.
$poles = $_POST['poles'];
$completed_races = $_POST['completed_races'];
$total_points = $_POST['total_points'];
$sql = mysql_query("UPDATE users SET poles='$poles' WHERE userid='$driver'");
?>
</body>
Den opdaterer bare ikke hjemmesiden med den nye $poles, hvis jeg skriver et tal i stedet for $driver i update linjen virker det. Har testet om variablen $driver bliver sat til et tal, og det gør den. Hvad gør jeg forkert?
//SalmanR
