Call A Record to a Form and Update MySQL

Anon

Hello, i want to get a record from a database, have the fields data in the database and than able to update it. This is the code i am using (below) and am tring to edit the values $name, $url, and $email. Also, the primary key is the field $name.

You help is appreciated. Thank you!

<?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 set name = '$name', url = '$url', email = '$email' where primaryKey = '$primaryKey'"

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

<!--

<form name="form" action="test.php" method="post">
<input type="hidden" name="doit" value="1">
Select Program Name:
<input type="text" name="$primaryKey" size="20">
<br>
Program Name:
<input type="text" name="name" value="<? echo $name ?> size="20">
<br>
Home URL:
<input type="text" name="url" value="<? echo $url ?> size="20">
<br>
Email Address:
<input type="text" name="email" value="<? echo $email ?> size="20">
<br>
<input type="submit"><input type="reset">

</blockquote>
</body>

-->

crislewis

The primary key of a record is its identity. You are trying to change the primary key of a record which is realy creating a new record with similar data. However, if you create a new record do you want the old record to remain? So this is what I would do. Note: If the name has not changed you can use REPLACE instead of UPDATE in the sql.

add a hidden field to the form containing the original primary key.

pseudo code:

if $name = $primarykey

REPLACE record

else

INSERT new record
DELETE old record

Remeber to add error checking so that to old record is not deleted unless the new record has been successfully created.

Cheers,

Cris