Code: Select all
this is the link on page business_display.php
$bn = $row['BusinessName'];
echo "<a href=\"bizwebpage2.php?BusinessName=$bn\">$bn</a>";bizwebpage2.php
here is the code for bizwebpage2.php
Code: Select all
<?php
$host = "localhost";
$username = "localhost";
$password = "abc123";
$database = "contacts";
$db = mysql_connect($host, $username, $password) or die(mysql_error());
mysql_select_db($database) or die(mysql_error());
$BusinessName = ($_POST['BusinessName']);
$Keyword =($_POST['Keyword']);
$Picture1 = ($_POST['Picture1']);
$Headline = ($_POST['Headline']);
$Slogan2 = ($_POST['Slogan2']);
$Description1 =($_POST['Description1']);
$Description2 = ($_POST['Description2']);
$Description3= ($_POST['Description3']);
$Contact2 = ($_POST['Contact2']);
$Picture2 = ($_POST['Picture2']);
$Picture3 = ($_POST['Picture3']);
if($BusinessName)
{
$query = "SELECT * FROM business_info WHERE `BusinessName`= '$BusinessName' ";
$result = mysql_query($query) or die (mysql_error());
}
?>
<table>
<tr>
<td>
<table>
<tr>
<td valign="top">
<table>
<tr>
<td valign="top">
<table>
<tr>
<td><?php echo"$Logo"; ?></td>
</tr>
<tr>
<td valign="top"><h2><?php echo "<h2>$BusinessName</h2>"; ?></h2></td>
</tr>
<tr>
<td valign="top"><?php echo "$Description1"; ?></td>
</tr>
<tr>
<td valign="top"><?php echo "$Description2"; ?></td>
</tr>
<tr>
<td valign="top"><?php echo "$Description3"; ?></td>
</tr>
<tr>
<td valign="top"><?php echo "$Contact2"; ?></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
<td valign="top">
<table>
<tr>
<td> </td>
</tr>
<tr>
<td valign="top"><?php echo"<img src='$Picture2' width='200' height='250'>"; ?>
</td>
</tr>
<tr>
<td valign="top"> <?php echo "<img src='$Picture3' width='200' height='250'>"; ?> </td>
</tr>
</table>
</td>
</tr>
</table>
<table border='1'>
<tr>
<td> </td>
</tr>
</table>
</td>
</tr>
</table>
<?php
?>