thanks for the quick reply its still not working though,
im srunning out of ideas big time, is there anything
you can see that ive done?
Steve
//connected to mysql
$conn = @mysql_connect("$domain","$user","$password")
or die ("Sorry the server is unavailable please try again later");
//echo ("connected to server<p>");
//select database on server
mysql_select_db ("$database") or die ("Sorry the database is unavailable please try again later");
//echo ("connected to database<p>");
//$query = "SELECT * FROM client WHERE bustype = '$tsearch'";
//$query = "SELECT firstname , lastname , address , postcode , phoneno , busname , bustype , web, email FROM client";
$query = "SELECT firstname , lastname , address , postcode , phoneno , busname , bustype , web, email, urllogo FROM client WHERE (bustype = '$tsearch')";
$result = mysql_query($query) or die ("Couldnt execute query");
mysql_query($query);
$num=mysql_numrows($result);
mysql_close($conn);
//Display Results
//echo ("BUSINESS DEVELOPMENT SERVICES<p>");
echo "<Database output>";
$i=0;
while ($i < $num)
{
$firstname=mysql_result($result,$i,"firstname");
$lastname=mysql_result($result,$i,"lastname");
$address=mysql_result($result,$i,"address");
$postcode=mysql_result($result,$i,"postcode");
$busname=mysql_result($result,$i,"busname");
$phoneno=mysql_result($result,$i,"phoneno");
$web=mysql_result($result,$i,"web");
$email=mysql_result($result,$i,"email");
$urllogo=mysql_result($result,$i,"urllogo");
echo "<b>$firstname $lastname</b><br>Company: $busname<br>Address: $address<br>Postcode: $postcode<br>Phone: $phoneno<br><a href=\"mailto:$email\">Email</a><hr><a href=\"$web\">Website</a><hr>";
/<img src="<? echo ($row['$urllogo']); ?>" atl="donsolaris.jpg"/>;
/
$i++;
}
?>
