RE: [PHP-DB] Limit return Size

[Hutchins, Richard]

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

RE: [PHP-DB] Limit return Size

[Gary . Every]

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


Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
"Pay It Forward"
mailto:[EMAIL PROTECTED]
http://accessingram.com


> -Original Message-
> From: Hutchins, Richard [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 20, 2003 2:46 PM
> To: [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] Limit return Size
> 
> 
> 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
> 

Re: [PHP-DB] Limit return Size

[CPT John W. Holmes]

> 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.

Here is a great thread on Devshed that discusses various PHP and MySQL
methods to accomplish this:

http://forums.devshed.com/showthread.php?s=&threadid=23711&perpage=15&highlight=limit%20text%20from%20database&pagenumber=1

Enjoy.

---John Holmes...


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