Does anyone know how to bring in all of a mysql tables' results, only show the first X, (say 10), and then hide the rest using jquery? Basically, as I've already got the jquery, I just need to know how to show only the first X results in one div, then the rest in a seperate div.My aim is to only show the first 10 results, but provide a link at the bottom of the page allowing the user to show all of the results. Was thinking the hyperlink could just re-execute the query but thought it would be easier to show/hide using jquery. Many thanks in advance. SThought I'd add the code I'm using below \[code\]$query = "SELECT * FROM ispress WHERE active = '1' ORDER BY YEAR(date) DESC, MONTH(date) DESC LIMIT 0, 7"; $resultSet = mysql_query($query); if (mysql_num_rows($resultSet)) { $newsArray = array(); while ($newsResult = mysql_fetch_array($resultSet)) { $newDate = $newsResult['date'] ; $timePeriod = date('F Y ',strtotime($newDate)); $bFirstTime = true; if (!isset($newsArray[$timePeriod])) { $newsArray[$timePeriod] = array(); } $newsArray[$timePeriod][] = $newsResult; } foreach ($newsArray as $timePeriod => $newsItems) { echo '<div class="date">' . $timePeriod . '</div>' . PHP_EOL; echo '<ul class="press">' . PHP_EOL; foreach ($newsItems as $item) { if ($bFirstTime) { echo '<li>'; echo '<img src="'.$wwwUrl.'images/news/'.$item['image'].'" width="'.$item['imgWidth'].'" height="'.$item['imgHeight'].'" title="'.$item['title'].'" alt="'.$item['title'].'" /> <h3><a href="'.$wwwUrl.'press-releases/'.$item["id"].'/'.$item["title"].'.php">'.$item["title"].'</a></h3> <p>'.substr($item['descrip'],0,244).'...</p> <p><a href="'.$wwwUrl.'press-releases/'.$item["id"].'/'.$item["title"].'.php">Read more</a></p> '; echo '</li>' . PHP_EOL; $bFirstTime = false; } else { echo '<li>'; echo '<a href="'.$wwwUrl.'press-releases/'.$item["id"].'/'.$item["title"].'.php"><img src="'.$wwwUrl.'images/news/'.$item['image'].'" width="'.$item['tnWidth'].'" height="'.$item['tnHeight'].'" title="'.$item['title'].'" alt="'.$item['title'].'" /></a> <h3><a href="'.$wwwUrl.'press-releases/'.$item["id"].'/'.$item["title"].'.php">'.$item["title"].'</a></h3> <p>'.substr($item['descrip'],0,100).'...</p> <p><a href="'.$wwwUrl.'press-releases/'.$item["id"].'/'.$item["title"].'.php">Read more</a></p> '; echo '<div class="clear"></div>' . PHP_EOL; echo '</li>' . PHP_EOL; } } echo '</ul>' . PHP_EOL; } echo '<p><a href="http://stackoverflow.com/questions/3820947/#" id="slick-toggle">Older posts...</a></p>'. PHP_EOL; echo '<div id="slickbox">This is the box that will be shown and display the rest of the news results. 
</div>'. PHP_EOL; } else { echo 'We currently have no press releases available'; }\[/code\]
</div>'. PHP_EOL; } else { echo 'We currently have no press releases available'; }\[/code\]