mysql date problem in query.

[sijis]

ok, i've somewhat solved my own problem.
(initially posted: http://www.phpbuilder.com/board/showthread.php?s=&threadid=10220012")
but i have a new problem. i can't get data from the db, i keep getting an error: "Parse error: parse error in /home/www/librarymedia/order/dvd_years.php on line 27
"
There weird thing this query work in phpmyadmin but not in this script. i'm not really sure what could be the problem other than the query might be comparing a string to a number. but that should return 'some' value. no?

$i = 1900;
while($i < date(Y)){
	$next = $i+9;
	$list = mysql_query("SELECT * FROM Items WHERE left(Items.year,4) >= $i AND left(Items.year,4) <= $next ORDER BY year", $dbServerConn);
	echo "<b>$i-$next</b><br>";

// problem below here
while($row = mysql_fetch_row($list){
	echo "$row[1] - title?<br>";
}
echo "<p>.";
$i = $i+10;
}

thanks for any help.

[[deleted]]

Looks like you are missing a closing parentheses here:

while($row = mysql_fetch_row($list){

change to:

while($row = mysql_fetch_row($list)){

[sijis]

hehe...
very simple, right?
well i just spent 40+ minutes figuring that little problem out!

for the life of me, i couldn't remember what a parse error meant.... was it syntax..maybe, but its usually the line before of what the error spits out. but everything looks right.
I could have sworn it was the mysql_query() statement.

ohh well.

thanks.