Yes, there must be a simple hardcoded php query for that, I'd like to know what it is...and any other useful php snippets for grabbing things from the database. In fact, if they are that "simple" (and they likely are) then we should turn them into template tags. {show_all_results}, {show_all_results_pclassX}. Great for site maps apart from anything else.

I added {searchresults} and {searchresults_class_#} as available tags to be used within the pages to the SVN.

the code was submitted to the SVN, it is not available until tested and if so included in the next release.
The first code I suggested you would need to put above or below the {content} in your pages template file. like page1_main.php if you wanted it to show in that page.
<?php
require_once($config['basepath'] . '/include/search.inc.php');
$search = new search_page();
$data = $search->search_results();
$display $data;
?>
{content}

I think that will put it just abouve your content. LIke I said I did not test this myself

Hi Al, Great news that this is in the core now! So many possibilities. Is there a way we can grab just "specific" things from the database? I am rubbish at php>mysql interaction. For instance what would the php code to grab just a list of listing titles be (great for site maps)? How about to grab the total number of listings? Total number in each class? Things like that? Very useful for template designers.

If I knew the php I think I could build them as tags too...so we'd be able to do things like:

<h1>Welcome to BigShotLtd! Listing {total_listings_number} widgets right now!</h1>

I also would like to know how to pull specific "simple" items from the control panel setup. So I can do:

<p>Showing listings on the map within {config_listing_map_distance} of this property</p>

...for example

Tom you could use functions like this one in the admin to get the total listing count.
<?php
global $config;
require_once($config['basepath'].'/include/admin.inc.php');
$listing = new general_admin();
$total_listings = $listing->listing_count();
$active_listings = $listing->listing_count('yes');
$inactive_listings = $listing->listing_count('no');
$featured_listings = $listing->listing_count('featured');
$expired_listings = $listing->listing_count('expired');
?>
Now you hav a variable $total_listings you could use. Notice also the others.