May 19, 2023 at 7:44 am
Hi!
I'm trying to make something similar to this:
So I spent a while identifying key components and wrapping my head around it until I came up with this:
Then I wrote another script to populate these tables and to add an eeprom, so that I can figure out the sequence of queries needed to come up with something similar to the page above:
From there, I start playing around to see how I could output the desired html. This is what I'm using to get the entries needed for the `manufacturer's filter (list of manufacturers, among those we buy eeproms from):
select name from manufacturer where key in (select manufacturer_key from sub_categories_per_\
manufacturer where sub_category_key=(select key from sub_category where name='Memory'));
Which for sure is nothing close to a pretty query, and I expect many more of these in order to get the entries needed to populate rest of the filters in order to produce the desired html.
So, my question is, can somebody offer advise? i.e: things that needed to be changed in order to do things *correctly*? I don't have too much experience with mysql or sql in general, so I'd really like to hear how projects like this are executed in real life.
Thanks,
May 20, 2023 at 8:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply