a way of limiting the amount of text

[dachshund]

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.

[Ken2k7]

$str = 'something...';
$len = 80;
if (($str_len = strlen($str)) < $len) $len = $str_len;
$str = substr($str, 0, $len);

[dachshund]

what should i put in the place of '...something'?

 

sorry for my ignorance

[Ken2k7]

Whatever string you got back from the DB.

[dachshund]

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']; ?>

 

 

 

[Ken2k7]

Then set $str to that. Think people! I'm sorry life's not easy.

[dachshund]

a little more help...? 

[Ken2k7]

a little more help...? 

Sure! Learn PHP.

[dachshund]

if only there was a forum where people could teach me...haha

[Axeia]

Could let the database do the work.

SELECT SUBSTR(id,0,20) from features ORDER BY id DESC

 

(assuming id is the only colum)

[dachshund]

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.

[dachshund]

no? no one?