function TagliaStringa($stringa, $max_char){
if(strlen($stringa)>$max_char){
$stringa_tagliata=substr($stringa, 0,$max_char);
$last_space=strrpos($stringa_tagliata," ");
$stringa_ok=substr($stringa_tagliata, 0,$last_space);
return $stringa_ok;
}else{
return $stringa;
}
}
$pag = $_GET["pag"];
if (isset($pag) == false || is_numeric($pag) == false || $pag < 1)
{
$pag = 1;
}
$fine = 2;
$inizio = ($pag - 1) * $fine;
$cn = mysql_connect($dbhost, $dbuser, $dbpass);
mysql_select_db($dbname, $cn);
?>
$sql = "SELECT * FROM azz_offerta WHERE pubb='1' ORDER BY pos ASC LIMIT " . $inizio . ", " . $fine;
$query = mysql_query($sql, $cn);
$quanti = mysql_num_rows($query);
if ($quanti == 0)
{
echo "Nessun record!";
}
else
{
for($x=0; $x<$quanti; $x++)
{
$rs = mysql_fetch_row($query);
$nome_campo = $rs[0];
?>
|
|
|
|
}
}
?>
if($_POST['s']==""){
$query = mysql_query("SELECT * FROM azz_offerta WHERE pubb='1' ORDER BY id DESC", $cn);
}else{
$query = mysql_query("SELECT * FROM azz_offerta WHERE titolo LIKE '%".$_POST['s']."%'", $cn);
}
$quanti = mysql_num_rows($query);
$intero = $quanti / $fine;
?>
if ($pag == 1)
{
?>

}else{
?>
}
if ($intero > 1 and $pag < $intero)
{
?>

}
?>
|
|