River Reflection Photography Studio

Error in executing select i.name,sc.name subcategory,i.shortdesc,i.url from tblItems i LEFT JOIN tblItemSubCats s ON i.id=s.iid LEFT JOIN tblSubCats sc ON s.sid = sc.id WHERE i.cid = 2 AND i.rank >= 1 AND i.status = 0 ORDER BY RAND() LIMIT 1 stmt

error:1030 : Got error 28 from storage engine


Advertise your company here

Error in executing SELECT `i`.`id`,`i`.`name` `itemname`,`i`.`desc` `itemdesc`,`i`.`url`,`i`.`e-mail`, `i`.`tel`,`i`.`url`,`i`.`rank`,`i`.`image`,`sc`.`name` subcategory,`sc`.`desc` subcatdesc,`sc`.`urlname` subcaturlname FROM `tblItems` i LEFT JOIN tblItemSubCats s ON i.id=s.iid LEFT JOIN tblSubCats sc ON s.sid = sc.id WHERE (`i`.`status` = 0 OR `i`.`status` = 1) AND `i`.`cid` = 2 AND `i`.`id` = 325 ORDER BY `subcategory`,`i`.`name` LIMIT 1 stmt

error:1030 : Got error 28 from storage engine


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/local/home/httpd/vhtdocs/STNEOTS/towndb/list.php on line 133

No companies listed under "Hotels & Guest Houses"

No local companies or organisations matching this category have been added to the site.

If you would like to advertise on this page please click here.
This site is ranked #1 on Google and receives tens of thousands of visits per month from local residents and people travelling to the town.
Advertising here is a cheap, effective way of promoting your business - plus you help the funding of the site!