Merci de vos reponses, j'ai fais ainsi comme suis
Message suivant
[PHP]<?php
$req_inf = mysql_query("CREATE TEMPORARY TABLE temp SELECT ID,REF,TITRE FROM $dbblog WHERE REF =0");
$req_inf = mysql_query("SELECT MAX(ID) FROM temp WHERE ID <$id");
$res_inf = mysql_result($req_inf, 0);
$req_inf2 = mysql_query("SELECT TITRE FROM temp WHERE ID =$res_inf");
$res_inf2 = mysql_result($req_inf2, 0);
$req_inf = mysql_query("DROP TABLE temp");[/PHP]
Message précédent
[PHP]<?php
$req_sup = mysql_query("CREATE TEMPORARY TABLE temp SELECT ID,REF,TITRE FROM $dbblog WHERE REF =0");
$req_sup = mysql_query("SELECT MIN(ID) FROM temp WHERE ID >$id");
$res_sup = mysql_result($req_sup, 0);
$req_sup2 = mysql_query("SELECT TITRE FROM temp WHERE ID =$res_sup");
$res_sup2 = mysql_result($req_sup2, 0);
$req_sup = mysql_query("DROP TABLE temp");[/PHP]
Y a surement plus facile mais bon j'apprend doucement
