hi, i know how to chanhe the amount of characters showing i need to know how to show complete words rather than breaking them of half half way throught the word

i looked again and added two more brackets

<?php echo substr ( $row_Recordset1['tk_job_desc'], 0 , strrpos( substr( $row_Recordset1['tk_job_desc'], 0, 80), ' ' ) ); ?>

but the results didnt display anything

the sql statement is currently

mysql_select_db($database_hostprop, $hostprop);

$query_Recordset1 = "SELECT tk_job_title, tk_job_location, tk_job_salary, LEFT(tk_job_desc, 80) as truncated_job_desc FROM think_jobsearch ORDER BY think_jobsearch.tk_job_title";

$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);

$Recordset1 = mysql_query($query_limit_Recordset1, $hostprop) or die(mysql_error());

$row_Recordset1 = mysql_fetch_assoc($Recordset1);

the output

<?php echo $row_Recordset1['truncated_job_desc']; ?>

the changed version is

mysql_select_db($database_hostprop, $hostprop);

$query_Recordset1 = "SELECT tk_job_title, tk_job_location, tk_job_salary, job_desc FROM think_jobsearch ORDER BY think_jobsearch.tk_job_title";

$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);

$Recordset1 = mysql_query($query_limit_Recordset1, $hostprop) or die(mysql_error());

$row_Recordset1 = mysql_fetch_assoc($Recordset1);

<?php echo substr ( $row_Recordset1['tk_job_desc'], 0 , strrpos( substr( $row_Recordset1['tk_job_desc'], 0, 80), ' ' ) ); ?>

if you need anymore code let me know

ok here is a link to the page its in the Latest job section (ignore the rest of the formatting)

http://www.thinkfuturerecruitment.co.uk/beta/what-we-do.php

>>>>>Can you define a variable in PHP to call your data from the job_desc table?

the table name isjob_desc

is that what you mean?

sorry how would i do that then? seems confusing

thanks getting there....i inserted the above code in the top of the php code and amended the correct fields..however its now just showing all the text with no truncating

php

<?php require_once('Connections/hostprop.php'); ?>

<?PHP

$description = $row_Recordset1['tk_job_desc'];

function truncateWords($input, $numwords, $padding="")

{ $output = strtok($input, " \n"); while(--$numwords > 0) $output .= " " . strtok(" \n"); if($output != $input) $output .= $padding; return $output; }

$truncated = truncateWords($description, 10, "...");

echo "<p>$truncated</p>";

?>

<?php

