Category

Hi April,

So if I understand correctly, what you want to do is for each dir_categories record returned, if "programtype" is selected, show a drop down with all of the programs that were selected inside that record. Is that right?

If so, you can give this a try:

<?php foreach ($dir_categoriesRecords as $record): ?>

<?php if ($record['programtype']): ?>
<?php $selectedPrograms = array_combine($record['sel_program:values'], $record['sel_program:labels']); ?>

<span class="greentext2">Program Type:</span><br />
<span class="bodytext">
<select name="sel_program">
<option value="">Select a Program Type</option>
<?php foreach ($selectedPrograms as $value => $label): ?>
<option value="<?php echo $value;?>"><?php echo $label ?></option>
<?php endforeach ?>
</select>
</span>
<br /><br />
<?php endif ?>

<?php endforeach ?>

Hope this helps

Thank Jason!

That is exactly what I needed. The only issue now is I need to set the category for it to filter because it is currently showing a dropdown for all categories (I only have 2 set up in this test...day trips and party).

http://www.charlotteparent.com/directories/testdaytrips.php

How can I fix that?

April

I also just found another issue. When you complete a search, it comes back with an undefined index error for miles using geocoder. Also, my meta (Showing <?php echo $dir_listingsMetaData['pageResultsStart'];?> - <?php echo $dir_listingsMetaData['pageResultsEnd'];?> of <?php echo $dir_listingsMetaData['totalRecords'];?>) is not showing the correct results.

As for the undefined index area, I know it is because for the premium area I use the following: <?php foreach ($premium_listRecords as $record): ?> where I use<?php foreach ($dir_listingsRecords as $record): ?> for the regular listings and in the geocoder coding at the top of page. So, I know I have the code correct for regular listings as those work. I just don't know how to include the <?php foreach ($premium_listRecords as $record): ?> into the geocoder coding to not give the mile error under premium listings.

You can see what I am talking about by going to this page: http://www.charlotteparent.com/directories/search/searchdaytrips.php

Then perform the following search: birthday in keyword and use 28203 in zip and search within 25 miles. You can then see both issues above.

thanks!
April

Hi,

It seems to only produce the error on the premium listings section. Are these being retrieved separately? If you are not using the geocoding options to selected those listings, you won't have access tot he _distance field.

Hope this helps

[font "Times New Roman"]1.[/#000000] Yes, those are being pulled separately. One premium section uses the following:

$wherepre = "pre_listing = '1' AND category LIKE '%\tDay Trips\t%'"; if (@$_REQUEST['alpha']) {

$wherepre .= " AND title LIKE '".mysql_escape(@$_REQUEST['alpha'])."%'";

}

list($premium_listRecords, $premium_listMetaData) = getRecords(array(

'tableName' => 'dir_listings',

'where' => $wherepre,

'perPage' => '25',

'orderBy' => 'title',

));

And the regular listings use:

$where = "pre_listing = '0' AND category LIKE '%\tDay Trips\t%'"; if (@$_REQUEST['alpha']) {

$where .= " AND title LIKE '".mysql_escape(@$_REQUEST['alpha'])."%'";

}

list($dir_listingsRecords, $dir_listingsMetaData) = getRecords(array(

'tableName' => 'dir_listings',

'where' => $where,

'perPage' => '25',

'orderBy' => 'title',

));

So, I was wondering if and how I can update the geocoder section to reflect both sections since both sections are pulling from same table so the premium area will not pull a error on miles.

// get records

$addressRecords = array();

if ($myLat && $myLng) {

$maxDist = floatval(@$_REQUEST['maxDistance']);

list($dir_listingsRecords, $dir_listingsMetaData) = getRecords(array(

'tableName' => 'dir_listings',

'addSelectExpr' => geocoder_getSelectExprForDistance($myLat, $myLng, '_distance', $kmOrMiles), // adds '_distance' field to output records

'where' => geocoder_getWhereForDistanceWithin($myLat, $myLng, $maxDist, $kmOrMiles), // optimization: remove results outside of minimum bounding rectangle

'having' => "_distance <= " . $maxDist, // only show results within max distance

'orderBy' => 'ISNULL(_distance), _distance', // sort nearest records first -and- unknown or undefined distances last

));

}

My other issues are:

2. On the search, the program type is filtering correctly but is showing a dropdown for all categories (I only have 2 set up in this test...day trips and party). On this page, should only show program type dropdown (that has arts, dance etc)



3. When you complete a search, my meta (Showing <?php echo $dir_listingsMetaData['pageResultsStart'];?> - <?php echo $dir_listingsMetaData['pageResultsEnd'];?> of <?php echo $dir_listingsMetaData['totalRecords'];?>) is not showing the correct results.

Hi,

1)
You can try this:

