my issue is that it is not updating or getting the data from the database..
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> ';
?>
<?PHP
$sql = "SELECT * FROM business_info WHERE BusinessName = '$BusinessName' AND User_Name = '$User_Name'";
$result = mysql_query($query) or die ("Problem with the query: <pre>$sql</pre><br>" . mysql_error());
$res2 = mysql_fetch_assoc($result);
$BusinessName
?>
if(isset($_POST["submit"]))
{
<?PHP
$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 ("Problem with the query: <pre>$query</pre><br>" . mysql_error());
?>
}
<?
echo'
<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>
<td>
Tel
</td>
<td>
<input type="text" name="Tel" value="$Tel">
</td>
<td>
Key Words
</td>
<td>
<input type="text" name="Keyword" value="$Keyword">
</td>
</tr>
<tr>
<td>
Fax
</td>
<td>
<input type="text" name="Fax" value="$fax">
</td>
<td>
Address
</td>
<td> <input type="text" name="Business_Address" value="$Business_Address">
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table>
<tr>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</tr>
<tr>
<td>
<input type="submit" value="Update my database" name="submit" />
<input type="reset" value="Reset fields" />
<td>
</form>
>
</tr>
</table> ';
}
?>
here is my display?> " ?>
and only the variables on the value space