if (!function_exists("GetSQLValueString")) {

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")

{

  if (PHP_VERSION < 6) {

    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {

    case "text":

      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

      break;   

    case "long":

    case "int":

      $theValue = ($theValue != "") ? intval($theValue) : "NULL";

      break;

    case "double":

      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";

      break;

    case "date":

      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

      break;

    case "defined":

      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;

      break;

  }

  return $theValue;

}

}

?>

<?php

// *** Validate request to login to this site.

if (!isset($_SESSION)) {

  session_start();

}

$loginFormAction = $_SERVER['PHP_SELF'];

if (isset($_GET['accesscheck'])) {

  $_SESSION['PrevUrl'] = $_GET['accesscheck'];

}

if (isset($_POST['userid'])) {

  $loginUsername=$_POST['userid'];

  $password=$_POST['password'];

  $MM_fldUserAuthorization = "";

  $MM_redirectLoginSuccess = "signup/signup-complete.php";

  $MM_redirectLoginFailed = "failed.php";

  $MM_redirecttoReferrer = false;

  mysql_select_db($database_hostprop, $hostprop);

  $LoginRS__query=sprintf("SELECT userid, password FROM think_signup WHERE userid=%s AND password=%s",

    GetSQLValueString($loginUsername, "text"), GetSQLValueString($password, "text"));

  $LoginRS = mysql_query($LoginRS__query, $hostprop) or die(mysql_error());

  $loginFoundUser = mysql_num_rows($LoginRS);

  if ($loginFoundUser) {

     $loginStrGroup = "";

          if (PHP_VERSION >= 5.1) {session_regenerate_id(true);} else {session_regenerate_id();}

    //declare two session variables and assign them

    $_SESSION['MM_Username'] = $loginUsername;

    $_SESSION['MM_UserGroup'] = $loginStrGroup;               

    if (isset($_SESSION['PrevUrl']) && false) {

      $MM_redirectLoginSuccess = $_SESSION['PrevUrl'];

    }

    header("Location: " . $MM_redirectLoginSuccess );

  }

  else {

    header("Location: ". $MM_redirectLoginFailed );

  }

}

?>

<?php

if (!function_exists("GetSQLValueString")) {

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")

{

  if (PHP_VERSION < 6) {

    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {

    case "text":

      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

      break;   

    case "long":

    case "int":

      $theValue = ($theValue != "") ? intval($theValue) : "NULL";

      break;

    case "double":

      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";

      break;

    case "date":

      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

      break;

    case "defined":

      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;

      break;

  }

  return $theValue;

}

}

$maxRows_Recordset1 = 9;

$pageNum_Recordset1 = 0;

if (isset($_GET['pageNum_Recordset1'])) {

  $pageNum_Recordset1 = $_GET['pageNum_Recordset1'];

}

$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;

mysql_select_db($database_hostprop, $hostprop);

$query_Recordset1 = "SELECT tk_job_title, tk_job_location, tk_job_salary, tk_job_desc FROM think_jobsearch ORDER BY think_jobsearch.tk_job_title";

$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);

$Recordset1 = mysql_query($query_limit_Recordset1, $hostprop) or die(mysql_error());

$row_Recordset1 = mysql_fetch_assoc($Recordset1);

if (isset($_GET['totalRows_Recordset1'])) {

  $totalRows_Recordset1 = $_GET['totalRows_Recordset1'];

} else {

  $all_Recordset1 = mysql_query($query_Recordset1);

  $totalRows_Recordset1 = mysql_num_rows($all_Recordset1);

}

$pageNum_Recordset1 = 0;

if (isset($_GET['pageNum_Recordset1'])) {

  $pageNum_Recordset1 = $_GET['pageNum_Recordset1'];

}

$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;

mysql_select_db($database_hostprop, $hostprop);

$query_Recordset1 = "SELECT tk_job_title, tk_job_location, tk_job_salary, tk_job_desc FROM think_jobsearch ORDER BY tk_job_ID DESC";

$Recordset1 = mysql_query($query_Recordset1, $hostprop) or die(mysql_error());

$row_Recordset1 = mysql_fetch_assoc($Recordset1);

$totalRows_Recordset1 = mysql_num_rows($Recordset1);

$maxRows_Recordset2 = 3;

$pageNum_Recordset2 = 0;

if (isset($_GET['pageNum_Recordset2'])) {

  $pageNum_Recordset2 = $_GET['pageNum_Recordset2'];

}

$startRow_Recordset2 = $pageNum_Recordset2 * $maxRows_Recordset2;

mysql_select_db($database_hostprop, $hostprop);

$query_Recordset2 = "SELECT ID, FirstName, Surname, PositionReq, SalaryReq, skills_offered, location, LEFT(CanAdminInfo, 100) as truncated_CanAdminInfo FROM think_signup ORDER BY ID DESC";

$query_limit_Recordset2 = sprintf("%s LIMIT %d, %d", $query_Recordset2, $startRow_Recordset2, $maxRows_Recordset2);

$Recordset2 = mysql_query($query_limit_Recordset2, $hostprop) or die(mysql_error());

$row_Recordset2 = mysql_fetch_assoc($Recordset2);

if (isset($_GET['totalRows_Recordset2'])) {

  $totalRows_Recordset2 = $_GET['totalRows_Recordset2'];

} else {

  $all_Recordset2 = mysql_query($query_Recordset2);

  $totalRows_Recordset2 = mysql_num_rows($all_Recordset2);

}

$totalPages_Recordset2 = ceil($totalRows_Recordset2/$maxRows_Recordset2)-1;

mysql_select_db($database_hostprop, $hostprop);

$query_Recordset3 = "SELECT * FROM think_wwd";

$Recordset3 = mysql_query($query_Recordset3, $hostprop) or die(mysql_error());

$row_Recordset3 = mysql_fetch_assoc($Recordset3);

$totalRows_Recordset3 = mysql_num_rows($Recordset3);

?>

results <?php echo $row_Recordset1['job_desc']; ?>

this is what i already have in the code which looks the same as above?

<?PHP

$description = $row_Recordset1['tk_job_desc'];

function truncateWords($input, $numwords, $padding="")

{ $output = strtok($input, " \n"); while(--$numwords > 0) $output .= " " . strtok(" \n"); if($output != $input) $output .= $padding; return $output; }

$truncated = truncateWords($description, 10, "...");

echo "<p>$truncated</p>";

?>

so remove this <?php echo $row_Recordset1['job_desc']; ?>

and replace with this

<?PHP

$description = $row_Recordset1['tk_job_desc'];

function truncateWords($input, $numwords, $padding="")

{ $output = strtok($input, " \n"); while(--$numwords > 0) $output .= " " . strtok(" \n"); if($output != $input) $output .= $padding; return $output; }

$truncated = truncateWords($description, 10, "...");

echo "<p>$truncated</p>";

?>

got an error

Fatal error: Cannot redeclare truncatewords() (previously declared in /usr/users1/jonfort/public_html/think/beta/what-we-do.php:5) in /usr/users1/jonfort/public_html/think/beta/what-we-do.php on line 424

that line of code shows

function truncateWords($input, $numwords, $padding="")

ok thanks i will try this out and let you know how i get on thanks