updating the database
Posted: Wed Mar 28, 2007 11:49 am
i need some
i added this line...
bu then i got a syntax error on this line any help please
Code: Select all
if(isset($_POST['submit']))
{
$query="UPDATE business_info SET `BusinessName`= '{$BusinessName}', `Slogan`='{$Slogan}',
`Business_Address`='{$Business_Address}', `Tel`='{$Tel}', `Website`='{$Website}',
`Email`='{$Email}', `Fax`='{$Fax}', `type`='{$type}',
`make`='{$make}', `Categories`='{$Categories}', `Keyword`='{$Keyword}', `Picture1`='{$Picture1}',
`Headline`='{$Headline}', `Slogan2`='{$Slogan2}', `Description1`='{$Description1}',
`Description2`='{$Description2}', `Description3`= '{$Description3}',
`Picture2`='{$Picture2}', `Picture3`='{$Picture3}',
`Password`='{$Password}' WHERE `User_Name`='{$User_Name}'";
$result = mysql_query($query) or die (mysql_error());
}
echo"<table bgcolor='ffffff'>";
echo"<tr>";
echo"<td>";
echo"<table>";
echo"<tr>";
echo"</tr>";
echo"</table>";
echo"</td>";
echo"</tr>";
echo"<tr>";
echo"<td></td>";
echo"</tr>";
echo"<tr>";
echo"<td>";
echo"<table> ";
echo" <tr>";
echo"<td>";
echo"<table bgcolor='ffffff '>";
echo" <tr>";
echo"<td>";
echo"<table>";
echo"<form action=\"{$_SERVER['PHP_SELF']}\" method='Post'>";
echo"<tr>";
echo"<td>";
echo"Business Info";
echo"</td>";
echo"</tr>";
echo"<tr>";
echo"<td>";
echo"<table>";
echo"<tr>";
echo"<td>";
echo"Business Name";
echo"</td>";
echo"<td>
<input type='text' name='BusinessName' Value='$BusinessName'>";
echo" </td>";
echo"</tr>";
echo"<tr>";
echo"<td>";
echo"Slogan";
echo"</td>";
echo"<td>
<input type='text' NAME='Slogan' value='$Slogan'>";
echo" </td>";
echo"<td>";
echo"Website";
echo"</td>";
echo"<td> <input type='text' name='Website' value='$Website'>";
echo"</td>";
echo"</tr>";
echo"<tr>";
echo"<td>";
echo"Tel";
echo"</td>";
echo"<td>
<input type='text' name='Tel' value='$Tel'>";Code: Select all
<input type='text' name='BusinessName' Value='$_POST['BusinessName'],'>";