Webmastersite.net
Register Log In

search isn't exact
another issue with searching

Comments on search isn't exact

david
Forum Regular

Usergroup: Customer
Joined: Jun 22, 2005

Total Topics: 91
Total Comments: 305
david
Posted Mar 20, 2006 - 3:18 PM:

Hey Paul,

Another problem with searching. Consider this simple search:

<form action="search.php?action=filter&filled=1&whichtype=links&condition=and" method="post" >

-------------------
<input type="hidden" name="kiadoeladocondition" value="and" />
<select name="kiadoeladosearch">
<option value="For Rent">For Rent</option>
<option value="For Sale">For Sale</option>
</select>

<input type="hidden" name="incatcondition" value="and" />
<select name="incatsearch">
<option value="">In all categories</option>
{ CATOPTIONS }
</select>

-------------------

If I do a search where I select 'For Rent' and leave the categories at 'in all categories', then it returns all the result for all 'For Rent' listings. This is fine.

If I do a search where I select 'For Rent' and select a category where I KNOW there aren't any links listed, it STILL returns the same values as in the previous search. As if it did an 'or' type search.

I tried to even use a '=' type search, but I get the same problem.

Thanks
David
mrowton
Forum Regular

Usergroup: Customer
Joined: Feb 19, 2004
Location: Michigan

Total Topics: 57
Total Comments: 185
mrowton
Posted Mar 20, 2006 - 4:30 PM:

Does this work?

<input type="hidden" name="kiadoeladocondition" value="and" /> 
<select name="kiadoeladosearch">
<option value="For Rent">For Rent</option>
<option value="For Sale">For Sale</option>
</select>
<select name="incat">
<option value="">All Categories</option>
{CATOPTIONS}
</select>


david
Forum Regular

Usergroup: Customer
Joined: Jun 22, 2005

Total Topics: 91
Total Comments: 305
david
Posted Mar 21, 2006 - 1:12 AM:

Hey mrowton,

Thanks for the input, but this didn't work either. Now it simply doesn't search the categories for some reason.

David
david
Forum Regular

Usergroup: Customer
Joined: Jun 22, 2005

Total Topics: 91
Total Comments: 305
david
Posted Mar 21, 2006 - 1:26 AM:

I just don't get it. I tried to change the default search type to 'all the words' and then manually using '=' in the form action as well. I even tried a combination of those, with changing the conditions of the search fields (kiadoeladocondition,incatcondition) to '=' and 'and' but still bringing up results, where the actual link doesn't match the catid.

David
david
Forum Regular

Usergroup: Customer
Joined: Jun 22, 2005

Total Topics: 91
Total Comments: 305
david
Posted Mar 21, 2006 - 1:30 AM:

Here is a search. I don't see where it would restrict the results to CATID 12 (for example, in this search):



Performing query: SELECT id FROM wsnlinks_categories WHERE validated=1 AND hide=0 AND isalbum=0 ORDER BY id DESC LIMIT 0,1;

Performing query: SELECT name,value FROM wsnlinks_switches WHERE id>0 ;

Number of rows is 57 for Resource id #38

Performing query: SELECT id,title,caneditown,caneditall,canvote,isadmin,canpost,canemail,validatecats,validatecomments,validatelinks,validateedits,cansubmitlinks,cansubmitcategories,cansubmitcomments,caneditownlinks,caneditowncategories,caneditowncomments,caneditownprofile,caneditalllinks,caneditallcategories,caneditallcomments,caneditallprofiles,candownloadfiles,canupload,canviewip,limitlinks,canemailmembers,canusehtml,limitlinksdaily,canalias,cancopy,candeleteown,candeleteall,candofulledit,candeletecategories,candeletecomments,candeleteowncategories,candeleteowncomments,candeletemembers,candeleteownmembers,canaliascategories,canviewpages,caneditvotes,numaliases,canviewvotes,canhideownlinks,canhideowncategories,canhideowncomments,canhidealllinks,canhideallcategories,canhideallcomments,canratecomments,bytespermem,canpm,canim,canharddelete,limitpms,limitpmsdaily,canviewdeleted,cansubmitpolls,candeletepolls,candeleteownpolls,caneditpolls,caneditownpolls,attachperpost,attachperpm,canviewshouts,caneditshouts,caneditownshouts,candeleteshouts,candeleteownshouts,cansubmitshouts,canpollvote,customtitle,canviewinvisible,namestyle,canpmimportant,canviewmodlog,isleader,cansubmitquotes,validatequotes,candeletequotes,candeleteownquotes,canreport,canusesearch,attachperlink,validateattachments,caneditownquotes,caneditallquotes,canviewchat,caneditownevents,caneditallevents,candeleteownevents,candeleteevents,cansubmitevents,validateevents,bulkpms,issupermod FROM wsnlinks_membergroups WHERE id>0 ;

