Modifying data in a table

[jamesloi]

Hi,

does anyone know how i can replace data already in a table?

for example i have a field called 'genre' which has data such as 'hip-hop'.

How can i change the word 'hip-hop' to 'hip hop'

any ideas?

[cgraz]

make a form, then use mysql's UPDATE

Here's an example:

-- form.php --
<form method="post" action="process.php">

Genre: <input type="text" name="genre">

<br><br>

<input type="submit" value="Submit">

-- end of form.php --

-- process.php --

<?

mysql_connect("localhost", "user", "pass") or die("couldn't connect");

mysql_select_db("database_name") or die("couldn't connect");

$query = mysql_query("UPDATE table_name SET genre='$genre' WHERE id='5'");

-- end of process.php --

That would update a field called genre with whatever you typed in the form on row 5. If you want it to update genre on a different row, change id to equal that rows id. You will need an id field for this to work. I'm assuming you have one.

if you only want to do this update once, you could get rid of the form all together and just do this:

mysql_connect("localhost", "user", "pass") or die("couldn't connect");

mysql_select_db("database_name") or die("couldn't connect");

$query = mysql_query("UPDATE table_name SET genre='hip hop' WHERE id='5'");

Cgraz