1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| $sql3 = 'SELECT * FROM astuce WHERE astuce_id='.$_GET['ast'].'';
$req3 = mysql_query($sql3) or die('Erreur SQL !<br>'.$sql3.'<br>'.mysql_error());
$nb = mysql_num_rows($req3);
while($astuce = mysql_fetch_assoc($req3))
{
$titre_accens = strtr($astuce['astuce_titre'], "/%?'ÀÁÂÃÄÅàáâãäåÒÓÔÕÖØòóôõöøÈÉÊËèéêëÇçÌÍÎÏìíîïÙÚÛÜùúûüÿÑñ .,;", "-00-AAAAAAaaaaaaOOOOOOooooooEEEEeeeeCcIIIIiiiiUUUUuuuuyNn----");
}
header('Location: http://www.teeshotweb.com/astuces/astuce-'.$titre_accens.'-'.$_GET['ast'].'.html');
$sql1 = 'SELECT * FROM astuce WHERE astuce_id='.$_GET['ast'].'';
$req1 = mysql_query($sql1) or die('Erreur SQL !<br>'.$sql1.'<br>'.mysql_error());
while($vue = mysql_fetch_assoc($req1))
{
$clic = $vue['astuce_vue'] + 1;
}
$sql = 'UPDATE astuce SET astuce_vue = '.$clic.' WHERE astuce_id = '.$_GET[ast].'';
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
mysql_close(); |
Partager