php/mysql edit function

nukabolhi

I am just trying to make a php edit script using a combo box or any other method. But I am not sure how to write a script when selecting a sportsid and fetch the related data at the same time.

$sql = "SELECT * FROM sports WHERE sport_id=2";
$query = mysql_query($sql);
while ($row = mysql_fetch_array($query)){
	$id = $row['sportid'];
	$sname = $row['sport_name'];
	$sprice = $row['sport_price'];

}
mysql_free_result($query);
?>
<html>
<head>
<title>Edit User Info</title>
</head>
<body>
<form action="updateinfo.php" method="post">
userid:<br/>
<input type="text" value="<?php echo $id;?>" name="id" >
<br/>
Last Name:<br/>
<input type="text" value="<?php echo $sname;?>" name="sname"/>
<br/>
Last Name:<br/>
<input type="text" value="<?php echo $sprice;?>" name="sprice"/>
<br/>
<br/>
<input type="submit" value="submit changes"/>
</form>
</body>
</html>

ixalmida

I'm not sure if I understand your question, but maybe this is what you mean...

// Get THIS sports name information...
$sql = "SELECT * FROM sports WHERE sport_id=2";
$query = mysql_query($sql);
while ($row = mysql_fetch_array($query))
{
	$id = $row['sportid'];
	$sname = $row['sport_name'];
	$sprice = $row['sport_price'];

}

// Get ALL sports names...
$sql = "SELECT * FROM sports_names";
$query = mysql_query($sql);

// Output select tag...
echo "<select name='sport_name'>";

// Output select options...
while($row - mysql_fetch_assoc($query))
{
    // Initialize selected to nothing...
    $selected = "";

// If option matches THIS sport_name, make it the selected option...
if($row['sport_name'] == $sname)
    $selected = "selected";

// Output the option...
echo "<option value='sport_name' $selected>$sport_name</option>";
}

// End the select tag...
echo "</select>";

Obviously, I've left off any HTML formatting and I'm guessing about which field you want to be a drop-down, but hopefully you get the basic concept.