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 e: [EMAIL PROTECTED] w: http://www.album.co.nz/ p: 0800 4 ALBUM (0800 425 286) or +64 21 232 3303 a: PO Box 579, Christchurch 8015, New Zealand -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
