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' 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 What is wrong with m syntax? Dotan http://lyricslist.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]