display a preview

searls03 · April 3, 2011

so I have this code.......

<?php
include 'config1.php';
include 'opendb.php';

// if no id is specified, list the available articles
if(!isset($_GET['id']))
{
   $self = $_SERVER['PHP_SELF'];

   $query = "SELECT id, title FROM news ORDER BY id DESC";
   $result = mysql_query($query) or die('Error : ' . mysql_error());

   // create the article list
   while($row = mysql_fetch_array($result, MYSQL_NUM))
   {
      list($id, $title) = $row;
      $content .= "<p><a href=\"$self?id=$id\">$title</a></p>\r\n";
   }


   $title = 'News';
} else {
   // get the article info from database
   $query = "SELECT title, content FROM news WHERE id=".$_GET['id'];
   $result = mysql_query($query) or die('Error : ' . mysql_error());
   $row = mysql_fetch_array($result, MYSQL_ASSOC);

   $title = $row['title'];
   $content = $row['content'];
}

include 'closedb.php';

?>
<?php
$query = "INSERT INTO view_news (`topic_id`, `user_id`)
          VALUES ($id, $userid)
          ON DUPLICATE KEY UPDATE `user_id`=`userid`";
?>
<?php
$query = "SELECT *.news, IF(`view)news.user_id`=$userid, 1, 0) as viewed
          FROM `news`
          LEFT JOIN `view_news`
            ON `topics.id` = `view_news.topic_id`
            AND `view_news.user_id` = $user_id";
		while($row = mysql_fetch_assoc($result))
{
    //Create the style for the article link
    $style = ($row['viewed']==0) ? 'font-weight:bold;' : '';
   echo "<a href=\"news.php?id={$row['id']}\" style=\"{$style}\">$row{['title']}</a><br />\n";
}
		?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/template2.dwt.php" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<!-- InstanceBeginEditable name="doctitle" -->
<title>News</title>
<!-- InstanceEndEditable -->
<style type="text/css">

#editregion {
position:absolute;
left:-2px;
top:272px;
width:1293px;
height:51px;
z-index:1;
text-align: center;
clear: none;
float: none;
}

body {
background-image: url(button/boyscout1.png);
background-repeat: no-repeat;
position: relative;
}
#menu {
position:relative;
left:160px;
top:0px;
width:931px;
height:59px;
z-index:19;

}
#menu #MenuBar1 li a {
color: #000;
border-top-style: outset;
border-right-style: outset;
border-bottom-style: outset;
border-left-style: outset;
width: 100px;
}

#status {
position:relative;
left:16px;
top:180px;
width:124px;
height:44px;
z-index:14;
}


</style>
<script src="SpryAssets/SpryMenuBar.js" type="text/javascript"></script>
<script type="text/javascript">
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
</script>
<!-- InstanceBeginEditable name="head" -->
<style type="text/css">
</style>
<style type="text/css">
a:link {
color: #00F;
}
#editregion table tr td {
text-align: left;
}
</style>
<!-- InstanceEndEditable -->
<!-- InstanceParam name="id" type="text" value="apDiv6" -->
<link href="SpryAssets/SpryMenuBarHorizontal.css" rel="stylesheet" type="text/css" />
<style type="text/css">
#logout {
position:relative;
left:0px;
top:0pxpx;
width:134px;
height:38px;
z-index:20;
font-weight: bold;
font-size: 24px;
}
#logout a {
color: #000;
}

#footer {
position:absolute;
left:98px;
top:512px;
width:239px;
height:70px;
z-index:21;
clear: both;
float: none;
}
#status {
text-align: center;
}
#logout1 {
position:absolute;
left:1071px;
top:191px;
width:224px;
height:61px;
z-index:2;
}
#menu2 {
position:absolute;
left:-1px;
top:172px;
width:497px;
height:92px;
z-index:20;
}
</style>
</head>
<body>
<div id="logout1"><div id="logout"><a href="logout.php">Logout</a></div></div>
<div id="status"><?php echo "$accounttype"; ?>
  <br /><?php echo "$name"; ?>
  <p> </p>
</div>
<div id="editregion"><!-- InstanceBeginEditable name="EditRegion3" --><style type="text/css">

// ... some css here to make the page look nicer

</style>

<table width="600" border="0" align="center" cellpadding="10" cellspacing="1" bgcolor="#336699">
<tr>
<td bgcolor="#FFFFFF">
<h1 align="center"><?php echo $title; ?></h1>
<?php
echo $content;

// when displaying an article show a link
// to see the article list
if(isset($_GET['id']))
{
?>
<p> </p>
<p align="center"><a href="<?php echo $_SERVER['PHP_SELF']; ?>">Back to News</a></p>
<?php
}
?>
</td>

and basically what I want to do is pull content from a database that I have so that like the first 100 words will display under the link before it is clicked.........is there a way to do this?

dcro2 · April 3, 2011

SUBSTRING_INDEX:

$query = "SELECT id, title, SUBSTRING_INDEX(content, ' ', 101) FROM news ORDER BY id DESC";

You could also get the whole field, explode() by spaces and then join the first 100 or something. I figure something directly in MySQL will work faster though.

Sign In

display a preview

Recommended Posts

searls03

Link to comment

Share on other sites

dcro2

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information