/    Sign up×
Community /Pin to ProfileBookmark

matched search criteria

Ok, when the user click on the link which is on a page call business_display.php

[code=php]

this is the link on page business_display.php
$bn = $row[‘BusinessName’];
echo “<a href=”bizwebpage2.php?BusinessName=$bn”>$bn</a>”;

[/code]

user click on the link and it takes them to page

bizwebpage2.php

here is the code for bizwebpage2.php

[code=php]

<?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>&nbsp;</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>&nbsp;</td>
</tr>
</table>
</td>
</tr>
</table>
<?php

?>
[/code]

so how can i display the info that it is on Description1, Description2, ect that matched BusinessName which is on the same row on the table name business_info

to post a comment
PHP

0Be the first to comment 😎

×

Success!

Help @franknu spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 BETA 6.16,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @nearjob,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,
)...