List:General Discussion« Previous MessageNext Message »
From:Dotan Cohen Date:October 21 2005 5:00am
Subject:Re: left not working [solved]
View as plain text  
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.

Dotan
http://lyricslist.com/lyrics/artist_albums/155/depeche_mode.php
Depeche Mode Song Lyrics
Thread
Re: left not working [solved]Dotan Cohen21 Oct