Re: [Dave] Display Button for more if paid record

Fri, 04 Dec 2009 14:56:00 -0800

Dave that worked perfectly! Makes sense as that filed was added after the listings were created. thanks.

Display Button for more if paid record

Fri, 04 Dec 2009 00:54:05 -0800

I have one more question. There are two types of listing - paid and free. The free listing should not display a button to 'view more' however the paid listing should.

I added a field to the database called 'level' if the box is checked then they have paid. I am using the following code to display the 'More Information' button but not having much luck, could you see if I missed something obvious or am going about this the wrong way - really appreciate your help!

Also, I need to talk to someone to cost out how much it would be to have you guys make the form at http://mormonbusiness.com/submit-a-business.php dynamic so it automatically places the form fields into the database record.

Thanks
Liz

Re: [Damon] Search Display from DropDown

Thu, 03 Dec 2009 20:52:31 -0800

Perfect! I knew that it has to be something simple I could just not see the problem because I had been looking at it too long, how obvious! Thanks, I really appreciate the second set of eyes.

Re: [Damon] Search Display from DropDown

Thu, 03 Dec 2009 19:52:33 -0800

Hi Damon -

I changed the allowSearch to 1 in both places and it still displays all the listings.

I have a feeling that maybe I am not sending the data from the drop down selection to the form to tell it to only display the listings in the category picked.

Liz

Search Display from DropDown

Thu, 03 Dec 2009 16:40:19 -0800

Hi There;

I am having a problem getting this form to display on the records that have been searched. Could you give me some guidance on what I am doing wrong here. The idea is to have a drop down - populated from the database of a list of business categories (working) then the results from the search show on the same page. I have searched other Search Topics and found one that had the same problem which was resolved but it did not show the answer - thanks for any help - Liz

Here is the output page: http://www.mormonbusiness.com/search_page.php

& Here is the code:

require_once "/home/content/m/o/r/mormonbusiness/html/cmsAdmin/lib/viewer_functions.php";

list($business_listingRecords, $business_listingMetaData) = getRecords(array(
'tableName' => 'business_listing',
'perPage' => '12',
'allowSearch' => '0',
));

?>

list($business_categoryRecords,) = getRecords(array(
'tableName' => 'business_listing',
'loadUploads' => '0',
'allowSearch' => '0',
));
?>

Businesses

Re: [Dave] Outputting from a multi select list

Wed, 17 Sep 2008 14:55:16 -0700

Dave, thank you for the solution this worked well:

"Multi value checkboxes store their values in the database as a list separated by tabs. Try this MySQL to match a single value from the list of selected values:

'where' => 'category LIKE "%cottages%" ',

LIKE means "looks like" and % means "anything". So this matches text that starts with anything, then has cottages, then ends with anything."

Liz

Re: [Dave] Outputting from a multi select list

Wed, 10 Sep 2008 22:49:46 -0700

Hi Dave;

Thank you for the help, that only seems to work if the sub_category is a single select radio button, can we have the same results if we use the checkbox (multi value) option. Some of the members want to check more than one option. It sounds like it is probably not an option from your answer but thought I would just clarify.

Thank you
Liz

Re: [Dave] CMS Builder Friendly Web Hosts (Post Yours!)

Tue, 09 Sep 2008 20:51:31 -0700

GoDaddy is another option and for a big company they offer great support 24/7 for those of us who work late into the night and need an answer at 2am. Plus they are the only company I have worked with that have phoned me when my domains were coming due to see if I wanted to renew.

Liz
maia-consulting.com

Re: [webfoot] multiple choices in section editor

Tue, 09 Sep 2008 20:38:15 -0700

Hi Webfoot;

I was just checking back to see if I had a reply to my message and saw your request. I think I can help you out.

The way to set this up is to enter in your 'Field Label' to the name you want to use - like Category or similar, and then choose the Field Type "List". The Field Name will automatically appear, then click on 'Quick Add'.

Find your new entry and then click on modify.

In modify select Radio Buttons under "Display As"
Leave the List Options to the default "Use options listed below"
Edit the list in the entry box to the things you want in your list by adding each item on a new line.

Hope that helps and is what you were looking for,
Liz

Outputting from a multi select list

Tue, 09 Sep 2008 18:21:03 -0700

