Try:

$sql = "SELECT LEFT(columnName,255) FROM tableName";

Using that syntax should return the first 255 characters from the selected
column, reading LEFT to right. I tested it in the command line and it worked
just fine.

Hope that helps.

Rich

> -----Original Message-----
> From: Marie Osypian [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 20, 2003 3:06 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Limit return Size
> 
> 
> I would like to know how I limit my answer from a mysql 
> database query to
> display only a limited size?  Is this done in the query or the php?
> 
> i.e.  Our Performance Results area includes First Quarter 
> 2003 investment
> returns for virtually every 529 savings programs. See how 
> your 529 plan
> performed...
> 
> This question is alot longer but it was stopped and ... added when it
> reached the desired size.
> 
> Thanks
> 
> MAO
> 
> 
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to