[RESOLVED] Print Limit

jerrylouise

$sql = mysql_query("SELECT * FROM `storys` WHERE id = $id LIMIT 1");

This is the code i have tried so far, what i want to do it make it print a longtext entry but limit it to 100 words just for displaying a short preview.

devinemke

SELECT SUBSTRING(longtextfield, 1, 100) FROM storys

NogDog

SELECT SUBSTRING_INDEX(`text_field`, ' ', 100) AS sample_text FROM `storys` WHERE id = $id LIMIT 1

jerrylouise

<?php
$host = "mysql10.streamline.net";
$username = "jennifersp";
$password = "s92630";
$database = "jennifersp";
$server = mysql_connect($host, $username, $password);
$connection = mysql_select_db($database, $server);
$db = mysql_select_db($database, $server);
$id = $_GET['id'];
$sql = mysql_query("SELECT SUBSTRING_INDEX(`body`, 1, 100) AS small FROM `storys` WHERE id = $id");
$row = mysql_fetch_row($sql);
?>
<?php
$usrname = $_GET['usrname'];
?>
<div>
<table width="100%" border="0" cellspacing="0" cellpadding="4">
  <tr>
    <td class="green">
<a href="javascript:ajaxpage('../cls.php', 'story<?php echo $id ?>');">Close Preview</a>
</td>
	</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="4">
  <tr>
    <td width="100%" bgcolor="#ffffff">
<?php
print $sql;
?>
	</td>
  </tr>
</table>
</div>

This is the code i got, its not printing i think im using the wrong command to print it?

NogDog

print $row[0];

jerrylouise

printing row 0 prints out the entire story and not the limited version

NogDog

The second parameter to SUBSTRING_INDEX() is the delimiter to search for a number of times specified by the 3rd parameter. In my previous example, I used a space, but you have set it to the number 1.

// for the query section:
$sql = mysql_query("SELECT SUBSTRING_INDEX(`body`, ' ', 100) AS small FROM `storys` WHERE id = $id");
$row = mysql_fetch_assoc($sql);

// to output it:
echo $row['small']

(Using mysql_fetch_assoc() helps make the code more specific and readable, as you specify elements by their column/alias names rather than by ambiguous numbers.)