thats exactly what I'm after.
I've got the bit about displaying the text, here's how it translates...
<?php
$extract = $row_WADATestimonials['fieldname150'];
$lastspace = strrpos($extract, ' ');
$extract_word = substr($extract, 0, $lastspace).'...';
echo nl2br($extract_word);
?>
I've tested it with the actual 'full length' text "tTEXT" and I can get it to display with the '...' at the end.
I don't understand where to put the sql to limit the text to 150 characters...
left(fieldname,150) as fieldname150.
here is the sql that was created by DataAssist...
<?php
$maxRows_WADATestimonials = 10;
$pageNum_WADATestimonials = 0;
if (isset($_GET['pageNum_WADATestimonials'])) {
$pageNum_WADATestimonials = $_GET['pageNum_WADATestimonials'];
}
$startRow_WADATestimonials = $pageNum_WADATestimonials * $maxRows_WADATestimonials;
mysql_select_db($database_connHORIZONr, $connHORIZONr);
$query_WADATestimonials = "SELECT * FROM Testimonials ORDER BY tID DESC";
$query_limit_WADATestimonials = sprintf("%s LIMIT %d, %d", $query_WADATestimonials, $startRow_WADATestimonials, $maxRows_WADATestimonials);
$WADATestimonials = mysql_query($query_limit_WADATestimonials, $connHORIZONr) or die(mysql_error());
$row_WADATestimonials = mysql_fetch_assoc($WADATestimonials);
if (isset($_GET['totalRows_WADATestimonials'])) {
$totalRows_WADATestimonials = $_GET['totalRows_WADATestimonials'];
} else {
$all_WADATestimonials = mysql_query($query_WADATestimonials);
$totalRows_WADATestimonials = mysql_num_rows($all_WADATestimonials);
}
$totalPages_WADATestimonials = ceil($totalRows_WADATestimonials/$maxRows_WADATestimonials)-1;$maxRows_WADATestimonials = 10;
$pageNum_WADATestimonials = 0;
if (isset($_GET['pageNum_WADATestimonials'])) {
$pageNum_WADATestimonials = $_GET['pageNum_WADATestimonials'];
}
$startRow_WADATestimonials = $pageNum_WADATestimonials * $maxRows_WADATestimonials;
mysql_select_db($database_connHORIZONr, $connHORIZONr);
$query_WADATestimonials = "SELECT * FROM Testimonials ORDER BY tID DESC";
$query_limit_WADATestimonials = sprintf("%s LIMIT %d, %d", $query_WADATestimonials, $startRow_WADATestimonials, $maxRows_WADATestimonials);
$WADATestimonials = mysql_query($query_limit_WADATestimonials, $connHORIZONr) or die(mysql_error());
$row_WADATestimonials = mysql_fetch_assoc($WADATestimonials);
if (isset($_GET['totalRows_WADATestimonials'])) {
$totalRows_WADATestimonials = $_GET['totalRows_WADATestimonials'];
} else {
$all_WADATestimonials = mysql_query($query_WADATestimonials);
$totalRows_WADATestimonials = mysql_num_rows($all_WADATestimonials);
}
$totalPages_WADATestimonials = ceil($totalRows_WADATestimonials/$maxRows_WADATestimonials)-1;
?>
what do I need to change to limit the tTEXT field to 150
thanks in advance