On 10/21/05, Jasper Bryant-Greene <jasper@stripped> wrote:
> On Fri, 2005-10-21 at 06:34 +0200, Dotan Cohen wrote:
> > Why would this work:
> > SELECT question, short, longa, technical FROM -snip- WHERE filename='$filename'
> > But this not:
> > SELECT question, short, left(longa,40), technical FROM -snip- WHERE
> > filename='$filename'
> If you want it to work like that, you need to do:
> left(longa,40) AS longa
> > The line that looks like this:
> > $long =mysql_result($result, 0, "longa");
> > Is throwing this error:
> > Warning: mysql_result(): longa not found in MySQL result index 4 in
> > *** on line 13
> Jasper Bryant-Greene
> General Manager
> Album Limited
Thank you. That did it.
Depeche Mode Song Lyrics
|• Re: left not working [solved]||Dotan Cohen||21 Oct|