Re: [PHP-DB] Using a Left() result in PHP

G'day all, The answer was nice and simple - assign an alias to the select statement - thanks all for the quick responses. Cheers, kim -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Using a Left() result in PHP

Hi Kim, > I want to get the first 64 characters from a database row result and display > only those 64 characters using PHP. The snipped code is here - I've deleted > all the error trapping and comments: > > $result = @mysql_query("select ID, Writer, left(text,64) from Reports where > writer like

[PHP-DB] Using a Left() result in PHP

Hi there I'm just scraping the surface of MySQL and PHP and there's something I can't work out. I want to get the first 64 characters from a database row result and display only those 64 characters using PHP. The snipped code is here - I've deleted all the error trapping and comments: $result