Webmastersite.net
Register Log In

Search acting weird
doesn't make sense

Comments on Search acting weird

david
Forum Regular

Usergroup: Customer
Joined: Jun 22, 2005

Total Topics: 91
Total Comments: 305
david
Posted Mar 22, 2006 - 1:08 PM:

Hey Paul,

I go the advanced search acting weird. If I do a search where I simply select a field, I get a result. If I select that field, and then enter 2 amounts into a another search field (has a condition of "between"), I get NO results. Doesn't make sense, since I am 100% that I have links in the database that are between the given 2 values.

Here is a printout where it didn't give me any results:

Load time so far: 0.25 seconds.
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

Load time so far: 0.25 seconds.
Performing query: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE;

Load time so far: 0.25 seconds.
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

Load time so far: 0.26 seconds.
Performing query: UNLOCK TABLES;

Load time so far: 0.27 seconds.
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,catnev 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ó%') AND ar between '1 33' AND (milyenar LIKE '%Millió%'))) ORDER BY ar ASC LIMIT 0,45;

Load time so far: 0.27 seconds.
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ó%') AND ar between '1 33' AND (milyenar LIKE '%Millió%'))) ;

Count is 0

Number of rows is 0 for Resource id #54

david
Forum Regular

Usergroup: Customer
Joined: Jun 22, 2005

Total Topics: 91
Total Comments: 305
david
Posted Mar 22, 2006 - 1:09 PM:

Here is a result where I didn't enter the number values:

Load time so far: 0.26 seconds.
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

Load time so far: 0.27 seconds.
Performing query: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE;

Load time so far: 0.27 seconds.
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

Load time so far: 0.27 seconds.
Performing query: UNLOCK TABLES;

Load time so far: 0.28 seconds.
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,catnev 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ó%') AND (milyenar LIKE '%Millió%'))) ORDER BY ar ASC LIMIT 0,45;

Load time so far: 0.29 seconds.
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ó%') AND (milyenar LIKE '%Millió%'))) ;

Count is 2

Number of rows is 2 for Resource id #54

Load time so far: 0.29 seconds.
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

Load time so far: 0.31 seconds.
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 25, 2006 - 10:22 AM:

Try the attached search.php file (for user-side search).

Attached Files:
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



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