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' '; while($category=mysql_fetch_array($autore)){ //$link=str_replace(' ', '%20', $category[autore]); //$CATEGORIA=strtoupper($category[autore]); if($category[num_news]>0){ if($category[author]==$_GET['who']){ echo '',$category[autore],''; }else{ echo '',$category[autore],''; } } } ?> 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
				--

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