Hi,
I think you could use something like
SELECT DISTINCT
(CASE p.ship_status
WHEN '1' THEN shipping_now
WHEN '2' THEN shipping_soon
ELSE 'unknow'
END) as status
FROM products AS p
INNER JOIN cart AS i
ON i.product_id = p.id
WHERE i.session_id = prepSQL(tConn, tSessionID);
If there are
tSql = SELECT DISTINCT(p.ship_status)
FROM products AS p
INNER JOIN cart AS i
ON i.product_id = p.id
WHERE i.session_id = prepSQL(tConn, tSessionID);
p.ship_status is either a 1 or a 0, which is just how the database was
set up ages, ago. I am moving these to