Edit More than one field?

[cmccomas]

I have a sports page. I was curious if I could edit each players stats after the game from one page (not one page per player, but one per team) by:

$SELECT id, lastname, totpoints FROM table ORDER BY id DESC;

Then have a table, so that each id will have a row
hidden id
echo row->lastname
input text box for totpoints

then

$UPDATE table WHERE id = 'id' SET $totpoints = totpoints

Could I do this? If my coding thinking is wrong, how can I do it?

[volleytotal_ch]

your SQL statement must be:

UPDATE table SET totpoints = '$totpoints' WHERE id = '$id' 

[kevinsequeira]

u are right, u could do it.

on the form page, get all players for the team , display them in a loop, append each players text box with his id.
<input type=text name=200|totpoints>
//200 is id
once u update, submit the form and on the action page, update the results in a loop once again using the appended id

hope its clear..
reg
kevin

[cmccomas]

Could I do the following:

	$query = "SELECT pid, lastname, points, rebounds FROM roster WHERE pid = '$pid'";
	$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());

// if a result is returned
if (mysql_num_rows($result) > 0)

{
	// turn it into an object
	$row = mysql_fetch_object($result);

	// print form with values pre-filled
?>

<table cellspacing="5" cellpadding="5">
<form action="<?php echo $PHP_SELF; ?>" method="POST">
<input type="hidden" name="pid"  value="<?php echo $pid; ?>">
<tr>
	<td valign="top">Name</td>
	<td valign="top">Points</td>
</tr>
<tr>
	<td valign="top"><font class="normText"><?php echo $row->lastname; ?></font></td>
	<td><input size="3" maxlength="3" type="text" name="points"></td>
</tr>
<tr>
	<td colspan="2" align="center"><input type="Submit" name="submit" value="Update"></td>
</tr>
</form>
</table>
<?php
	}
	// no result returned
	// print graceful error message
	else
	{
		echo "<font class=normText>That press release could not be located in our database.</font>";
	}
}
// form submitted
// start processing it
else
{
	// set up error list array
	$errorList = array();
	$count = 0;

// validate text input fields
if (!$points) { $errorList[$count] = "Invalid entry: Points"; $count++; }

// check for errors
// if none found...
if (sizeof($errorList) == 0)
{
	// open database connection
	$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");

	// select database
	mysql_select_db($db) or die ("Unable to select database!");

	// generate and execute query
	$query = "UPDATE roster SET points = $points WHERE pid = '$pid'";
	$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());