[Resolved] ORDER BY blah ASC LIMIT...

[stew]

if($_GET["limit"] == null) {
$limit = '0';
} else {
$limit = $_GET["limit"];
}

  $past_live_sql = "SELECT * FROM live WHERE live_date < now() AND live_archive = '1' ORDER BY live_date ASC LIMIT $limit, 30";

hey htere guys ive been having this problem for a while now...
basically the above SQL statment dies at '30' according to mysql_error(). $limit is being set as shown so, the problem isn't ... LIMIT , 30 " its something else. however, when i remove the LIMIT the statment works fine.

any ideas?!?

[pipe_girl]

Is "30" the offset? Meaning you only want 30 results displayed on a page at a time?

Or is $limit the offset?

[pipe_girl]

Can you quote the mySQL error?