For years, I've been using FileMaker Pro to generate a staff photo
gallery and staff phone directory from the same table of staff
information. I'm switching to PHP/MySQL for the year ahead. In STEP 1
below, I concatenate a name for the teacher/staff person image and in
STEP 3 I concatenate an XHTML table cell for the image and name. Steps 1
and 3 have been tested and work fine. I don't know how to accomplish
STEP 2 however. Suppose I start with a last name like De Long or Van
Schmidt? I wind up with de lonxx.jpg or van scxx.jpg for my image names.
I have a superstitious dread of putting spaces in Linux/Unix web file
names. Could someone suggest a way to replace the " " in imgName with
""?
STEP 1: Create the root of the image name
update staff set imgName = Lower(CONCAT(Left(last,6),Left(first,2)));
STEP 2:
How do I delete spaces in the imgName?
STEP 3:
update staff set webLine = CONCAT("<td><img src='images/",imgName,".jpg'
width='100' height='125'><br clear='all' />",first," ",last,"</td>");
Thanks in advance for your time spent in reading or responding.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
