[Powerbook]

Hi folks,

I know it's easy, but I am starring too long on it now:

I get data from a MySQL DB here:
// SQl Statement
$query_products = "SELECT ID, HEADLINE, HEAD, TEXT, PIC_PR FROM RS_03_PRODUCTS";
// Query
$localProducts = $db_products->SQLReqNames($query_products);


Here is my output on the webpage:
for ( $count=0; $count<sizeof($localProducts); $count++)
{
?>
<img src="<?=$path_imgdb.$localProducts[$count]['PIC_PR']?>">
<br>
<b><?=$localProducts[$count]['HEADLINE']?></b>
<br>
<b><?=$localProducts[$count]['HEAD']?></b>
<br>
<?=$localProducts[$count]['TEXT']?>
<br>
<?
}


Where/how do I cut off the data from TEXT to, say, 300 characters?

Thanks,
Powerbook

[osxisfun]

http://us2.php.net/manual/en/function.substr.php

[madmacgames]

even better use preg_replace to have it chop off at the closest word instead of cutting a word in half:

[php]$char_count = 300;

$text = preg_replace("/(^.{0,$char_count})(\W+.*$)/", "\${1}", $text);[/php]

[Powerbook]

That variable problem is solved, or never weas one, but I am not getting any info out of the MySQL db...
Somehow my statement ist correct, but empty.

$query_product_content = "SELECT ID, HEADLINE, HEAD, TEXT, PIC, PRODUCT_ID FROM RS_03_PRODUCTS WHERE PRODUCT_ID="
$query_product_content .= $prod_id;

Hm.........

Regards
Powerbook