Restricting length of output

Hi

I am still trying to learn this stuff and I am stumped!

HELPPPP!!!

I am trying to build a search thing where I print results to a webpage but the result from the Mysql database is too long and ruining the look of my page...

Can someone tell me how I restrict the length of the result from $row[Description} to X characters?

Thanks

Jilly
jillybabeAsked:
Who is Participating?
 
a.marshConnect With a Mentor Commented:
Yes you can change the size of it using ALTER and yes it will truncate all data to 50 chars in length.

Ant
0
 
a.marshCommented:
You mean restrict the number of records it pulls out or the length of, say, a text field?

If the first then use LIMIT e.g.

select title from table_name order by title limit 10;

That will list the first 10 records it finds (after sorting the data).

Or you can use:

select title from table_name order by title limit 5, 10;

This will list 10 records starting from the 5th record.

:o)

Ant
0
 
curriCommented:
If you want to restrict the number of characters you print for a field, you can use substr, to get just a piece of a string.

Also, I usually make a table when displaying results. You can set the width of each cell, and your browser will adjust. You may get several lines per row, though.

Orlando
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
a.marshCommented:
Yes, if that is what you mean you can use substr - but that is within PHP - I always prefer to get the database to setup the data as best as possible and there is an equivalent function in MySQL called substring.

If you can clairfy exactly what it is you want we can give you the complete solution.

:o)

Ant
0
 
jillybabeAuthor Commented:
I have given the field too much space char(150) when it only needs 50!

Is it possible to simply change the size of this using ALTER?

Will it simply remove all the extra characters if I do?

Jilly
0
 
jillybabeAuthor Commented:
Thanks a Lot!

That is exactly what I shall do :-)

Jilly
0
 
a.marshCommented:
Check out:

http://www.mysql.com/doc/A/L/ALTER_TABLE.html

for all there is to know about it.

Ant
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.