Phoenix SQL Question

[Logic]

Is there a query I can run to make it so all the furniture in page ID 91 (Staff Section) be in bundles of 50? Or do I have to do it individually?

 

[wite]

I have personally always done it individually, so I don't think so
It would be a great idea though.

 

[lose123]

As far as I know it's indiviual. Sorry.

 

[Barbie]

UPDATE catalog_items SET amount = 50 WHERE page_id = 91

If you're using Navicat ofc

 

[JoshuaLuke]

UPDATE catalog_items SET amount = 50 WHERE page_id = 91

If you're using Navicat ofc

Just saying, but it'd work in any MySQL program since its a basic query,

 

[Barbie]

Just saying, but it'd work in any MySQL program since its a basic query,

I've never used PhpMyAdmin so wasn't sure haha. I think catalog_items would be catalogue_items instead though, and not sure if the other things are also called amount or page_id exactly but even if they're not I'm sure it's easy enough to change

 

[JoshuaLuke]

I've never used PhpMyAdmin so wasn't sure haha. I think catalog_items would be catalogue_items instead though, and not sure if the other things are also called amount or page_id exactly but even if they're not I'm sure it's easy enough to change

Yah is catalog, not catalogue for a strange reason...