What is wrong with this code?

skipper2

I am trying to pull the first 2 sentecnces from a db where the table is news and the field i am pulling the first 2 sentences from is body.

<?php require_once('Connections/enforsys.php'); ?>
<?php
mysql_select_db($database_enforsys, $enforsys);
$query_Recordset1 = "SELECT SUBSTRING_INDEX(body, '.', 2) FROM news ORDER BY date DESC";
$Recordset1 = mysql_query($query_Recordset1, $enforsys) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>

I am not getting an error, but it is not showing the data.

Here is the web site.

http://www.mohawkmedia.com/news.php

Thank you for your help in advance.

Mike

dnast

Try something like

$query_Recordset1 = "SELECT SUBSTRING_INDEX(body, '.', 2) AS `summary` FROM news ORDER BY `date` DESC

and make sure you output

$row_Recordset1['summary']

I don't see where you tried to display anything (not saying it isn't somewhere in the rest of your code).