selecting from database
Posted: Fri Mar 30, 2007 3:39 pm
ok, i am having couple of issues from a self form that needs to select databata from the database and update that date
my issue is that it is not updating or getting the data from the database..
here is my code
if(isset($_POST["submit"])) { }
?> " ?>
and only the variables on the value space
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