0 and id_autore='".$autor_id."' ORDER BY data DESC"; $npage=0; $a=mysql_query($strSQL,$db); while($tot=mysql_fetch_array($a)) if ($City == NULL || $City==$news[citta]) $npage++; if ($npage>25) $npage=25; //$npage=($tot[0]/10)+1; echo ''; echo "Select by Author "; $strSQL="SELECT DISTINCT concat(nome,' ',cognome) as autore,author,(select count(infonews.id_autore) from infonews where autore.chiave=infonews.id_autore) as num_news FROM autore ORDER BY nome ASC"; $autore=mysql_query($strSQL,$db); echo' 1){ $inizio=(($pagina-1)*10)+1;} $strSQL="SELECT * FROM infonews where id_autore='".$autor_id."' ORDER BY data DESC"; //cho $strSQL; $new=mysql_query($strSQL,$db)or die("ERRORE QUERY 333". mysql_error()); $cont=0; $cont2=0; while($news=mysql_fetch_array($new)){ $cont=$cont+1; if ($cont>=$inizio And $cont2<10) if ($City == NULL || $City==$news[citta]) { $cont2=$cont2+1; if($cont % 2 ==0){ $classe="propertyRow"; }else{ $classe="propertyRowEven"; } ?>
Title City Country Date Section
infohostels.com

 

--
[',$i,']'; ?>