Code: Select all
Parse error: parse error, unexpected $ in /home/digslis/public_html/test3.php on line 231Code: Select all
<?php
$search="$HTTP_POST_VARS[search]";
$username="digslis_root";
$password="******";
$database="digslis_addresses";
mysql_connect("localhost",$username,$password);
@mysql_select_db($database) or die( "Unable to select database please use your browser's back key and try again. If this problem persists please try again later");
$query="SELECT * FROM `table` WHERE `digstown` LIKE '$search' OR `nearest` LIKE '$search'";
$result=mysql_query($query)or die (mysql_error());
$num=mysql_num_rows($result);
mysql_close();
echo "<b><center>Search Results</center></b><br>";
echo "Total number of records found = $num";
$i=0;
if ($num==0) {
echo "No records found";
} else {
while ($i < $num)
{
$index=mysql_result($result,$i,"index");
$title=mysql_result($result,$i,"title");
$forename=mysql_result($result,$i,"forename");
$surname=mysql_result($result,$i,"surname");
$suffix=mysql_result($result,$i,"suffix");
$digsad1=mysql_result($result,$i,"digsad1");
$digsad2=mysql_result($result,$i,"digsad2");
$digstown=mysql_result($result,$i,"digstown");
$digscounty=mysql_result($result,$i,"digscounty");
$digspostcode=mysql_result($result,$i,"digspostcode");
$digstele=mysql_result($result,$i,"digstele");
$description=mysql_result($result,$i,"description");
$pic1=mysql_result($result,$i,"pic1");
$pic2=mysql_result($result,$i,"pic2");
$pic3=mysql_result($result,$i,"pic3");
$pic4=mysql_result($result,$i,"pic4");
$pic5=mysql_result($result,$i,"pic5");
$distance=mysql_result($result,$i,"distance");
$cost=mysql_result($result,$i,"cost");
$nearest=mysql_result($result,$i,"nearest");
$contactad1=mysql_result($result,$i,"contactad1");
$contactad2=mysql_result($result,$i,"contactad2");
$contacttown=mysql_result($result,$i,"contacttown");
$contactcounty=mysql_result($result,$i,"contactcounty");
$contactpostcode=mysql_result($result,$i,"contactpostcode");
echo "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">";
echo " <tr bgcolor=\"#BBE1E3\"><td colspan=\"5\"> </td></tr><tr>";
echo " <td colspan=\"2\">$title $forename $surname </td>";
echo " <td width=\"17%\"> </td>";
echo " <td width=\"17%\"> </td>";
echo " <td width=\"28%\">Nearest Theatre:$nearest </td>";
echo " </tr>";
echo " <tr>";
echo " <td width=\"18%\">$digsad1</td>";
echo " <td width=\"20%\"> </td>";
echo " <td> </td>";
echo " <td> </td>";
echo " <td>Distance to theatre:$distance </td>";
echo " </tr>";
echo " <tr>";
if ($digsad2==" ") {
echo " <td> </td>";
echo " <td> </td>";
echo " <td> </td>";
echo " <td> </td>";
echo " <td>Cost:$cost</td>";
echo " </tr>";
echo " <tr>";
echo " <td>$digstown</td>";
echo " <td> </td>";
echo " <td> </td>";
echo " <td> </td>";
echo " <td> </td>";
echo " </tr>";
echo " <tr>";
echo " <td>$digscounty</td>";
echo " <td> </td>";
echo " <td> </td>";
echo " <td> </td>";
echo " <td> </td>";
echo " </tr>";
echo " <tr>";
echo " <td>$digspostcode</td>";
echo " <td> </td>";
echo " <td> </td>";
echo " <td> </td>";
echo " <td> </td>";
echo " </tr>";
echo " <tr>";
echo " <td>$digstele</td>";
echo " <td> </td>";
echo " <td> </td>";
echo " <td> </td>";
echo " <td> </td>";
echo " </tr>";
echo " <tr>";
echo " <td> </td>";
echo " <td> </td>";
echo " <td> </td>";
echo " <td> </td>";
echo " <td> </td>";
echo " </tr>";
echo " <tr>";
echo " <td colspan=\"5\">Description: $description</td>";
echo " </tr>";
echo " <tr>";
echo " <td colspan=\"5\"> </td>";
echo " </tr>";
if ($pic1==" ") {
echo " <tr>";
echo " <td colspan=\"5\"> </td>";
echo " </tr>";
echo "</table>";
$i=$i+1;
} else {
echo " <tr>";
echo " <td colspan=\"5\"><a href=$pic1>Picture 1</a>";
if ($pic2==" ") {
echo "</td>";
echo "</tr>";
} else {
echo " <a href=$pic2>Picture 2</a>";
if ($pic3==" ") {
echo "</td>";
echo "</tr>";
} else {
echo " <a href=$pic3>Picture 3</a>";
if ($pic4==" ") {
echo "</td>";
echo "</tr>";
} else {
echo " <a href=$pic4>Picture 4</a>";
if ($pic5==" ") {
echo "</td>";
echo "</tr>";
} else {
echo " <a href=$pic5>Picture 5</a>";
echo "</td>";
echo " </tr>";}
echo " <tr>";
echo " <td colspan=\"5\"> </td>";
echo " </tr>";
echo "</table>";
$i=$i+1;
}}}}
} else {
echo " <td>$digsad2</td>";
echo " <td> </td>";
echo " <td> </td>";
echo " <td> </td>";
echo " <td>Cost:$cost</td>";
echo " </tr>";
echo " <tr>";
echo " <td>$digstown</td>";
echo " <td> </td>";
echo " <td> </td>";
echo " <td> </td>";
echo " <td> </td>";
echo " </tr>";
echo " <tr>";
echo " <td>$digscounty</td>";
echo " <td> </td>";
echo " <td> </td>";
echo " <td> </td>";
echo " <td> </td>";
echo " </tr>";
echo " <tr>";
echo " <td>$digspostcode</td>";
echo " <td> </td>";
echo " <td> </td>";
echo " <td> </td>";
echo " <td> </td>";
echo " </tr>";
echo " <tr>";
echo " <td>$digstele</td>";
echo " <td> </td>";
echo " <td> </td>";
echo " <td> </td>";
echo " <td> </td>";
echo " </tr>";
echo " <tr>";
echo " <td> </td>";
echo " <td> </td>";
echo " <td> </td>";
echo " <td> </td>";
echo " <td> </td>";
echo " </tr>";
echo " <tr>";
echo " <td colspan=\"5\">Description: $description</td>";
echo " </tr>";
echo " <tr>";
echo " <td colspan=\"5\"> </td>";
echo " </tr>";
if ($pic1==" ") {
echo " <tr>";
echo " <td colspan=\"5\"> </td>";
echo " </tr>";
echo "</table>";
$i=$i+1;
} else {
echo " <tr>";
echo " <td colspan=\"5\"><a href=$pic1>Picture 1</a>";
if ($pic2==" ") {
echo "</td>";
echo "</tr>";
} else {
echo " <a href=$pic2>Picture 2</a>";
if ($pic3==" ") {
echo "</td>";
echo "</tr>";
} else {
echo " <a href=$pic3>Picture 3</a>";
if ($pic4==" ") {
echo "</td>";
echo "</tr>";
} else {
echo " <a href=$pic4>Picture 4</a>";
if ($pic5==" ") {
echo "</td>";
echo "</tr>";
} else {
echo " <a href=$pic5>Picture 5</a>";
echo "</td>";
echo " </tr>";}
echo " <tr>";
echo " <td colspan=\"5\"> </td>";
echo " </tr>";
echo "</table>";
$i=$i+1;
}}}}
}
?>