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]