InsAniAk.com
About InsAniAk.com
Today a client asked for what seemed to be a relatively trivial task. Their product listings on the site order by price from low to high in pages of 9 at a time. If the price is unknown at the time of entering it into the database, the client can type a 0 into the price box and price appears as £TBC on the site. The site uses a PostgreSQL database. The SQL statement looks as follows: $query = "select * from pianos where visible = '1' order by accessory" . $sort . " asc limit 9 offset " .