Script help

[Anon]

Hi,
I currently have a form generated through PHP:

echo "<form method=post action=\"add_edit_band.php\">";
echo "<font face=Verdana, Arial size=2 color=red><b>Band Name:</b></font><br>";
echo "<input type=text name=band_name maxlength=30 size=25 value=\"{$row['band_name']}\"><br><br>";

As you can see it puts the value of 'band_name' into the input field (this value is from the database.

When the submit button is pressed on the form, it activates the add_edit_band.php script.

What i need to know is what script i will need here inorder to update the table with the new data?

[Anon]

<?
$band_name = mysql_escape_string($band_name);

// connect to your database, and select it

// Then run a simple insert query

$query = \"INSERT INTO table_name (band_id, band_name) VALUES (NULL, $band_name)\";

$result = mysql_query($query);
if($result) {
// the query succeeded
else {
// it failed
}