Same page I was working on before that PARENA and cris lewis helped me with, but I have a new problem.
I am pulling data from the db into a web form. That I have accomplished. However, when I try and pass a php script on it to update the edited data on the form, it doesn't actually update the records. The script that I run gives back no errors.
Here's the form HTML:
<form action="/wtl/update/updated.php">
Name: <input type="text" name="ud_Name" value=http://www.phpbuilder.com/board/archive/index.php/"<? echo "$Name"?>"><br>
Team: <input type="text" name="ud_Team" value="<? echo "$Team"?>"><br>
Rush Yards: <input type="text" name="ud_rushYards" value="<? echo "$rushYards"?>"><br>
Rush Attempts: <input type="text" name="ud_rushAtt" value="<? echo "$rushAtt"?>"><br>
Rush Avg: <input type="text" name="ud_rushAvg" value="<? echo "$rushAvg"?>"><br>
Rush TD: <input type="text" name="ud_rushTD" value="<? echo "$rushTD"?>"><br>
<input type="Submit" value="Update">
</form>
and here is my "updated.php" script:
<?
include("/path/to/include/file.php");
mysql_connect(localhost,$username,$password);
$query="UPDATE WTLtest SET Name='$ud_Name' Team='$ud_Team' rushYards='$ud_rushYards' rushAtt='$ud_rushAtt' rushAvg='$ud_rushAvg' rushTD='$ud_rushTD'";
mysql_query($query);
echo "Record Updated";
mysql_close();
?>
****
I believe the problem stems from somewhere in the form HTML, where I am defining the names and values of the form's textboxes. However, I am lost as to how to correct this.
I am pulling data from the db into a web form. That I have accomplished. However, when I try and pass a php script on it to update the edited data on the form, it doesn't actually update the records. The script that I run gives back no errors.
Here's the form HTML:
<form action="/wtl/update/updated.php">
Name: <input type="text" name="ud_Name" value=http://www.phpbuilder.com/board/archive/index.php/"<? echo "$Name"?>"><br>
Team: <input type="text" name="ud_Team" value="<? echo "$Team"?>"><br>
Rush Yards: <input type="text" name="ud_rushYards" value="<? echo "$rushYards"?>"><br>
Rush Attempts: <input type="text" name="ud_rushAtt" value="<? echo "$rushAtt"?>"><br>
Rush Avg: <input type="text" name="ud_rushAvg" value="<? echo "$rushAvg"?>"><br>
Rush TD: <input type="text" name="ud_rushTD" value="<? echo "$rushTD"?>"><br>
<input type="Submit" value="Update">
</form>
and here is my "updated.php" script:
<?
include("/path/to/include/file.php");
mysql_connect(localhost,$username,$password);
$query="UPDATE WTLtest SET Name='$ud_Name' Team='$ud_Team' rushYards='$ud_rushYards' rushAtt='$ud_rushAtt' rushAvg='$ud_rushAvg' rushTD='$ud_rushTD'";
mysql_query($query);
echo "Record Updated";
mysql_close();
?>
****
I believe the problem stems from somewhere in the form HTML, where I am defining the names and values of the form's textboxes. However, I am lost as to how to correct this.