Jump to content

[SOLVED] Displaying MYSQL data


karatekid36

Recommended Posts

They just use the substr() function to show a limited amount of text, then add the "..." to the end. Then the more link will lead to a page that will have the message ID in the URL, and it will display the entire message on that page.

 

www.php.net/substr

Here, I will give you some example code to look at.

 

<?php

//select message from db
$query = mysql_query("SELECT message FROM table");
$row = mysql_fetch_assoc($query);

//This will echo out the ENTIRE message
echo $row['message'];

//Now to change it so it only echos out some of the message, we do this
$message = substr($row['message'], 0, 15);
echo $message.'...'; //will print the first 15 letters, then add a ...

?>

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.