[RESOLVED] LIMIT Problems

[fishy]

I have this query straight from the sql manual and I cannot get it to work.

$query = "Select * From Results Limit $f,$l;";

$f = 645

the number of the auto incremented id key I want it to return

$l =5

the next five entries

when I try to run it it kills my while loop and outputs nothing. I hardcode numbers in it nothing. It really has me stumped.

here is the manual

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

can't seem to get it to output anything.

Thanks for the help!

Tom

[bradgrafelman]

Can you paste us the exact section of code you have this in? Not just the query, but the loop code after that, etc.

Also, is MySQL trying to tell you anything? Standard way to debug a MySQL error in PHP:

$query = 'SELECT * FROM...'; // your query here
$exec = mysql_query($query) or die('MySQL said: ' . mysql_error());

[fishy]

$query = "Select * From Results Order by Event_ID DESC Limit $f,$l";
	    $results = mysql_query($query) or die(mysql_error())                                                         

            while ($te = mysql_fetch_array($results)) { 
	    $time_now=$te['Time'];
	    $time_display = date("F j, Y, g:i a",$time_now);
	    echo"<tr><td>{$te[Event_ID]}</td><td>$time_display</td><td>
             {$te[Opponent]}</td><td>{$te[Notes]}</td><td>{$te[Site]}</td></tr>";
											}

I was entering it directly into my php mysql program without the while loop and getting nothing as well. The while loop is fine when the query returns something.
I can use the limit normally but when I add the second number to try to get it to return from an certain entry I get no results. I am thinking it is not seeing the Event_ID Key that I set as the actual 600 or whatever. Because if I limit to 5 it is cool.

[Roger_Ramjet]

LIMIT does not work on the value of any column, just on the total number of records returned by the query and in the order specified in the query. If you want records from a specific id then you use that id in the where clause.

In this particular case you definitely do NOT have 645 records in the table so you get no results. Rewrite the query to get ids less than or equal to the id, order them DESC and limit to just 5.

[fishy]

In this particular case you definitely do NOT have 645 records in the table so you get no results

I did then I deleted them.Thats why it was returning zero. Thanks Roger.

If you want records from a specific id then you use that id in the where clause.

Duh, there are so many ways to do things that I kinda get blinders on I beat myself up trying to get something to work one way when there always is an obvious other easier way.

Thanks for your help as I stumble through all this stuff.