Re: [PHP-DB] limiting field extraction to 40 characters

2002-12-12 Thread mike karthauser 
If i try the below in my query i get no results.

Ideally i would like to do this (not valid sql)

? $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['left(title,40)'];?/option?
}
printf(/select\n);
?


on 11/12/02 5:26 pm, Peter Beckman at [EMAIL PROTECTED] wrote:

 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



 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 optionselect. Unfortunately a few of my course titles
 are really long and this effects the rendering of the optionselect
 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)?


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] limiting field extraction to 40 characters

2002-12-12 Thread Peter Beckman 
$1 is a bad variable.  You can't have variables that start with a number.

Try $a or $foo or $bar.

On Thu, 12 Dec 2002, mike karthauser wrote:

 If i try the below in my query i get no results.

 Ideally i would like to do this (not valid sql)

 ? $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['left(title,40)'];?/option?
 }
 printf(/select\n);
 ?


 on 11/12/02 5:26 pm, Peter Beckman at [EMAIL PROTECTED] wrote:

  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



  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 optionselect. Unfortunately a few of my course titles
  are really long and this effects the rendering of the optionselect
  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)?


 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php


---
Peter Beckman  Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com/
---

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] limiting field extraction to 40 characters

2002-12-11 Thread mike karthauser 
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 optionselect. Unfortunately a few of my course titles
are really long and this effects the rendering of the optionselect
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[EMAIL PROTECTED]
Web  http://www.brightstorm.co.uk
Tel  0117 9426653 (office)
   07939 252144 (mobile)

SnailmailUnit 8, 14 King Square,
   Bristol BS2 8JJ


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php