note 22513 deleted from ref.mysql by philip
| From: | philip@php.net | Date: | Tue, 16 Jul 2002 15:53:21 +0000 |
| Subject: | note 22513 deleted from ref.mysql by philip | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-33137@lists.php.net to get a copy of this message | ||
This may be useful to some people - it creates an update query using the form data passed to it.
$link = mysql_connect("localhost", "username", "password");
mysql_select_db("database");
$fields = mysql_list_fields("database", "tablename", $link);
$columns = mysql_num_fields($fields);
$SQL = "UPDATE tablename SET ";
foreach ($_POST as $key => $value)
{
if ($value != "")
{
for ($i = 0; $i < $columns; $i++)
{
if(mysql_field_name($fields, $i) == $key)
{
if ($i == 0)
{
if (is_numeric($value))
{
$SQL = $SQL . "$key = $value";
}
else
{
$SQL = $SQL . "$key = '$value'";
}
}
else
{
if (is_numeric($value))
{
$SQL = $SQL . ",$key = $value";
}
else
{
$SQL = $SQL . ",$key = '$value'";
}
}
}
}
}
}
$result = mysql_query($SQL);