errore sintassi mysql per via di offset....

[gabar-el]

ciao, ho questo codice che sto provando che mi torna un errore, che reputo a $offset, come dice appunto l'errore stesso:
codice php:

$offset = $_REQUEST['offset'];
$query = "SELECT movie_name, movie_year
            FROM movie
            ORDER BY movie_name
            LIMIT $offset,1";
$results = mysql_query($query)
    or die(mysql_error());
echo "<table>\n";
while ($rows = mysql_fetch_assoc($results)) {
echo "<tr>\n";
    foreach($rows as $value) {
    echo "<td>\n";
    echo $value;
    echo "</td>\n";
    }
echo "</tr>
\n";
}
echo "</table>\n";
echo "[url='page.php?offset=0']Page 1[/url]
";
echo "[url='page.php?offset=1']Page 2[/url]
";
echo "[url='page.php?offset=2']Page 3[/url]
"; 

errore:

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

linea 4:

LIMIT $offset,1"; 

grazie

[piero.mac]

prova a stampare la query:

echo $query;

[gabar-el]

me la torna così:

SELECT movie_name, movie_year FROM movie ORDER BY movie_name LIMIT ,1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1' at line 4

grazie

[piero.mac]

Originariamente inviato da gabar-el
me la torna così:

SELECT movie_name, movie_year FROM movie ORDER BY movie_name LIMIT ,1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1' at line 4

grazie

$offset e' vuoto.

controlla il valore che trasferisci e in caso di "vuoto" mettici un default oppure segnala l'errore.