Display first 50 characters only in php,mysql

Question

I have two fields in database table, title and description. I am displaying tha data in php while loop.

My Code :

$sql = "select * from sightseeing";
    $i = 1;
    $res = mysql_query($sql, $conn); 
    if( mysql_num_rows($res) > 0) {
        while($row = mysql_fetch_array($res))
       {

        echo "<tr>
          <td>".$i++."</td>
          <td>".$row["title"]."</td>
          <td>".$row["description"]."</td>
        </tr>";
      }
   }

I want to show only first 50 characters from description field. How to do that?

substr($row['description'], 0, 50); See: http://php.net/manual/en/function.substr.php — Daniele D, Dec 17 '15 at 08:29

score 4 · Accepted Answer · answered Dec 17 '15 at 08:30

4

try this

 $sql = "select * from sightseeing";
$i = 1;
$res = mysql_query($sql, $conn); 
if( mysql_num_rows($res) > 0) {
    while($row = mysql_fetch_array($res))
{

echo "<tr>
  <td>".$i++."</td>
  <td>".$row["title"]."</td>
  <td>".substr($row['description'], 0, 50)."</td>
 </tr>";
  }
  }

answered Dec 17 '15 at 08:30

Syed mohamed aladeen

6,507
4
32
59

you are welcome, could you please tick my answer as accepted – Syed mohamed aladeen Dec 17 '15 at 08:43

score 1 · Answer 2 · answered Dec 17 '15 at 08:36

1

use MySQL LEFT

select *,LEFT(description , 50) description from sightseeing

answered Dec 17 '15 at 08:36

Abhishek Sharma

6,689
1
14
20

Display first 50 characters only in php,mysql

2 Answers2