I have a simple search and results display page designed. Its been working fine but suddenly over xmas it has changed...
One of the fields in the database is a weblink to a page, I have set a default value of (sample) in the database in case no link was contained, this leads to a page saying no webpage available for this person. However this is no longer happening, the link bar at the bottom of explorer shows the links when hovering pointing to
I have put the PHP code snippet below, is this still ok? Can anyone think of a reason this would happen?
Thanks for you help in advance
One of the fields in the database is a weblink to a page, I have set a default value of (sample) in the database in case no link was contained, this leads to a page saying no webpage available for this person. However this is no longer happening, the link bar at the bottom of explorer shows the links when hovering pointing to
I have put the PHP code snippet below, is this still ok? Can anyone think of a reason this would happen?
Code:
$sql = "select * from aromaol where town = '".$_POST['seek']."' or postcode = '". $_POST['seek'] ."'";
$result = mysql_query($sql,$conn)or die (mysql_error());
if (mysql_num_rows($result)==0){
echo "No Match Found";
}else{
while ($row = mysql_fetch_assoc($result)){
echo "Name: " .$row['forename']." ".$row["surname"]."<br>";
echo "".$row["town"]."<br>";
echo "Tel No: ".$row['telno']."";
echo " Mobile No: ".$row["mobno"]."<br>";
echo "Link: <a href=\"[URL unfurl="true"]http://".$row[/URL]['weblink']."\">Visit their webpage</a><br><br>";
?>
Thanks for you help in advance