$query = 'SELECT * FROM my_table ORDER BY RAND() LIMIT 4';// LIMIT 4 - /*означает сколько строк покажет*/
// для отработки
//$result = mysql_query($query) or die('Query failed: ' . mysql_error());
// для рабочего сайта
$result = mysql_query($query);

echo '<table>';
while($arr = mysql_fetch_assoc($result))
    echo '<tr>'
        . '<td>'. $arr['logo'] .'</td>'
        . '<td>'. $arr['region'] .'</td>'
        . '<td>'. $arr['rooms'] .'</td>'
        . '</tr>';
        
echo '</table>';

<?
 require_once 'db.php';
 
 $query = 'SELECT * FROM `my_base` ORDER BY RAND() LIMIT 4';// LIMIT 4 - /*означает сколько строк покажет*/
 $result = mysql_query($query);
 
  $logo = '/uploads/realty/';
 echo '<table>';
while($arr = mysql_fetch_assoc($result)) 
{
    echo '<tr>'
        . '<td>'. $arr['logo'] .'</td>'
        . '<td>'. $arr['region'] .'</td>'
        . '<td>'. $arr['rooms'] .'</td>'
        . '</tr>';
}        
echo '</table>';

?>

for($i=0;$i<$n;$i++) echo "<tr>",mysql_result($result,$i,logo),"</tr><tr>",
mysql_result($result,$i,region),"</tr><tr>",mysql_result($result,$i,rooms),"</tr></tr>";