Hi Dave, Donna & all;

Thanks for all your great help, I have learned a lot from the forums however, I have searched the forums but was not able to find anything to help with this question.

I am trying to work on getting two lists to output content to a site. The first list - the user can only select one option so I have that one figured out, but the second list they can choose more than one option - can you help me edit the code so that the data is output depending on what checkboxes they have checked.

Here is the code I have so far

  list($members_listingRecords, $members_listingMetaData) = getRecords(array(
    'tableName'   => 'members_listing',
	'orderBy'     => 'company_name',
	'where' 	  => 'category = "lodging"',
	'where' 	  => 'sub_category = "cottages"',
  ));

The first 'where' works well because they can only select one item, but the second 'where' for the sub-category does not display the members listings and I think it is because that is a multi select list and not a single check-box. Is there a way for this to work so they can select multiple sub-categories - like cottages & hotel and then show the same listing both on the Hotel page and the Cottages page?

Thank you for your help, Liz

Re: [Dave] Creating Search Results from a drop down list

Fri, 02 May 2008 10:23:04 -0700

Dave, thanks that worked great, now we only have one city showing. I still have dealers showing up when they do not carry the product, so will email you directly for that,

Thank You
Liz

Re: [Dave] Creating Search Results from a drop down list

Wed, 30 Apr 2008 17:53:13 -0700

I have one Section called Dealers and that has the fields for name, city, state etc and then we used check lists for the products. Each product has 'product_code' or 'no' as the option. If they carry the product then the product_code is selected if not then they leave it blank or check 'no' - checking or un-checking 'no' does not seem to make a difference.

I really appreciate your help, it is giving me sleepless nights :)

Re: [Dave] Creating Search Results from a drop down list

Wed, 30 Apr 2008 00:49:47 -0700

Hi Dave;

If I understand your message, I think am trying to work it from a different angle. I have a list of products that when one is selected, shows the list of cities, the city when clicked, shows a list of dealers in that city. But I have some problems with the search results.

I have a page where you can search for a product from a drop down list http://www.therichlawncompany.com/?page_id=72

Problems I am having:
1. The results page shows the city name multiple times, not sure how to fix that. Here is the code:

    Dealers City List Viewer

2. Then the cities are actually displaying all the records for that city, not just the ones that have the product that was selected. So I need to edit the code so that only the cities with that product show.

I opened a support ticket back in early March to help with this, I think it was Jake that was helping me, but can not find the emails from him, so not quite sure.

Thanks for any help, I thought we had it working but the client entered the data and that is when I realized there was a problem.
Liz

Re: [Liz1001] Creating Search Results from a drop down list

Mon, 31 Mar 2008 12:40:14 -0700

Dave - sorry I did not really answer your questions:

Have you created any sections editors or html mockups for the website pages yet or are you just getting started?

Yes, the sections are created.

So the site will have sections for: products, cities, and clients?

I just need to output cities that stock a certain product then display the clients in that city.

Is there a max limit on the number cities a product or client will be in?

There are a max # of products, but infinite cities.
Likewise there are more than one clients in a city

Re: [Dave] Creating Search Results from a drop down list

Mon, 31 Mar 2008 12:29:58 -0700

Hi Dave - thanks for helping me out, I figured out some of the things like creating a form with a pull down list that sends the product chosen to a second page. http://www.therichlawncompany.com/?page_id=51

Where I am having a problem is only listing on the second page the actual cities that have that product chosen.

Then I am not sure how to make it so that when you click on the city it shows a page with all the dealers. I have contacted the consulting team for help and will be happy to work with them (and pay for time) to resolve this as it is pretty specific to my situation so not sure if the forum is the right place?

Oh and to add more fun to the situation the whole thing is integrated into WordPress. :)

Creating Search Results from a drop down list

Sat, 29 Mar 2008 19:36:12 -0700

Hi There;
I have read all the info on searching and other posts on using search, but am still having problem understanding what I need to do. I have created a search page that has a drop down list of products. I want to be able to make it so that when someone selects one of the items from the drop down list it will output all the cities that carry that product. Then on the results page, I want the cities to be hyper linked to a page that display all the clients in that city.

Sorry, I am still pretty new at php and feel like I know enough only to get me into trouble, I am sure this is possible. Thanks for any help