Ok, I have a table where one of the fields is ProductType. So for a menu I SELECT DISTINCT ProductType...
But also, I've created the naming scheme so that the ProductType's are also the names of the other tables in the DataBase.
That way I can do:
SELECT ProductClass FROM $ArrayProductType[ProductType]
This, I thought would give my database amazing growth potential. But the SELECT statement doesn't seem to like the $ArrayProductTye[ProductType]
Can I not use variable in the SELECT statement?
Thanks
But also, I've created the naming scheme so that the ProductType's are also the names of the other tables in the DataBase.
That way I can do:
SELECT ProductClass FROM $ArrayProductType[ProductType]
This, I thought would give my database amazing growth potential. But the SELECT statement doesn't seem to like the $ArrayProductTye[ProductType]
Can I not use variable in the SELECT statement?
Thanks