Re: what's wrong with this?

In article <9btgks$fc6$1@toye.p.sourceforge.net>, webmaster@celebritieszones.com ("McShen") wrote: > $start is passed by the url. like > http://mydomain.com/links.ph?start=0; > $end =$start+15; > > $query = "SELECT * FROM refer ORDER BY hits desc LIMIT $start,$end"; > > it didn't work. Please help. Perhaps if you were more specific about what you were expecting to happen and what *actually happened when "it didn't work"...? Meantime note that the 2nd parameter to LIMIT is not an end point but a count of total rows to be shown. So "limit 0,15" translates to "show the first 15 rows" while "limit 15,15" and "limit 30,15" would be the correct way to get the next two groups of 15 rows each. -- CC