On 10/21/05, Jasper Bryant-Greene <[EMAIL PROTECTED]> 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
