Results 1 to 9 of 9

Thread: adding search

  1. #1
    Join Date
    Dec 2002
    Posts
    1,883

    Default

    I get this when I try to add search to comminity_feature in admin

    There's been a problem -- please contact the

    Using 1.10 beta 3

  2. #2
    Join Date
    Jun 2004
    Posts
    1,067

    Default

    Hi,

    Does that email you an error, or does it just die there..

    I am awake again now, i was so tired i programmed for way to many hours yesterday. I am going to start applying patches and see if i can get you guy a cleaner beta.

  3. #3
    Join Date
    Dec 2002
    Posts
    1,883

    Default

    It emaild me this error for community features

    216.221.81.96 -- June 25, 2003, 10:36:04 am -- UPDATE or_listingsFormElements SET field_type = 'checkbox', field_name = 'community_features', field_caption = 'Community Features', default_text = '', field_elements = 'Fitness Center||Golf Course||Pool||Spa/Jacuzzi||Sports Complex||Tennis Courts||Bike Paths||Boating||Courtyard||Playground/Park||Association Fee||Clubhouse||Controlled Access||Public Transportation', rank = '85', required = 'No', location = 'feature2', searchable = '1', search_type = 'Community'
    , search_label = 'Community Features', search_step = '', display_on_browse = 'No' WHERE id = 22



    This this for type

    216.221.81.96 -- June 25, 2003, 10:38:01 am -- UPDATE or_listingsFormElements SET field_type = 'select', field_name = 'type', field_caption = 'Type', default_text = '', field_elements = 'Home||Land||Farms||Commercial||Rental', rank = '15', required = 'No', location = 'top_right', searchable = '1', search_type = 'optionlist', search_label = 'Type', search_step = '', display_on_browse = '' WHERE id = 14

    and this for price (range 1000 minmax++)

    216.221.81.96 -- June 25, 2003, 10:39:28 am -- UPDATE or_listingsFormElements SET field_type = 'price', field_name = 'price', field_caption = 'Price', default_text = '', field_elements = '', rank = '9', required = 'No', location = 'top_left', searchable = '1', search_type = 'minmax', search_label = 'Price', search_step = '1000', display_on_browse = '' WHERE id = 18


    Does it help to know that all the Search Label fields come up with a default 0 in admin edit Listing Template ???


    I hope this helps

    I was just about to launch this site
    http://www.canadarealty.ca

    (July first). I paid to get a Amember plugin written for open-realty. sould let the guy stop and wait for this realease. If yes, How long before it will be released. (you think)

  4. #4
    Join Date
    Dec 2002
    Posts
    1,883

    Default

    The errpr was because I changed the prefix from default_ to or_
    so i guess that can help ypu to figure out what to do.

    I changed my database prefix back to default and now it is working.


    So I there got to be a way for this to work if someone changes the prefix.

  5. #5
    Join Date
    Dec 2002
    Posts
    1,883

    Default

    Now that that is gone, it is saying this



    Fatal error: Call to undefined function: searchbox_community() in /home/canreal/public_html/test/listingsearch.php on line 30


    when I try yo search..

    Sorry for all this bug report but I would like to see this thin up and running.

  6. #6
    Join Date
    Jun 2004
    Posts
    1,067

    Default

    Did you use the configurator to build the database or did you load from the sql file? THe sql file is goign to use default_ as the table prefix if you want to change that just search and replace all occurances of default_ with or_ in the sql file before loading it..

  7. #7
    Join Date
    Dec 2002
    Posts
    1,883

    Default

    Quote Originally Posted by greengiant
    Did you use the configurator to build the database or did you load from the sql file? THe sql file is goign to use default_ as the table prefix if you want to change that just search and replace all occurances of default_ with or_ in the sql file before loading it..
    configurator not working so I use sql file...

  8. #8
    Join Date
    Jun 2004
    Posts
    1,067

    Default

    I am going to try and figure out what is wrong with the confiugrator in a few minutes.. Can you test this new open-realty.sql file...

    Code:
    -- MySQL dump 8.22
    --
    -- Host: localhost    Database: openrealtyprefix
    ---------------------------------------------------------
    -- Server version	3.23.56
    
    --
    -- Table structure for table 'default_UserDB'
    --
    
    CREATE TABLE `default_UserDB` (
      `ID` int(11) NOT NULL auto_increment,
      `user_name` varchar(80) NOT NULL default '',
      `emailAddress` varchar(80) NOT NULL default '',
      `Comments` text NOT NULL,
      `user_password` varchar(50) NOT NULL default '',
      `isAdmin` char(3) NOT NULL default 'No',
      `canEditForms` char(3) NOT NULL default 'No',
      `creation_date` date NOT NULL default '0000-00-00',
      `canFeatureListings` char(3) NOT NULL default 'No',
      `canViewLogs` char(3) NOT NULL default 'No',
      `last_modified` timestamp(14) NOT NULL,
      `hitcount` int(11) NOT NULL default '0',
      `canModerate` char(3) NOT NULL default 'no',
      `active` char(3) NOT NULL default 'no',
      `isAgent` char(3) NOT NULL default 'no',
      PRIMARY KEY  (`ID`),
      UNIQUE KEY `ID` (`ID`,`user_name`),
      KEY `ID_2` (`ID`)
    ) TYPE=MyISAM;
    
    --
    -- Dumping data for table 'default_UserDB'
    --
    
    
    INSERT INTO `default_UserDB` VALUES (1,'admin','ryan@open-realty.org','','5f4dcc3b5aa765d61d8327deb882cf99','yes','yes','2002-07-01','yes','yes',20020701223850,1,'yes','yes','yes');
    
    --
    -- Table structure for table 'default_UserDBElements'
    --
    
    CREATE TABLE `default_UserDBElements` (
      `ID` int(11) NOT NULL auto_increment,
      `field_name` varchar(80) NOT NULL default '',
      `field_value` text NOT NULL,
      `user_id` int(11) NOT NULL default '0',
      PRIMARY KEY  (`ID`),
      UNIQUE KEY `ID` (`ID`)
    ) TYPE=MyISAM;
    
    --
    -- Dumping data for table 'default_UserDBElements'
    --
    
    
    INSERT INTO `default_UserDBElements` VALUES (1,'edit_user_name','admin',1);
    INSERT INTO `default_UserDBElements` VALUES (2,'phone','215.850.0710',1);
    INSERT INTO `default_UserDBElements` VALUES (3,'mobile','215.850.0710',1);
    INSERT INTO `default_UserDBElements` VALUES (4,'fax','702.995.6591',1);
    INSERT INTO `default_UserDBElements` VALUES (5,'homepage','http://jonroig.com',1);
    INSERT INTO `default_UserDBElements` VALUES (6,'info','I am the system administrator!',1);
    
    --
    -- Table structure for table 'default_activityLog'
    --
    
    CREATE TABLE `default_activityLog` (
      `id` int(11) NOT NULL auto_increment,
      `log_date` datetime NOT NULL default '0000-00-00 00:00:00',
      `user` int(11) NOT NULL default '0',
      `action` varchar(150) NOT NULL default '',
      `ip_address` varchar(15) NOT NULL default '',
      KEY `id` (`id`)
    ) TYPE=MyISAM;
    
    --
    -- Dumping data for table 'default_activityLog'
    --
    
    --
    -- Table structure for table 'default_agentFormElements'
    --
    
    CREATE TABLE `default_agentFormElements` (
      `ID` int(11) NOT NULL auto_increment,
      `field_type` varchar(20) NOT NULL default '',
      `field_name` varchar(20) NOT NULL default '',
      `field_caption` varchar(80) NOT NULL default '',
      `default_text` text NOT NULL,
      `field_elements` text NOT NULL,
      `rank` int(11) NOT NULL default '0',
      `required` char(3) NOT NULL default '',
      PRIMARY KEY  (`ID`)
    ) TYPE=MyISAM;
    
    --
    -- Dumping data for table 'default_agentFormElements'
    --
    
    
    INSERT INTO `default_agentFormElements` VALUES (3,'textarea','info','Info','','',10,'No');
    INSERT INTO `default_agentFormElements` VALUES (4,'text','phone','Phone','','',1,'No');
    INSERT INTO `default_agentFormElements` VALUES (5,'text','mobile','Mobile','','',3,'No');
    INSERT INTO `default_agentFormElements` VALUES (6,'text','fax','Fax','','',5,'No');
    INSERT INTO `default_agentFormElements` VALUES (7,'url','homepage','Homepage','','',7,'No');
    
    --
    -- Table structure for table 'default_listingsDB'
    --
    
    CREATE TABLE `default_listingsDB` (
      `ID` int(11) NOT NULL auto_increment,
      `user_ID` int(11) NOT NULL default '0',
      `Title` varchar(80) NOT NULL default '',
      `expiration` date NOT NULL default '0000-00-00',
      `notes` text NOT NULL,
      `creation_date` date NOT NULL default '0000-00-00',
      `last_modified` timestamp(14) NOT NULL,
      `hitcount` int(11) NOT NULL default '0',
      `featured` char(3) NOT NULL default 'no',
      `active` char(3) NOT NULL default 'yes',
      PRIMARY KEY  (`ID`),
      UNIQUE KEY `ID` (`ID`),
      KEY `ID_2` (`ID`)
    ) TYPE=MyISAM;
    
    --
    -- Dumping data for table 'default_listingsDB'
    --
    
    
    INSERT INTO `default_listingsDB` VALUES (1,1,'Example Listing','2003-07-01','This is an example listing!','2002-07-01',20030624232253,26,'yes','yes');
    
    --
    -- Table structure for table 'default_listingsDBElements'
    --
    
    CREATE TABLE `default_listingsDBElements` (
      `ID` int(11) NOT NULL auto_increment,
      `field_name` varchar(20) NOT NULL default '',
      `field_value` text NOT NULL,
      `listing_id` int(11) NOT NULL default '0',
      `user_id` int(11) NOT NULL default '0',
      PRIMARY KEY  (`ID`),
      UNIQUE KEY `ID` (`ID`)
    ) TYPE=MyISAM;
    
    --
    -- Dumping data for table 'default_listingsDBElements'
    --
    
    
    INSERT INTO `default_listingsDBElements` VALUES (983,'community_features','Golf Course||Pool||Spa/Jacuzzi||Sports Complex||Tennis Courts||Bike Paths||Boating||Courtyard||Playground/Park||Association Fee||Clubhouse||Controlled Access||Public Transportation',1,1);
    INSERT INTO `default_listingsDBElements` VALUES (980,'status','Active',1,1);
    INSERT INTO `default_listingsDBElements` VALUES (981,'mls','13013',1,1);
    INSERT INTO `default_listingsDBElements` VALUES (982,'home_features','Balcony||Patio/Deck||Waterfront||Dishwasher||Disposal||Gas Range||Microwave||Washer/Dryer||Carpeted Floors||Hardwood Floors||Air Conditioning||Alarm||Cable/Satellite TV||Fireplace||Wheelchair Access ',1,1);
    INSERT INTO `default_listingsDBElements` VALUES (979,'garage_size','40 car',1,1);
    INSERT INTO `default_listingsDBElements` VALUES (978,'prop_tax','0',1,1);
    INSERT INTO `default_listingsDBElements` VALUES (977,'lot_size','20 Acres',1,1);
    INSERT INTO `default_listingsDBElements` VALUES (976,'sq_feet','35,000',1,1);
    INSERT INTO `default_listingsDBElements` VALUES (975,'year_built','1800',1,1);
    INSERT INTO `default_listingsDBElements` VALUES (974,'floors','6',1,1);
    INSERT INTO `default_listingsDBElements` VALUES (973,'baths','35',1,1);
    INSERT INTO `default_listingsDBElements` VALUES (972,'beds','10',1,1);
    INSERT INTO `default_listingsDBElements` VALUES (971,'type','Home',1,1);
    INSERT INTO `default_listingsDBElements` VALUES (970,'full_desc','Exclusive to this site! For two hundred years, the White House has\r\n\r\n stood as a symbol of the Presidency, the United States government,\r\nand the American people.',1,1);
    INSERT INTO `default_listingsDBElements` VALUES (969,'price','2500400',1,1);
    INSERT INTO `default_listingsDBElements` VALUES (968,'neighborhood','Capitol',1,1);
    INSERT INTO `default_listingsDBElements` VALUES (967,'zip','20500',1,1);
    INSERT INTO `default_listingsDBElements` VALUES (966,'state','District of Columbia',1,1);
    INSERT INTO `default_listingsDBElements` VALUES (965,'city','Washington',1,1);
    INSERT INTO `default_listingsDBElements` VALUES (964,'address','1600 Pennsylvania Avenue',1,1);
    
    --
    -- Table structure for table 'default_listingsFormElements'
    --
    
    CREATE TABLE `default_listingsFormElements` (
      `ID` int(11) NOT NULL auto_increment,
      `field_type` varchar(20) NOT NULL default '',
      `field_name` varchar(20) NOT NULL default '',
      `field_caption` varchar(80) NOT NULL default '',
      `default_text` text NOT NULL,
      `field_elements` text NOT NULL,
      `rank` int(11) NOT NULL default '0',
      `required` char(3) NOT NULL default '',
      `location` varchar(15) NOT NULL default '',
      `display_on_browse` char(3) NOT NULL default 'No',
      `searchable` int(10) unsigned NOT NULL default '0',
      `search_type` varchar(10) default NULL,
      `search_label` varchar(50) default NULL,
      `search_step` int(11) NOT NULL default '0',
      PRIMARY KEY  (`ID`),
      KEY `idx_searchable` (`searchable`)
    ) TYPE=MyISAM;
    
    --
    -- Dumping data for table 'default_listingsFormElements'
    --
    
    
    INSERT INTO `default_listingsFormElements` VALUES (1,'text','city','City','','',2,'Yes','top_left','Yes',0,NULL,NULL,0);
    INSERT INTO `default_listingsFormElements` VALUES (2,'text','address','Address','','',0,'Yes','top_left','Yes',0,NULL,NULL,0);
    INSERT INTO `default_listingsFormElements` VALUES (3,'text','mls','mls','','',33,'No','top_right','',0,NULL,NULL,0);
    INSERT INTO `default_listingsFormElements` VALUES (21,'checkbox','home_features','Home Features','','Balcony||Patio/Deck||Waterfront||Dishwasher||Disposal||Gas Range||Microwave||Washer/Dryer||Carpeted Floors||Hardwood Floors||Air Conditioning||Alarm||Cable/Satellite TV||Fireplace||Wheelchair Access ',80,'No','feature1','No',0,NULL,NULL,0);
    INSERT INTO `default_listingsFormElements` VALUES (5,'number','prop_tax','Annual Property Tax','','',29,'No','top_right','',0,NULL,NULL,0);
    INSERT INTO `default_listingsFormElements` VALUES (6,'select','status','Status','','Active||Pending||Sold',31,'No','top_right','',0,NULL,NULL,0);
    INSERT INTO `default_listingsFormElements` VALUES (7,'text','lot_size','Lot Size','','',27,'No','top_right','',0,NULL,NULL,0);
    INSERT INTO `default_listingsFormElements` VALUES (8,'text','garage_size','Garage Size','','',29,'No','top_right','',0,NULL,NULL,0);
    INSERT INTO `default_listingsFormElements` VALUES (9,'text','year_built','Year Built','','',23,'No','top_left','',0,NULL,NULL,0);
    INSERT INTO `default_listingsFormElements` VALUES (10,'number','sq_feet','Square Feet','','',25,'No','top_right','',0,NULL,NULL,0);
    INSERT INTO `default_listingsFormElements` VALUES (11,'text','baths','Baths','','',19,'No','top_left','',0,NULL,NULL,0);
    INSERT INTO `default_listingsFormElements` VALUES (12,'number','floors','Floors','','',21,'No','top_left','',0,NULL,NULL,0);
    INSERT INTO `default_listingsFormElements` VALUES (13,'text','beds','Beds','','',17,'No','top_left','',0,NULL,NULL,0);
    INSERT INTO `default_listingsFormElements` VALUES (14,'select','type','Type','','Home||Land||Farms||Commercial||Rental',15,'No','top_right','',0,NULL,NULL,0);
    INSERT INTO `default_listingsFormElements` VALUES (16,'textarea','full_desc','Full Description','','',13,'No','center','',0,NULL,NULL,0);
    INSERT INTO `default_listingsFormElements` VALUES (17,'text','neighborhood','Neighborhood','','',7,'No','top_left','',0,NULL,NULL,0);
    INSERT INTO `default_listingsFormElements` VALUES (18,'price','price','Price','','',9,'No','top_left','',1,'minmax','Price',5000);
    INSERT INTO `default_listingsFormElements` VALUES (19,'text','zip','Zip','','',5,'Yes','top_left','Yes',0,NULL,NULL,0);
    INSERT INTO `default_listingsFormElements` VALUES (20,'select','state','State','','Alabama||Alaska||Arizona||Arkansas||California||Colorado||Connecticut||Delaware||District of Columbia||Florida||Georgia||Hawaii||Idaho||Illinois||Indiana||Iowa||Kansas||Kentucky||Louisiana||Maine||Maryland||Massachusetts||Alabama||Alaska||Arizona||Arkansas||California||Colorado||Connecticut||Delaware||District of Columbia||Florida||Georgia||Hawaii||Idaho||Illinois||Indiana||Iowa||Kansas||Kentucky||Louisiana||Maine||Maryland||Massachusetts||Michigan||Minnesota||Mississippi||Missouri||Montana||Nebraska||Nevada||New Hampshire||New Jersey||New Mexico||New York||North Carolina||North Dakota||Ohio||Oklahoma||Oregon||Pennsylvania||Rhode Island||South Carolina||South Dakota||Tennessee||Texas||Utah||Vermont||Virginia||Washington||West Virginia||Wisconsin||Wyoming',4,'Yes','top_left','Yes',0,NULL,NULL,0);
    INSERT INTO `default_listingsFormElements` VALUES (22,'checkbox','community_features','Community Features','','Fitness Center||Golf Course||Pool||Spa/Jacuzzi||Sports Complex||Tennis Courts||Bike Paths||Boating||Courtyard||Playground/Park||Association Fee||Clubhouse||Controlled Access||Public Transportation',85,'No','feature2','No',1,'optionlist','Community Features',0);
    
    --
    -- Table structure for table 'default_listingsImages'
    --
    
    CREATE TABLE `default_listingsImages` (
      `ID` int(11) NOT NULL auto_increment,
      `user_id` int(11) NOT NULL default '0',
      `caption` varchar(255) NOT NULL default '',
      `file_name` varchar(80) NOT NULL default '',
      `thumb_file_name` varchar(80) NOT NULL default '',
      `description` text NOT NULL,
      `listing_id` int(11) NOT NULL default '0',
      `rank` int(11) NOT NULL default '5',
      `active` char(3) NOT NULL default 'yes',
      PRIMARY KEY  (`ID`)
    ) TYPE=MyISAM;
    
    --
    -- Dumping data for table 'default_listingsImages'
    --
    
    
    INSERT INTO `default_listingsImages` VALUES (1,1,'View From the Lawn','1_white-house.jpg','thumb_1_white-house.jpg','This property has six floors, 132 rooms, 35 bathrooms, 147 windows, 412 doors, 12 chimneys, 8 staircases, and 3 elevators.',1,1,'yes');
    INSERT INTO `default_listingsImages` VALUES (2,1,'Vermeil Room','1_vermeil_room.jpg','thumb_1_vermeil_room.jpg','The Vermeil Room, sometimes called the Gold Room, was last refurbished in 1991; it serves as a display room and, for formal occasions, as a ladies sitting room. The soft yellow of the paneled walls complements the collection of vermeil, or gilded silver, bequeathed to the White House in 1956 by Mrs. Margaret Thompson Biddle.',1,5,'yes');
    INSERT INTO `default_listingsImages` VALUES (3,1,'The China Room','1_china_room.jpg','thumb_1_china_room.jpg','The Presidential Collection Room, now the China Room, was designated by Mrs. Woodrow Wilson in 1917 to display the growing collection of White House china. The room was redecorated in 1970, retaining the traditional red color scheme determined by the portrait of Mrs. Calvin Coolidge--painted by Howard Chandler Christy in 1924. President Coolidge, who was scheduled to sit for Christy, was too occupied that day with events concerning the Teapot Dome oil scandal. So the President postponed his appointment, and Mrs. Coolidge posed instead.',1,5,'yes');
    INSERT INTO `default_listingsImages` VALUES (4,1,'State Dining Room','1_dining_room.jpg','thumb_1_dining_room.jpg','The State Dining Room, which now seats as many as 140 guests, was originally much smaller and served at various times as a drawing room, office, and Cabinet Room. Not until the Andrew Jackson administration was it called the State Dining Room, although it had been used for formal dinners by previous Presidents.',1,5,'yes');
    INSERT INTO `default_listingsImages` VALUES (5,1,'The Green Room','1_green_room.jpg','thumb_1_green_room.jpg','Although intended by architect James Hoban to be the Common Dining Room, the Green Room has served many purposes since the White House was first occupied in 1800. The inventory of February 1801 indicates that it was first used as a Lodging Room. Thomas Jefferson, the second occupant of the White House, used it as a dining room with a canvas floor cloth, painted green, foreshadowing the present color scheme. James Madison made it a sitting room since his Cabinet met in the East Room next door, and the Monroes used it as the Card Room with two tables for the whist players among their guests. ',1,5,'yes');
    
    --
    -- Table structure for table 'default_memberFormElements'
    --
    
    CREATE TABLE `default_memberFormElements` (
      `ID` int(11) NOT NULL auto_increment,
      `field_type` varchar(20) NOT NULL default '',
      `field_name` varchar(20) NOT NULL default '',
      `field_caption` varchar(80) NOT NULL default '',
      `default_text` text NOT NULL,
      `field_elements` text NOT NULL,
      `rank` int(11) NOT NULL default '0',
      `required` char(3) NOT NULL default '',
      PRIMARY KEY  (`ID`)
    ) TYPE=MyISAM;
    
    --
    -- Dumping data for table 'default_memberFormElements'
    --
    
    
    INSERT INTO `default_memberFormElements` VALUES (3,'textarea','info','Info','','',10,'No');
    INSERT INTO `default_memberFormElements` VALUES (4,'text','phone','Phone','','',1,'No');
    INSERT INTO `default_memberFormElements` VALUES (5,'text','mobile','Mobile','','',3,'No');
    INSERT INTO `default_memberFormElements` VALUES (6,'text','fax','Fax','','',5,'No');
    INSERT INTO `default_memberFormElements` VALUES (7,'url','homepage','Homepage','','',7,'No');
    
    --
    -- Table structure for table 'default_userFavoriteListings'
    --
    
    CREATE TABLE `default_userFavoriteListings` (
      `ID` int(11) NOT NULL auto_increment,
      `user_ID` int(11) NOT NULL default '0',
      `listing_ID` int(11) NOT NULL default '0',
      PRIMARY KEY  (`ID`)
    ) TYPE=MyISAM;
    
    --
    -- Dumping data for table 'default_userFavoriteListings'
    --
    
    
    
    --
    -- Table structure for table 'default_userFormElements'
    --
    
    CREATE TABLE `default_userFormElements` (
      `ID` int(11) NOT NULL auto_increment,
      `field_type` varchar(20) NOT NULL default '',
      `field_name` varchar(20) NOT NULL default '',
      `field_caption` varchar(80) NOT NULL default '',
      `default_text` text NOT NULL,
      `field_elements` text NOT NULL,
      `rank` int(11) NOT NULL default '0',
      `required` char(3) NOT NULL default '',
      PRIMARY KEY  (`ID`)
    ) TYPE=MyISAM;
    
    --
    -- Dumping data for table 'default_userFormElements'
    --
    
    
    INSERT INTO `default_userFormElements` VALUES (3,'textarea','info','Info','','',10,'No');
    INSERT INTO `default_userFormElements` VALUES (4,'text','phone','Phone','','',1,'No');
    INSERT INTO `default_userFormElements` VALUES (5,'text','mobile','Mobile','','',3,'No');
    INSERT INTO `default_userFormElements` VALUES (6,'text','fax','Fax','','',5,'No');
    INSERT INTO `default_userFormElements` VALUES (7,'url','homepage','Homepage','','',7,'No');
    
    --
    -- Table structure for table 'default_userImages'
    --
    
    CREATE TABLE `default_userImages` (
      `ID` int(11) NOT NULL auto_increment,
      `user_id` int(11) NOT NULL default '0',
      `caption` varchar(255) NOT NULL default '',
      `file_name` varchar(80) NOT NULL default '',
      `thumb_file_name` varchar(80) NOT NULL default '',
      `description` text NOT NULL,
      `rank` int(11) NOT NULL default '5',
      `active` char(3) NOT NULL default 'yes',
      PRIMARY KEY  (`ID`)
    ) TYPE=MyISAM;
    
    --
    -- Dumping data for table 'default_userImages'
    --
    
    
    
    --
    -- Table structure for table 'default_userSavedSearches'
    --
    
    CREATE TABLE `default_userSavedSearches` (
      `ID` int(11) NOT NULL auto_increment,
      `user_ID` int(11) NOT NULL default '0',
      `Title` varchar(255) NOT NULL default '',
      `query_string` longtext NOT NULL,
      `last_viewed` timestamp(14) NOT NULL,
      `new_listings` tinyint(4) NOT NULL default '0',
      PRIMARY KEY  (`ID`)
    ) TYPE=MyISAM;
    
    --
    -- Dumping data for table 'default_userSavedSearches'
    --

  9. #9
    Join Date
    Dec 2002
    Posts
    1,883

    Default

    Thanks but that is the one I have already.

    I will just wait it out.

    The error is gone but when the selection comes up. The search result is blank.

    try it
    http://www.canadarealty.ca/test/listingsearch.php

Similar Threads

  1. Adding an All or Any option in the Select Search
    By krakkhenz in forum HELP (CLOSED)
    Replies: 1
    Last Post: 06-25-2004, 05:18 PM
  2. Hi Everyone - Help with the search feature please
    By Shagnasty in forum General Discussion
    Replies: 2
    Last Post: 11-15-2003, 12:59 AM
  3. Replies: 0
    Last Post: 11-04-2003, 09:19 AM
  4. search listing
    By johnnyrealty in forum HELP (CLOSED)
    Replies: 0
    Last Post: 08-08-2003, 05:30 PM
  5. Additional info in Search listings 'listingsearch.php'
    By Anonymous in forum HELP (CLOSED)
    Replies: 5
    Last Post: 07-15-2003, 02:46 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •