The error message displayed on running this code 🙂 Parse error: syntax error, unexpected T_VARIABLE in .The indicate line number for which the error is presumed to exist.please can any one help to correct the error in the query.
<?php
//connect to MySQL
$connect = mysql_connect("localhost", "root", "password") or
die ("Hey loser, check your server connection.");
//make sure we’re using the right database
mysql_select_db ("moviesite");
//get our starting point for the query through the URL variable “offset”
$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><br>\n";
}
echo "</table>\n";
echo "<a href='page.php?offset=0'>Page 1</a><br>";
echo "<a href='page.php?offset=1'>Page 2</a><br>";
echo "<a href='page.php?offset=2'>Page 3</a><br>";
?>
