my sql is not working
Posted: Thu Mar 29, 2007 9:34 am
ok i have this code to update the database the problem is that my sql is not working for some odd reason maybe because it is inside an php script
here is my code
here is my display
also on the values for the form all i get is $VARIABLES
please help
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