note 31439 added to function.substr

i'm trying to get the first and last word of a field... so for the first word i did, $sql = "select SUBSTRING_INDEX(field, ' ', n) FROM tablename" ; $first = query($sql); and for the last one $sql = "select SUBSTRING_INDEX(field, ' ', -n) FROM tablename"; $last = query($sql); so far so good... but when i try to print the values of $first and $last like print($first[0]); all i get is "Array" :p any idea? -- http://www.php.net/manual/en/function.substr.php http://master.php.net/manage/user-notes.php?action=edit+31439 http://master.php.net/manage/user-notes.php?action=delete+31439 http://master.php.net/manage/user-notes.php?action=reject+31439