Limited amount of text from record

[save]

How would I be able to only show say 300 characters from the description field when I retrieve records from MySQL?

$query = "SELECT id, name, price, image_url, description FROM `products` ORDER BY rand() LIMIT 4;";
database_inquiry($query, $rows);
$products = $rows;


<?=$item['description']; ?>

[sea otter]

Well...do you want mysql to limit what it returns for the description to <= 300 characters, or do you want mysql to return the entire description and do the limiting in php?

[save]

i want to do the limiting in php

[sea otter]

<?=substr($item['description'],0,300); ?>

[save]

rep added, cheers!

[baris22]

Thank you very much


<?=substr($item['description'],0,300); ?>