I need to query the Magento MySQL database to get an image path/name for a file.
What I have:
- Order ID
- Order Number
What I need:
- I need to get the image name/path from this table
From what I can see so far following the foreign keys that lead to this table. I seem none of them use the order ID or order number as they all descend from the
sales_flat_quote table instead of the
Does anyone know of a fancy query I could use to get a value from the
sales_flat_quote_item_option table by using what I have, order ID and number?
If I can simply get the
Quote ID from my Order ID/Number then I can doing a join SQL query using the Quote ID to get my record from the
I have to do this with SQL instead of Magento Models as it will be ran outside of Magento in a separate application.