LEFT(str,len)
Returns the leftmost len characters from the string str:
mysql> SELECT LEFT('foobarbar', 5);
-> 'fooba'
This function is multi-byte safe.
select left(coursecode,40) from courses
Peter
On Wed, 11 Dec 2002, mike karthauser wrote:
> I am using
>
> <? $result = mysql_query("SELECT * FROM courses",$db);
> printf("<select name=\"coursecode\">\n");
> while ($myrow = mysql_fetch_array($result)) {
>
> $l=$myrow['coursecode'];
> ?><option value="<?=$l;?>"<?=($_POST['coursecode']==$l)?'
> selected="selected"':"";?>><?=$myrow['title'];?></option><?
> }
> printf("</select>\n");
> ?>
>
> to generate a html <option><select>. Unfortunately a few of my course titles
> are really long and this effects the rendering of the <option><select>
> making it ultra wide.
>
> Is there a way i can print only the first 40 characters of the title - even
> though the full title lives in the db still (it is used throughout the
> site)?
>
> cheers
> --
> Mike Karthauser
> Managing Director - Brightstorm Ltd
>
> Email >> mikek@brightstorm.co.uk
> Web >> http://www.brightstorm.co.uk
> Tel >> 0117 9426653 (office)
> 07939 252144 (mobile)
>
> Snailmail >> Unit 8, 14 King Square,
> Bristol BS2 8JJ
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
---------------------------------------------------------------------------
Peter Beckman Internet Guy
beckman@purplecow.com http://www.purplecow.com/
---------------------------------------------------------------------------
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
