Need help with modifying values
| From: | Anasta | Date: | Sun, 18 Dec 2005 08:21:55 +0000 |
| Subject: | Need help with modifying values | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-227590@lists.php.net to get a copy of this message | ||
The first script works ' modify_values.php' showing the values and a modify
link next to each but the next script it parses to 'modify_values2.php' is
obviously not working. I have tried to modify it from another script and
cant get it to pass the correct variables-- it always shows the first row in
the database . Any help appreciated.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
modify_values.php
<?php
include("connect.php");
$sql = "Select * from leaderboard";
$result = mysql_query($sql);
?>
<br>
<br>
<body bgcolor="#FFFFFF" text="#666666" link="#666666">
<table width="461" border="1" align="center"
cellpadding="2" cellspacing="0"
bordercolor="#FFFFFF" bgcolor="#FFFFFF">
<tr>
<td width="206" height="25" align="center"
bordercolor="#FFFFFF" ><div
align="left"><b>Title</b></div></td>
<td width="165" align="center" bordercolor="#FFFFFF"
bgcolor="#FFFFFF"><div
align="left"><b>Rating</b></div></td>
<td width="70" align="center" bordercolor="#FFFFFF"
bgcolor="#FFFFFF"></td>
</tr>
<?php
while ($myrow = mysql_fetch_array($result)) {
echo "<tr><td>" . $myrow['Name'] . "</td>";
echo "<td>" . $myrow['Rating'] . "</td>";
echo "<td bgcolor='cyan'> <a href='modify_values2.php?id=" .
$myrow['ID'] .
"'>Modify</a></td></tr>";
}
?>
</table>
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
modify_values2.php
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
<?php
include("connect.php");
$sql = "Select * from leaderboard ";
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);
$Name = $myrow['Name'];
$Rating = $myrow['Rating'];
?>
<form name="form1" method="POST" action="update_values.php">
<center>
<table border="1">
<tr>
<td><b>Title</b></td>
<td> <INPUT TYPE=TEXT SIZE="50" NAME="Name"
VALUE="<?php echo
$Name;?>">
</td>
</tr>
<tr>
<td><b>Rating</b></td>
<td> <INPUT TYPE=TEXT SIZE="50" NAME="Rating"
VALUE="<?php echo
$Rating;?>">
</td>
</tr>
</table>
</center>
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
<br><center><input type="submit" name="Update"
value="Update"> <input
type="submit" name="Delete" value="Delete"></center>
</form>
</body>
</html>