News in index.php

[Joshv1288]

i was wondering how to add my news system into my index

[trq]

A little more detail please?

[Joshv1288]

how do i make my index display my news

 

like right now i have to manually go in to the index to add news but now i have a system and want to add it into my index how would i go about doin that

[trq]

Still more details are required. Where is your news stored, a db? Do you know anything about selecting data from a database?

[Joshv1288]

yea my news is stored in a db and idk how to get data from a db

[trq]

Without more info I'm just going to give you a very generic example. Work it out from here.

 

<?php

  // connect to db

  $sql "SELECT title,article,stamp FROM news ORDER BY stamp";

  if ($result = mysql_query($sql)) {
    if (mysql_num_rows($result)) {
      while ($row = mysql_fetch_assoc($result)) {
        echo "<h1>{$row['stamp']} - {$row['title']}</h1>";
        echo "<p>{$row['article']}</p>";
      }
    }
  }

?>

[Joshv1288]

heres my db where my news is stored

 
      CREATE TABLE news_posts (
      id INT(11) NOT NULL AUTO_INCREMENT,
      title VARCHAR(70) NOT NULL,
      author VARCHAR(50) NOT NULL,
      post TEXT NOT NULL,
      DATE DATETIME NOT NULL,
      PRIMARY KEY (id)
      );

and go here to see how my index is setup http://h3swatlg.exofire.net/index.php

[trq]

I've given you an example, how about you have a go and tell us what the problem is (if any)?

[Joshv1288]

ok i added the code directly where my news should go and edited a little and i get this error

 

Parse error: syntax error, unexpected '>' in /home/h3swat/public_html/news/index.php on line 115

 

 

105- echo "            <td valign=\"top\" class=\"windowbg\">;
<?php

  include('mysql_connect.php');

110-  $sql 'SELECT title,post,id FROM news_posts ORDER BY id';

  if ($result = mysql_query($sql)) {
    if (mysql_num_rows($result)) {
      while ($row = mysql_fetch_assoc($result)) {
    115-    echo "<h1>{$row['id']} - {$row['title']}</h1>";
        echo "<p>{$row['post']}</p>";
      }
    }
  }

?>
122-echo "</td>\n"; 

[turkman]

 

<?php
include 'conf.php'; //configuration file
include 'opendb.php'; //contains the open database commands

$sql = "SELECT * FROM news_posts";
$res = mysql_query($sql) or die (mysql_error());

while($row = mysql_fetch_array($res,MYSQL_ASSOC)){
       
       $data = sprintf("<h1> %s </h1> <p> %s </p> <p> Written by: %s</p>",
       $row['title'],$row['post'],$row['author']);
       echo $data;


}
?>

[waynew]

facepalm.jpg

[Joshv1288]

Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /home/h3swat/public_html/news/index.php on line 109

 

<?php
include 'mysql_connect.php'; //contains the open database commands

109-$sql = "SELECT * FROM news_posts";
$res = mysql_query($sql) or die (mysql_error());

while($row = mysql_fetch_array($res,MYSQL_ASSOC)){
       
       $data = sprintf("<h1> %s </h1> <p> %s </p> <p> Written by: %s</p>",
       $row['title'],$row['post'],$row['author']);
       echo $data;


}
?>