< back to homepage
menu($idc,$idsc,$idsc2,$idnr); ?>
|
|
echo $titlu_pag;?>
PROPERTY NATIONWIDE
$query = "SELECT titlu,subtitlu,id FROM t_articol WHERE priority='1' AND id_issue='".$id_nrcrt."' AND id_subcat='12' AND id_cat='".$idc."'";
$lista = mysql_query($query);
while ($row = mysql_fetch_array($lista, MYSQL_ASSOC)) {
echo '- '.$row['titlu'].'
'.$row['subtitlu'].' ';
}
$query = "SELECT titlu,subtitlu,id FROM t_articol WHERE priority<>'1' AND id_issue='".$id_nrcrt."' AND id_subcat='12' AND id_cat='".$idc."'";
$lista = mysql_query($query);
while ($row = mysql_fetch_array($lista, MYSQL_ASSOC)) {
echo '- '.$row['titlu'].'
'.$row['subtitlu'].' ';
}
?>
|
|
PROPERTY BUCHAREST
$query = "SELECT titlu,subtitlu,id FROM t_articol WHERE priority='1' AND id_issue='".$id_nrcrt."' AND id_subcat='11' AND id_cat='".$idc."'";
$lista = mysql_query($query);
while ($row = mysql_fetch_array($lista, MYSQL_ASSOC)) {
echo '- '.$row['titlu'].'
'.$row['subtitlu'].' ';
}
$query = "SELECT titlu,subtitlu,id FROM t_articol WHERE priority<>'1' AND id_issue='".$id_nrcrt."' AND id_subcat='11' AND id_cat='".$idc."'";
$lista = mysql_query($query);
while ($row = mysql_fetch_array($lista, MYSQL_ASSOC)) {
echo '- '.$row['titlu'].'
'.$row['subtitlu'].' ';
}
?>
|
|
NEW RESIDENTIAL PROJECTS
$query = "SELECT titlu,subtitlu,t_articol.id as id1,issue,has_photo,url FROM t_articol LEFT JOIN t_issues ON t_articol.id_issue=t_issues.id WHERE priority='1' AND id_subcat='15' AND id_cat='".$idc."' ORDER BY year DESC,month DESC LIMIT 2";
$lista = mysql_query($query);
while ($row = mysql_fetch_array($lista, MYSQL_ASSOC)) {
if ($row['issue'] <> $nr_crt ) {
echo ''.$row['issue'].' ';
}
echo '
';
if ($row['has_photo'] == 1) echo '';
echo $row['subtitlu'].' ';
}
?>
|
|
DEAL OF THE MONTH
$query = "SELECT titlu,subtitlu,t_articol.id as id1,issue,has_photo,url FROM t_articol LEFT JOIN t_issues ON t_articol.id_issue=t_issues.id WHERE priority='1' AND id_subcat='13' AND id_cat='".$idc."' ORDER BY year DESC,month DESC LIMIT 2";
$lista = mysql_query($query);
while ($row = mysql_fetch_array($lista, MYSQL_ASSOC)) {
if ($row['issue'] <> $nr_crt ) {
echo ' '.$row['issue'].' ';
}
echo '
';
if ($row['has_photo'] == 1) echo '';
echo $row['subtitlu'].' ';
}
?>
|
|
REAL ESTATE REPORT
$query = "SELECT titlu,subtitlu,t_articol.id as id1,issue,has_photo,url FROM t_articol LEFT JOIN t_issues ON t_articol.id_issue=t_issues.id WHERE priority='1' AND id_subcat='14' AND id_cat='".$idc."' ORDER BY year DESC,month DESC LIMIT 2";
$lista = mysql_query($query);
while ($row = mysql_fetch_array($lista, MYSQL_ASSOC)) {
if ($row['issue'] <> $nr_crt ) {
echo ''.$row['issue'].' ';
}
echo '
';
if ($row['has_photo'] == 1) echo '';
echo $row['subtitlu'].' ';
}
?>
|
|
|
|