ok heres what i got so far
<html>
<head>
<title>Here are your records:</title>
<meta http-equiv="Content-Type" content="text/html;
charset=iso-8859-1">
<style type="text/css">
<!--
body {
font-family: Tahoma, Verdana, Arial, sans-serif;
font-size: 16px;
color: #FFFFFF;
background-color: #FFFFFF;
}
.row {
font-family: Tahoma, Verdana, Arial, sans-serif;
font-size: 16px;
font-weight: 900;
color: #FFFFFF;
background-color: #3C4647;
border: 2px solid #FFFFFF;
}
.body2 {
font-family: Tahoma, Verdana, Arial, sans-serif;
font-size: 16px;
font-weight: normal;
color: #000000;
background-color: #536558;
border: 2px solid #FFFFFF;
}
.body1 {
font-family: Tahoma, Verdana, Arial, sans-serif;
font-size: 16px;
font-weight: normal;
background-color: #14900F;
color: #FFFFFF
}
-->
</style>
</head>
<body>
<table width="50%" align="center">
<tr class="row"><td>Id # </td><td>Business
Name</td><td>Description</td><td>Location</td><td>Phone
#</td><td>Web Address</td></tr>
<?php
$connection = mysql_connect("localhost", "blah", "blah") or
die("Error connecting to database");
mysql_select_db("business", $connection);
$result = mysql_query("SELECT * FROM business_list ORDER BY
bus_id", $connection) or die("error querying database");
$i = 0;
while($result_ar = mysql_fetch_assoc($result)){
?>
<tr <?php if($i%2 == 1){ echo "class='body2'"; }else{echo
"class='body1'";}?>>
<td>
<?php echo $result_ar['bus_id']; ?>
</td>
<td>
<?php echo $result_ar['business_name']; ?>
</td>
<td>
<?php echo $result_ar['business_desc']; ?>
</td>
<td>
<?php echo $result_ar['business_location']; ?>
</td>
<td>
<?php echo $result_ar['business_phone']; ?>
</td>
<td>
<?php echo $result_ar['business_website']; ?>
</td>
</tr>
<?php
$i+=1;
}
?>
</table>
</body>
</html>
ok now what i wanna do is take the results from business_website,which are in www.example.com form, and link them to themselves so whatever information in the quary gets used as the link so i dont have to hard code each website in the script. basically so when you click the link it opens whatever website it says.
