You could try something like this:
<?php
$mysql_host = "localhost";
$mysql_login = "username";
$mysql_pw = "password";
if($submit == "Submit"){
$db_security = mysql_connect($mysql_host, $mysql_login, $mysql_pw);
mysql_select_db("dbname",$db_security);
$sql = "UPDATE tablename SET name = '$name' WHERE id = '$id'";
$result = mysql_query($sql);
}else{
echo "<FORM ACTION='$PHP_SELF' METHOD='post'>";
echo "ID : <INPUT TYPE='id' NAME='name' SIZE='5'><BR>";
echo "Name : <INPUT TYPE='text' NAME='name' SIZE='75'><BR>";
echo "<INPUT TYPE='submit' NAME='submit' VALUE='Submit'>";
echo "</FORM>";
}
?>
-----Original Message-----
From: Sandeep Murphy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 5:48 AM
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] updating db
Hi,
Can anyone tell me how I can update a column in MySQL based on form
input????
TIA,
sands
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
