$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 beckman@purplecow.com 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 <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)?
>
>
> --
> 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
