Hi

Last 2-3 days I am trying to figure out how I can adjust one line of my code to return only last 50 results and to put the element into table/div with fixed height.

I want first 10 records to be visible on first look,others to be below - simple scroll down.

However I tried with LIMIT 0,50 but something its not okay.This is my base line of code.I guess for someone this is ridiculous question but its bothering me a lot ...

PHP Code:

$buildcontent .= displaylistings ($mintitle, 'WHERE listingstatus=\'Z\' ORDER BY featured DESC, enddate ASC'); 


Also after limitation I cant figure out how I can achieve the effect with scrolldown.Can you give me some quick tips ?

Thanks for attention

Try this for your MySQL limit...

SELECT xxx FROM xxx WHERE xxx LIMIT 50

You can order it in reverse and grab Top 50. (Top clause)