dachshund Posted May 2, 2009 Share Posted May 2, 2009 hi sorry if this doesn't make much sense, but it's quite hard to describe. is there a way of limiting the amount of text that your php code can input into a table? for example if in the mysql table field there is 150 characters of text, but i only want it to recall a maximum of 80 characters. is there a way of doing this? hope that makes sense, it's quite late and i'm pretty tired. Link to comment https://forums.phpfreaks.com/topic/156602-a-way-of-limiting-the-amount-of-text/ Share on other sites More sharing options...
Ken2k7 Posted May 3, 2009 Share Posted May 3, 2009 $str = 'something...'; $len = 80; if (($str_len = strlen($str)) < $len) $len = $str_len; $str = substr($str, 0, $len); Link to comment https://forums.phpfreaks.com/topic/156602-a-way-of-limiting-the-amount-of-text/#findComment-824577 Share on other sites More sharing options...
dachshund Posted May 3, 2009 Author Share Posted May 3, 2009 what should i put in the place of '...something'? sorry for my ignorance Link to comment https://forums.phpfreaks.com/topic/156602-a-way-of-limiting-the-amount-of-text/#findComment-824584 Share on other sites More sharing options...
Ken2k7 Posted May 3, 2009 Share Posted May 3, 2009 Whatever string you got back from the DB. Link to comment https://forums.phpfreaks.com/topic/156602-a-way-of-limiting-the-amount-of-text/#findComment-824586 Share on other sites More sharing options...
dachshund Posted May 3, 2009 Author Share Posted May 3, 2009 hmm can't get it to work here's parts of my code. <?php $today = date('Y-m-d'); $sql="SELECT * FROM features ORDER BY id DESC"; $result=mysql_query($sql); $str = 'something...'; $len = 80; if (($str_len = strlen($str)) < $len) $len = $str_len; $str = substr($str, 0, $len); ?> and this is the echo i want to limit <? echo $rows['condensedcontent']; ?> Link to comment https://forums.phpfreaks.com/topic/156602-a-way-of-limiting-the-amount-of-text/#findComment-824589 Share on other sites More sharing options...
Ken2k7 Posted May 3, 2009 Share Posted May 3, 2009 Then set $str to that. Think people! I'm sorry life's not easy. Link to comment https://forums.phpfreaks.com/topic/156602-a-way-of-limiting-the-amount-of-text/#findComment-824591 Share on other sites More sharing options...
dachshund Posted May 3, 2009 Author Share Posted May 3, 2009 a little more help...? Link to comment https://forums.phpfreaks.com/topic/156602-a-way-of-limiting-the-amount-of-text/#findComment-824595 Share on other sites More sharing options...
Ken2k7 Posted May 3, 2009 Share Posted May 3, 2009 a little more help...? Sure! Learn PHP. Link to comment https://forums.phpfreaks.com/topic/156602-a-way-of-limiting-the-amount-of-text/#findComment-824596 Share on other sites More sharing options...
dachshund Posted May 3, 2009 Author Share Posted May 3, 2009 if only there was a forum where people could teach me...haha Link to comment https://forums.phpfreaks.com/topic/156602-a-way-of-limiting-the-amount-of-text/#findComment-824598 Share on other sites More sharing options...
Axeia Posted May 3, 2009 Share Posted May 3, 2009 Could let the database do the work. SELECT SUBSTR(id,0,20) from features ORDER BY id DESC (assuming id is the only colum) Link to comment https://forums.phpfreaks.com/topic/156602-a-way-of-limiting-the-amount-of-text/#findComment-824599 Share on other sites More sharing options...
dachshund Posted June 4, 2009 Author Share Posted June 4, 2009 hi, would any one be able to help me out a bit more with this? still can't get it to work. would be much appreciated. Link to comment https://forums.phpfreaks.com/topic/156602-a-way-of-limiting-the-amount-of-text/#findComment-849554 Share on other sites More sharing options...
dachshund Posted June 5, 2009 Author Share Posted June 5, 2009 no? no one? Link to comment https://forums.phpfreaks.com/topic/156602-a-way-of-limiting-the-amount-of-text/#findComment-850272 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.