here is my code
Code: Select all
if ($num_rows!=1)
{
print "<p><b>username and/or password not found. Try
again?</b></p>";
}
else
{
echo " Welcome";
echo'
<table border="0">
<tr>
<td valign="top">
<table border="0">
<tr>
<td bgcolor="cococo">
<a href="index.php">
Home
<font color="cococo">ddddddddddddddddddddd</font>
</a>
</td>
</tr>
<tr>
<td>
welcome $BusinessName,
<font color="ffffff">dddddddddddddddddddfffffffffffffffffffdd</font>
</td>
</tr>
</table>
<table background="../images/fondo2.jpg" border="1" valign="top">
<tr>
<td valign="top">
<table border="1" background="../images/fondo2.jpg" valign="top">
<tr>
<td>
<a href= "http://entrepreneur.com">Pictures Uploads/change</a>
</td>
</tr>
<tr>
<td>
<a href= "http://entrepreneur.com">Advertise your website</a>
</td>
</tr>
<tr>
<td>
</td>
</tr>
<tr>
<td>
<a href="http://69.89.27.201:2082/horde/index.php/">Email</a>
</td>
</tr>
<tr>
<td>
</td>
</tr>
<tr>
<td>
<a href="http://www.nasdaq.com">Stock Market</a>
</td>
</tr>
</table>
</td>
<td valign="top">
<center><table border="1">
<tr>
<td>
<a href=\"update.php?update=true\">update</a>
</td>
<td>
<a href=\"keyword.php?keyword=true\">Add Key words</a>
</td>
<td>
<a href="http://www.ccbill.com">CCBILL</a>
</td>
</tr>
</table>
</center>
// display codes
$sql = "SELECT * FROM business_info WHERE
`BusinessName`= "$BusinessName"
AND `User_Name`="$User_Name"";
$result = mysql_query($query) or die (mysql_error());
$res2 = mysql_fetch_assoc($result);
$BusinessName
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());
}
<table bgcolor="ffffff">
<tr>
<td>
<table>
<tr>
</tr>
</table>
</td>
</tr>
<tr>
<td></td>
</tr>
<tr>
<td>
<table>
<tr>
<td>
<table bgcolor="ffffff ">
<tr>
<td>
<table>
<form action="<?php echo $_SERVER["PHP_SELF"] method="Post" ?>";>
<tr>
<td>
Busiess Info
</td>
</tr>
<tr>
<td>
<table>
<tr>
<td>
Business Name
</td>
<td>
<input type="text" name="BusinessName" Value="$BusinessName">
</td>
</tr>
<tr>
<td>
Slogan
</td>
<td>
<input type="text" NAME="Slogan" value="$Slogan">
</td>
<td>
Website
</td>
<td> <input type="text" name="Website" value="$Website">
</td>
</tr>
<tr>';here is my display
Code: Select all
$sql = "SELECT * FROM business_info WHERE `BusinessName`= "$BusinessName" AND `User_Name`="$User_Name""; $result = mysql_query($query) or die (mysql_error()); $res2 = mysql_fetch_assoc($result); $BusinessName 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()); }
";>also on the values for the form all i get is $VARIABLES
please help