OVH : MySQL et droit d'acces

SELECT id,nom,date,DATE_FORMAT(date,'%d-%m-%Y') AS datefr FROM theme WHERE date=(SELECT MAX(date) FROM theme)

SELECT id,nom,DATE_FORMAT(date,'%d-%m-%Y') AS datefr FROM theme WHERE date < (SELECT MAX(date) from theme) ORDER BY date DESC

Erreur SQL !
SELECT id,nom,DATE_FORMAT(date,'%d-%m-%Y') AS datefr FROM theme WHERE date = (select MAX(date) from theme) LIMIT 0,1;
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select MAX(date) from theme) LIMIT 0,1' at line 1

<?php
      //On crée une nouvelle session.
      //Un cookie est créé chez le visiteur.
      session_start();
      
      //On vérifie si on vient de faire le login
      //et le cas échéant on vérifie le mot de passe.
      //Si tout est ok, on crée une variable "acces" dans la session.
      if (isset($_SERVER['PHP_AUTH_USER'])
          and ($_SERVER['PHP_AUTH_USER']=='test')
          and (isset($_SERVER['PHP_AUTH_PW']))
          and ($_SERVER['PHP_AUTH_PW']=='test')){
        
         $_SESSION['acces']='ok';
      }
      
      //On n'est pas authentifié
      //-> on affiche la boîte de login
      elseif (!isset($_SESSION['acces']))  {
        header( 'WWW-Authenticate: Basic realm="Private"' );
        header( 'HTTP/1.0 401 Unauthorized' );
        echo 'Authorization Required.';
        exit;
      }    
      
      //On est déjà authentifié
      //(la variable de session "acces" existe)
      //-> on continue !
?>

$maxdate = "SELECT MAX(date) FROM theme";
$sql = "SELECT id,nom,date,DATE_FORMAT(date,'%d-%m-%Y') AS datefr FROM theme WHERE date=$maxdate";

$select = 'SELECT count(id) FROM theme';
$result = mysql_query($select)  or die ('Erreur : '.mysql_error() );
$row = mysql_fetch_row($result);
$total = $row[0];

$sql = "SELECT id,nom,date,DATE_FORMAT(date,'%d-%m-%Y') AS datefr FROM theme ORDER by date DESC LIMIT 1,$total";

AuthUserFile /home/veterina/www/ht/.htpasswd
AuthGroupFile /dev/null
AuthName "Accès restreint"
AuthType Basic
<Limit GET POST>
require valid-user
</Limit>

test:piJ/lY3yFh362\r