If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Query String to isolate all iamges and their url?

I am not much of a SQL person, I can create a database, optimize it, drop and ad tables. But my boss would like me to spit out a list of all the images on our site and the corresponding urls. I am sure this can be done with a query string but I have no idea how.

I am searching for all the images within a given section "products" and their URLs to the images in the folder on the ftp. I just need a list. They are in one large database that is controlled by MODX. I have almost all the pages under a products folder, in modx.

I'm not sure there's a way to do it purely in SQL. I might create a PHP script to query the appropriate DB column(s) I don't know MODX, so don't know which table(s)/column(s) have the data), then use PHP's preg_match_all() function to locate the image info.