This code works:
Code: Select all
<?php mysql_connect($hostname,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT link, text FROM $collection WHERE co_name='Playful Promises' ORDER BY text ASC";
$result=mysql_query($query);
while ($row = mysql_fetch_array($result))
{
$link = $row[0];
$text = $row[1];
?>
<li><a href="<?php echo $link ?>"><?php echo $text ?></a></li>
<?php
}
?>
Code: Select all
<?php
require 'scripts/db-data.php';
$con = mysql_connect($hostname, $username, $password);
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT co_name,city,coutry,home_link,blog_link,h2_img,logo_large FROM main_info WHERE co_name='Playful Promises'";
$result = mysql_query($query);
while ( $row = mysql_fetch_array($result, MYSQL_BOTH) )
{
$co_name = $row[0];
$city = $row[1];
$country = $row[2];
$homelink = $row[3];
$bloglink = $row[4];
$h2_img = $row[5];
$logo = $row[6];
?>
<h1><img src="<?php echo $h2_img ?>" /></h1>
</div><!-- end introduction div -->
<div id="company_content">
<div id="company_content_top">
<img src="<?php echo $logo ?>" />
<ul>
<li><?php echo $city ?> <?php echo $country ?></li>
<li><a href="<?php echo $home_link ?>"><?php echo $co_name ?> Home</a></li>
<li><a href="<?php echo $blog_link ?>"><?php echo $co_name ?> Blog</a></li>
</ul>
<?php
}
?>
Please Help!
Thanx!