Step 1. Select Type

Step 2. Select Size

Step 3. Select colour

Step 4. Keywords/Code

ITEM
SIZE
COLOUR
QTY
PRICE

An error occurred whilst accessing the database: 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 'ORDER BY rand()' at line 6
An error occurred accessing the database:

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 'ORDER BY rand()' at line 6

...in the following sql statement:

 SELECT p.*,p.orderindex as porderindex,co.id as colourid 
     FROM products p, related_products r, product_colours co 
     WHERE p.hidden=0 AND co.productid=p.id 
     AND p.id=r.childid AND r.parentid=
     
     ORDER BY rand()

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/camille/public_html/classes/listing.class.php on line 81
An error occurred whilst accessing the database: 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 'ORDER BY rand() LIMIT 0,4' at line 6
An error occurred accessing the database:

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 'ORDER BY rand() LIMIT 0,4' at line 6

...in the following sql statement:

 SELECT p.*,p.orderindex as porderindex,co.id as colourid 
     FROM products p, related_products r, product_colours co 
     WHERE p.hidden=0 AND co.productid=p.id 
     AND p.id=r.childid AND r.parentid=
     
     ORDER BY rand()
     
       LIMIT  0,4;

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/camille/public_html/classes/listing.class.php on line 138