Re: Get First 20 Characters of a Variable or Database Entry

I belive the left() function is mysql is what you are looking for. Dimitri Marshall wrote:

Hi there, How would I go about getting the first 20 characters of a varibale or database entry. The situation is this, I created a calendar where users can post events and on the date instead of just a number (the number of events and the date), I would like to show the first 20-30 characters of the event name. I could do the whole event name but it could get quite long. Thanks, Dimitri Marshall

-- Raditha Dissanayake. ------------------------------------------------------------------------ http://www.radinks.com/sftp/ | http://www.raditha.com/megaupload Lean and mean Secure FTP applet with | Mega Upload - PHP file uploader Graphical User Inteface. Just 150 KB | with progress bar.