Back To Programming / Scripting / Coding Forum

news poster

  • Inito
  • Graduate
  • Graduate
  • User avatar
  • Joined: Dec 30, 2003
  • Posts: 223
  • Status: Offline

Post January 30th, 2004, 11:54 am

this is about a news poster im making, Im stuck on an error.
this is just the display part.

Code: [ Select ]
<?php
$db = mysql_connect("dave90_nl_db", "dave90", "") or die ("Connection to database failed");
mysql_select_db("dave90_nl_db", $db);
$news_SQL = "SELECT * FROM news ORDER BY news_datetime DESC";
$news_result = mysql_query($news_SQL);
?>

<?php
//This part takes care of the message display
while($news = mysql_fetch_array($news_result)) {

?>
<P><br>
<center>
<table width="600" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td>
<font face="arial">
<span style="font-size:12">
Posted on: <?php echo $news['news_datetime'] ?>
</span>
<br>
<span style="font-size:13">
<b><?php echo $news['news_header'] ?></b>
</span>
</font>
</td>
</tr>
<tr>
<td>
<?php
if(strlen($news['news_main']) > 220 {
$news['news_main'] = substr($news['news_main'], 0, 180) . " ... <a href="news.php?news_ID=" . $news['news_ID'] . ">more</a>";
}
?>
<br><font face="arial"><span style="font-size:13"><?php echo $news['news_main'] ?></span></font></td>
</tr>
</table>
</center>
<?php
}
mysql_close();
?>
  1. <?php
  2. $db = mysql_connect("dave90_nl_db", "dave90", "") or die ("Connection to database failed");
  3. mysql_select_db("dave90_nl_db", $db);
  4. $news_SQL = "SELECT * FROM news ORDER BY news_datetime DESC";
  5. $news_result = mysql_query($news_SQL);
  6. ?>
  8. <?php
  9. //This part takes care of the message display
  10. while($news = mysql_fetch_array($news_result)) {
  12. ?>
  13. <P><br>
  14. <center>
  15. <table width="600" border="0" cellspacing="0" cellpadding="0" align="center">
  16. <tr>
  17. <td>
  18. <font face="arial">
  19. <span style="font-size:12">
  20. Posted on: <?php echo $news['news_datetime'] ?>
  21. </span>
  22. <br>
  23. <span style="font-size:13">
  24. <b><?php echo $news['news_header'] ?></b>
  25. </span>
  26. </font>
  27. </td>
  28. </tr>
  29. <tr>
  30. <td>
  31. <?php
  32. if(strlen($news['news_main']) > 220 {
  33. $news['news_main'] = substr($news['news_main'], 0, 180) . " ... <a href="news.php?news_ID=" . $news['news_ID'] . ">more</a>";
  34. }
  35. ?>
  36. <br><font face="arial"><span style="font-size:13"><?php echo $news['news_main'] ?></span></font></td>
  37. </tr>
  38. </table>
  39. </center>
  40. <?php
  41. }
  42. mysql_close();
  43. ?>


is giving me an error on the line where if(strlen$news.... starts

its meant to that if the post has more than 220 characters, 180 are displayed, and the rest readable at a link. (set by the id of the post)

without that, just normally
Code: [ Select ]
echo $news['news_main']

works fine.

the same happening on when i try to change the time format, but ill leave things to this first.
thanks.
  • Anonymous
  • Bot
  • No Avatar
  • Joined: 25 Feb 2008
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post January 30th, 2004, 11:54 am

  • RichB
  • Guru
  • Guru
  • User avatar
  • Joined: May 17, 2003
  • Posts: 1121
  • Loc: Boston
  • Status: Offline

Post January 30th, 2004, 11:59 am

Looks like you missed a closing parentheses after the 220 and before the opening bracket of the if clause.

Code: [ Select ]
if(strlen($news['news_main']) > 220 {

should be:
Code: [ Select ]
if(strlen($news['news_main']) > 220) {
Free Programming Resources
  • Inito
  • Graduate
  • Graduate
  • User avatar
  • Joined: Dec 30, 2003
  • Posts: 223
  • Status: Offline

Post January 30th, 2004, 12:44 pm

damn, srry, i noticed another mistake btw too.

Page 1 of 1

Post Information

  • Total Posts in this topic: 3 posts
  • Users browsing this forum: No registered users and 118 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 2011 Unmelted, LLC. Ozzu® is a registered trademark of Unmelted, LLC.