teammatt3 — Sun, 27 Nov 2005 15:53:26 +0000

Thanks you guys. I am using Renegade's just because it works without too many modifications. I am guessing I have to do something in MySQL with yours Greg.

Thanks

Greg K — Sun, 27 Nov 2005 04:01:35 +0000

If you are not needing the full description on the page at all (ie. you click a link to go to full details on another page) then I would recommend only retrieiving partial info from the database to begin with.
SELECT id,LEFT(description,100) AS shortdesc FROM tablename'
(see http://dev.mysql.com/doc/refman/4.1/en/string-functions.html)

Then assuming you get the results back into an array called row then you would have row['id'] and row['shortdesc']

This reduces the amount of information being returned from teh DB server back to PHP. If you have most fields over 100 characters, this will reduce your overhead.

-Greg

Renegade — Sun, 27 Nov 2005 00:40:57 +0000

Try something like this:

<?php
if(strlen($_POST['description']) > 100) {
    $text = substr($_POST['description'], 0, 100);
  }
else {
    $text = $_POST['description'];
  }
?>