Performing query: SELECT id,name,links,comments,time,usergroup,password,ip,totalhits,totalhitsin,email,validated,template,language,lastattempt,allowemail,signature,avatarname,stylesheet,allowuseremail,albumid,failedattempts,totalbytes,funds,notifyoflinks,lastvisit,timezone,rating,pmfolders,notifyofpms,acceptpms,cookieduration,banned,location,homepage,occupation,bio,aim,icq,msn,yahoo,inactive,timeonline,totalpms,buddies,ignored,isonline,acceptims,adminpermissions,referrer,groupreverttime,grouprevertto,moderationpm,secondarygroups,linksperpage,commentsperpage,shouts,customtitle,shoutban,topicbans,forumbans,visibility,birthdate,lastsession,interests,posteditor,forumaccess,pmpopup,pmnotify,modnotes,guestnotes,salt,lastmodnote,newpms,imflag,orderalbums,lastguestnote,autosubscribe,notifymethod,showavatars,showsigs,warninglevel,topics,posts,chatcolor,publicname,publiccompany,publicphone,publicaddress,publicemail,privatename,privatecompany,privateaddress,privatephone,publicdescription FROM wsnlinks_members WHERE id=1 AND validated=1 ;

Performing query: SELECT id,name,parent,validated,description,time,parentnames,parentids,numlinks,hide,lastlinktime,custom,lastedit,moderators,headerinfo,related,numsub,type,permissions,subscribers,subscriber,mixtypes,isalbum,orderlinks,totalcomments,ulsearchmax,ulsearchquery,ulsearchadult,alias,catcols,linkcols,dmozpath,sponsorlinks,views,customwrap,deleted,reqlinks,reqcoms,reqlinksdelay,priority,levelsdeep,lastposterid,lastpostername,lastcommenttime,lastthreadid,lastthreadtitle,linkshere,unvalidatedlinks,unvalidatedcomments,actaslink,countposts,subcatshtml FROM wsnlinks_categories WHERE validated=1 AND deleted=0 AND hide=0 ;

Number of rows is 24 for Resource id #48

Performing query: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE;

Performing query: SELECT id,`to`,subject,message,headers,replacement,mime FROM wsnlinks_email WHERE timesent=0 ORDER BY id ASC LIMIT 0,10;

Number of rows is 0 for Resource id #49

Performing query: UNLOCK TABLES;

Performing query: SELECT id,title,url,description,rating,votes,validated,catid,sumofvotes,email,time,hits,numcomments,hide,ownerid,voterips,voterids,lastedit,type,notify,suspect,pendingedit,funds,suspended,alias,expire,ip,inalbum,typeorder,recipurl,hitsin,recipwith,hitsinips,hitsoutips,lastcomment,related,inhidden,viewers,threadviewers,hitsintemp,hitsouttemp,origtype,importance,parentids,timesdead,timesemailed,threadclosed,threadposters,lastposterid,lastpostername,ownername,deleted,deletionreason,movedto,deletedby,timevalidated,filefield,message,sticky,downloads,pollid,posticon,savedby,kiadoelado,helyseg,varos,ar,epitoanyag,alapterulet,kertmeret,epiteseve,szobaszam,felszobaszam,erkely,franciaerkely,futes,fekves,tajolas,komfort,lift,emeleten,parkolas,parkolasautok,lakasallapot,epuletallapot,extrak,butorozott,terkep,galeria,dirtitle,emeletek,milyenar,ownernamefromid FROM wsnlinks_links WHERE (validated=1 AND hide=0 AND inhidden=0 AND deleted=0 AND alias=0 AND inalbum=0) AND (((kiadoelado LIKE '%Eladó%'))) ORDER BY ar ASC LIMIT 0,45;

Performing query: SELECT COUNT(id) FROM wsnlinks_links WHERE (validated=1 AND hide=0 AND inhidden=0 AND deleted=0 AND alias=0 AND inalbum=0) AND (((kiadoelado LIKE '%Eladó%'))) ;

Number of rows is 2 for Resource id #54

Performing query: SELECT id,type,objectid,filename,filetitle,filesize,width,height,memberid,time,deleted,field,downloads,validated FROM wsnlinks_attachments WHERE type='link' AND objectid=10 ORDER BY time ASC LIMIT 0,1;

Number of rows is 1 for Resource id #56

Performing query: SELECT id,type,objectid,filename,filetitle,filesize,width,height,memberid,time,deleted,field,downloads,validated FROM wsnlinks_attachments WHERE type='link' AND objectid=12 ORDER BY time ASC LIMIT 0,1;

Number of rows is 1 for Resource id #57
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Mar 21, 2006 - 7:33 PM:

Using what's already there when you switch 'search in categories' on, when I search for something in a different category than the one I'm in, it doesn't show up in the search. Give me a way to reproduce. And use the code tags to avoid messing up threads.

Unless perhaps you mean you want to restrict to the category itself excluding its subcategories. For that you'd use catid instead of incat I think. Can't find it in the manual.

{ CATOPTIONS }

What's with the odd spacing?
david
Forum Regular

Usergroup: Customer
Joined: Jun 22, 2005

Total Topics: 91
Total Comments: 305
david
Posted Mar 22, 2006 - 7:08 AM:

That was it.

if I search incat, then it brings up results from all categoried, but if I use catid, then it restricts it to that id.

Thanks
David
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



This thread is closed, so you cannot post a reply.