Forum PHP.pl

[SQL] pobierz, plaintext 
SELECT prod_id, prod_catid, prod_price, prod_date, prod_name, prod_description, prod_active, prod_store, 
(SELECT COUNT(*) FROM $db_images WHERE img_for = CONCAT('$for', p.prod_id))
FROM $db_shop_products AS p 
WHERE prod_catid = '$id' 
ORDER BY $qsort $order"
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
-- DROP FUNCTION concat(text, text);
 
CREATE OR REPLACE FUNCTION concat(text, text)
  RETURNS text AS $BODY$
SELECT $1 || $2;
$BODY$
  LANGUAGE 'sql' VOLATILE
  COST 100;
ALTER FUNCTION concat(text, text) OWNER TO postgres;
[SQL] pobierz, plaintext