Editing stored data in MySQL

[Anon]

Hello, i am trying to edit information in a MySQL database. Though i dont know the proper SQL syntax. Here's the code i'm working with. I dont know how to correctly select the row i want to edit and than edit a field individually. Please help, i am very new at php and taking on a big project.

Thank You, Jeff....

<?php
if ($doit==1)
{
$user = "USERNAME";
$pass = "PASSWORD";
$db = "DATABASE";

$link = mysql_connect( "localhost", $user, $pass );
if ( ! $link )
die( "Couldn't connect to MySQL" );

mysql_select_db( $db )
or die ( "Couldn't open $db: ".mysql_error() );
$query = "UPDATE rhd_traffic ( name, url, email ) value( '$name', '$url', '$email' )

mysql_query( $query, $link)
or die ( "Couldn't update data to \"rhd_traffic\" tables: "
.mysql_error() );
mysql_close( $link );
?>

<form name="form" action="create_record.php" method="post">
<input type="hidden" name="doit" value="1">

Name: <input type="text" name="name" size="20">
URL: <input type="text" name="url" size="20">
Email: <input type="text" name="email" size="20">

<input type="submit"><input type="reset">

[iifs044]

It sounds to me like you're used to the "select a record, edit record, update record" process used by ADO and DAO with Microsoft products (such as Visual Basic). When doing SQL, you use a little different process.

The basic technique for updating data in any SQL database is:

UPDATE <table> SET column=value WHERE <optional conditions>

So, if you have a table of inventory items, for example, and you want to update the description of part number 2x4x8, you'd use something like this:

UPDATE inventory SET desc='Eight foot two by four' WHERE partnum='2x4x8'

This would update any rows where the part number is '2x4x8' by replacing their existing description with the text shown.

In my example, partnum is probably a unique column (i.e. there is only one row with that value), and therefore, only one row (if any) will be updated.

In a web scenario, in addition to the values you want to place into your database, you have to make sure you post the identifier that uniquely identifies the row to be updated (in my example, partnum).

When the use presses the SUBMIT button, the <FORM>'s ACTION= script formulates an SQL statement like this:

$SQL = "UPDATE inventory SET description='" . $DESC . "', quantity=" . $QUAN . " WHERE partnum='" . $PARTID . "'"

Hope that's helpful.

-- Mitch