Thread: function
View Single Post
  #1 (permalink)  
Old September 19th, 2007, 10:01 AM
keyvanjan keyvanjan is offline
Friend of Wrox
 
Join Date: May 2005
Location: , , .
Posts: 149
Thanks: 0
Thanked 0 Times in 0 Posts
Default function

hi,
i have a photo name field in my sql database
it stores photo names with extensions like this
test.jpg
test2.gif
how can i split just the photo name from the (.)
i want to add a string to it like test_small or test2_small
i need to split everythig before the dot
please write me the code