list($premium_listRecords, $premium_listMetaData) = getRecords(array(

'tableName' => 'dir_listings',
'addSelectExpr' => geocoder_getSelectExprForDistance($myLat, $myLng, '_distance', $kmOrMiles), // adds '_distance' field to output records
'where' => $wherepre,
'perPage' => '25',
'orderBy' => 'title',

));

To make this work you need to make sure that the variables $myLat, $myLng and $kmOrMiles are defined before you retrieve the records.

2) How are you determining which categories should be displayed?

3) If you put in this line of code:

<?php showme($dir_listingsMetaData);?>

Could you post what is output?

2. I am using the following code to pull in the listings based on the category but wasn't sure how to get this to work for program type in search.

$where = "pre_listing = '0' AND category LIKE '%\tDay Trips\t%'";
if (@$_REQUEST['alpha']) {
$where .= " AND title LIKE '".mysql_escape(@$_REQUEST['alpha'])."%'";
}

list($dir_listingsRecords, $dir_listingsMetaData) = getRecords(array(
'tableName' => 'dir_listings',
'where' => $where,
'perPage' => '25',
'orderBy' => 'title',
));

$wherepre = "pre_listing = '1' AND category LIKE '%\tDay Trips\t%'";
if (@$_REQUEST['alpha']) {
$wherepre .= " AND title LIKE '".mysql_escape(@$_REQUEST['alpha'])."%'";
}
list($premium_listRecords, $premium_listMetaData) = getRecords(array(
'tableName' => 'dir_listings',
'where' => $wherepre,
'perPage' => '25',
'orderBy' => 'title',

));

The category on this specific page is day trips. I know I need to add something so it pulls the program types for just this category but that is where I got stuck. I have attached page again if you need to see all coding.

3. Here is the output:
Array
(
[invalidPageNum] =>
[noRecordsFound] => 1
[page] => 1
[perPage] =>
[fromCache] => 0
[totalPages] => 1
[totalRecords] => 0
[pageResultsStart] => 0
[pageResultsEnd] => 0
[prevPage] =>
[nextPage] =>
[prevPageLink] => /directories/search/searchdaytrips.php?title%2Ccategory%2Caddress%2Ccity%2Cstate%2Czipcode%2Cphone%2Csummary%2Cfees%2Cages%2Cgender%2Cprogram_type%2Ccounty_query=birthday&sel_program=&county=&search=1&fromAddress=28203&maxDistance=2&search_x=54&search_y=7&page=
[nextPageLink] => /directories/search/searchdaytrips.php?title%2Ccategory%2Caddress%2Ccity%2Cstate%2Czipcode%2Cphone%2Csummary%2Cfees%2Cages%2Cgender%2Cprogram_type%2Ccounty_query=birthday&sel_program=&county=&search=1&fromAddress=28203&maxDistance=2&search_x=54&search_y=7&page=
[firstPageLink] => /directories/search/searchdaytrips.php
[lastPageLink] => /directories/search/searchdaytrips.php?title%2Ccategory%2Caddress%2Ccity%2Cstate%2Czipcode%2Cphone%2Csummary%2Cfees%2Cages%2Cgender%2Cprogram_type%2Ccounty_query=birthday&sel_program=&county=&search=1&fromAddress=28203&maxDistance=2&search_x=54&search_y=7&page=1
[_detailPage] => http://www.charlotteparent.com/directories/details.php
[_listPage] => http://www.charlotteparent.com/directories/test.php
)

Thanks!
April

I am still doing something wrong. I still do not have the program types filtered based on category. Can you tell me what code I would use [font "Verdana"]to retrieve the current category record? [/#000000]

[font "Verdana"]Thanks![/#000000]

[font "Verdana"]April[/#000000]