php function

Advanced search

[Web Designer in need of help]

Yes, here's the actual function in which its been called...



Code:

Code:

1  function random_results()
2  {
3   dbconnect();
4  
5   $row2 = array();
6  
7   $sql = "SELECT * FROM property_info ORDER BY RAND() LIMIT 3";
8   $result = mysql_query($sql) or die(mysql_error());
9  
10  while(($row = mysql_fetch_row($result)) != false)
11  {
12  $location = $row[2]; $location = getlocationname($location);
13  $type = $row[3]; $type = gettypename($type);
14 
15      echo "<table width='140' id='random_results' border='0' cellpadding='0' cellspacing='0'>";
16      echo "<tr>";
17         echo "<td href='javascript:void(0);' onmouseover='return overlib(showRest2(" . $row[18] . " ," . $row[3] ."), MOUSEOFF, BACKGROUND);' onmouseout='return nd();'>link</td>";
18     echo "</tr>";
19  echo "<tr>";
20         echo "<td>€". $row[4] . ", " . $row[18] . " Bedrooms</td>";
21     echo "</tr>";
22 
23         }
24 
25     $table .= "</table>";
26     return $table;
27 
28 
29 }