hi me again, How do I limit the amount of chars i get from a query.

[sybaris]

Hi,

How do I limit the amount of charcters in a query result.

$result = mysql_query("SELECT username,cat,comment,photo,userid,rating,date

the $row[comment] result is sometimes very big and I only want to get the first 100 or so characters.

Thanks very much

syb.

[ronverdonk]

Hi,

How do I limit the amount of charcters in a query result.

$result = mysql_query("SELECT username,cat,comment,photo,userid,rating,date

the $row[comment] result is sometimes very big and I only want to get the first 100 or so characters.

Thanks very much

syb.

$result = mysql_query("SELECT username,cat,SUBSTR(comment,1,100),photo,userid,rating,date

Please note that, contrary to the PHP substr() function, the MySQL substr() function uses 1 as the start of the string.

Ronald :cool:

[sybaris]

Hi,

I used that and it seems to take all of the text away?

Thanks for the help though :)

[sybaris]

Hello again :)

I fixed it using this

$row[comment] = substr("$row[comment]",0,97);

I had to put the first number to 0 or it got rid of the first letter :) and the comment looked a little odd lol....

One more thing if i may. How would i go about telling it to put

&nbsp;<a href="http://www.thatsshocking.com/photo/data/$row[cat]/thumbs/$bigimage">More</a>

after $row[comment] If the comment was 97 characters long ?

Thanks once again.

syb

[khalidbaloch]

here your are using php substr function to limit the chracter ,and as you can see ronald's reply he ask you you to note
that
contarary to php substr() function mysql substr start position is 1 ,php substr start posistion 0,
so in my opion you should use the mysql substr funtion to bequase it will be faster ,to accomplish that ,so this will help you

$result = mysql_query("SELECT username,cat,SUBSTR(comment,1,100) AS comment,photo,userid,ra  ting,date FROM Tablename");

change i mad is only giving a alias to the row comment ( comment ), and your mysql select statment was also incompete so please change ( string, Tablename ) to what ever the table name is , this can be retrived by using this code $row['comment']

as for as your second question is conserned so if statment would do that

$comment=$row['comment'];
if(strlen($row['comment'])>=97){
$comment.='&nbsp;<a href="http://www.thatsshocking.com/photo/data/$row[cat]/thumbs/$bigimage">More</a>';
}

[sybaris]

Ahh thanks for that, Why would the thing that ronald gave me take all the text away because if i am reading it right it is just doing the same as mine just a little earlier, I am very, very new to this though so i am probably on completely the wrong track :)

(i did feel proud that i managed to get it to do what i wanted though).

So would your thingy be better than mine as i will use yours if it is for the length of comments.

Thanks very much

syb.

[sybaris]

as for as your second question is conserned so if statment would do that

$comment=$row['comment'];
if(strlen($row['comment'])>=97){
$comment.='&nbsp;<a href="http://www.thatsshocking.com/photo/data/$row[cat]/thumbs/$bigimage">More</a>';
}

That bit does not work, it does not parse the variables any more in the url and it still puts the 'more' link on all of the comments even if they have less than 97 characters :(