https://www.webmastersite.net/forums en-us Filename: Default search box on the main category page. I typed 'insurance' into the search box and hit search. https://www.webmastersite.net/forums/threads/database-error-when-performing-searches-5128.html Sat, 21 May 2005 16:52:24 GMT https://www.webmastersite.net/forums/thread/5128/ 0.23 seconds. Performing query: LOCK TABLES wsnlinks_email WRITE, wsnlinks_links WRITE, wsnlinks_categories WRITE, wsnlinks_members WRITE; Load time so far: 0.24 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 #42 Load time so far: 0.24 seconds. Performing query: UNLOCK TABLES; Load time so far: 0.28 seconds. Performing query: SELECT id FROM wsnlinks_links WHERE (validated=1 AND hide=0 AND inhidden=0 AND alias=0 AND inalbum=0) AND ((title LIKE '%insurance%' OR url LIKE '%insurance%' OR description LIKE '%insurance%' OR county LIKE '%insurance%' OR company LIKE '%insurance%' OR city LIKE '%insurance%' OR region LIKE '%insurance%' OR keywords LIKE '%insurance%')) ; Number of rows is 2 for Resource id #47 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,filename,filetitle,notify,suspect,downloads,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,county,company,add1,add2,city,state,zip,region,keywords,submitter,certification,phone FROM wsnlinks_links WHERE (validated=1 AND hide=0 AND inhidden=0 AND alias=0 AND inalbum=0) AND ((title LIKE '%insurance%' OR url LIKE '%insurance%' OR description LIKE '%insurance%' OR county LIKE '%insurance%' OR company LIKE '%insurance%' OR city LIKE '%insurance%' OR region LIKE '%insurance%' OR keywords LIKE '%insurance%')) ORDER BY typeorder ASC,rotating case LIMIT 0,15; n Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.chippy/techdi/bizgeorgia.com/ga/classes/database.php on line 82 Number of rows is for You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'case LIMIT 0,15' at line 1 Load time so far: 0.3 seconds. Performing query: SELECT id FROM wsnlinks_pm WHERE timeread=0 AND time > 0 AND deleted=0 AND toid=1 ; You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'case LIMIT 0,15' at line 1 Number of rows is 0 for Resource id #50 Load time so far: 0.3 seconds. Performing query: SELECT id FROM wsnlinks_pm WHERE deleted=0 AND time > 0 AND toid=1 ; Number of rows is 0 for Resource id #51 ]]> https://www.webmastersite.net/forums/threads/database-error-when-performing-searches-5128.html https://www.webmastersite.net/forums/threads/get-title-description-button-problem-5096.html Wed, 11 May 2005 04:02:44 GMT https://www.webmastersite.net/forums/thread/5096/ http://www.bizgeorgia.com/ga/]]> https://www.webmastersite.net/forums/threads/get-title-description-button-problem-5096.html