David Blomstrom wrote:

> then all I have to do is replace $seg with the path to
> the image folder to display my images. The images
> don't even have to be the same size, since I have to
> enter each state's image individually, anyway.

> Actually, it would be more convenient if I could enter
> image links without the width and height values. I
> suppose that would work if I used them as background
> images.

Actually, if you include the dimensions in your image *names* --
which is a great timesaver -- you can store them as, say

  ak.200x150.gif

and retrieve as

  SELECT
          img
        , SUBSTRING(img,4,3) AS width
        , SUBSTRING(img,8,3) AS height
  FROM
        images
  WHERE
        LEFT(img,2) = 'ak'

You can put that into your own function and write the entire image
tag out with the proper width and height, in one swell foop :-)

FWIW!
--
Hassan Schroeder ----------------------------- [EMAIL PROTECTED]
Webtuitive Design ===  (+1) 408-938-0567   === http://webtuitive.com

                          dream.  code.



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to