Forum d'entraide PHPFrance

$rq = "SELECT DISTINCT discipline FROM Club ORDER BY discipline ASC";
$result = mysql_query($rq)
or die ("pas bon");

echo "<form action='club2.php' method='post'>
<select name='discipline'> \n";
while ($ligne = mysql_fetch_array($result))
{extract ($ligne);
echo "<option value='$discipline'>$discipline \n";
}
echo"</select> \n";
echo "<input type='submit'"."value=\"Envoyer\"></form>\n";

if (isset($_POST['discipline'])) 
{

$reponse = mysql_query('SELECT * FROM Club ORDER BY id ASC LIMIT '  . $discipline . ',')
or die (mysql_error());
while ($donnees = mysql_fetch_array($reponse))
{
    echo '<p>' . $donnees['ville'] . '</p><br />'; 
	echo  '<p>' . $donnees['nomp'] . '</p>' ;
	echo '<p>' . $donnees['texte'] . '</p>';
	
}
}

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 '' at line 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 '' at line 1

echo "La requête générée est : ",$reponse;

je me suis apercus qu'on utilisait LIMIT qu'avec des chiffres je me trompe ???

The LIMIT clause can be used to constrain the number of rows returned by the SELECT statement.
LIMIT takes one or two numeric arguments,
which must both be non-negative integer constants (except when using prepared statements).

With two arguments, the first argument specifies the offset of the first row to return,
and the second specifies the maximum number of rows to return.
The offset of the initial row is 0 (not 1):

//
SELECT * FROM tbl LIMIT 5,10;  //Retrieve rows 6-15