splitting myqsl output

[ckennerdale]

I have a myslq database and am out putting the text contained within the fields into html pages.

What I would like to do with my 'description' field to spilt the information into two columns for neater presentaion.

Obviously the length of the description varies from record to record.

I assume I will have to count words or characters in a string and when the specified amount is reached it outputs to a different column.

Any ideas anyone? Caspar Kennerdale
Senior Media Developer

http://www.thetuckshop.com

http://developer.thetuckshop.com

 

[spookie]

hi,
u can make use of function substr($string,int start position,int length);
eg if u want to make column of 100 charactres
then $column1 = substr($string,0,100);
and column2 = substr($string,100,100) and so on
hope that will help u
spookie

 

[haslo]

Maybe you could use the function strtok($string, " " somehow? For counting words, if you wish to do so...

http://www.zend.com/manual/function.strtok.php

allow thyself to be the spark that lights the fire

http://www.haslo.ch