News Script

corruption

I've got everything written to a news script except how to get it to display into html tables once the data has been extracted.

//script to display the news in html format or something.
$sql    = "SELECT * FROM news ORDER BY id ASC LIMIT 0,15";
$result = mysql_query($sql) or die(mysql_error());
if(mysql_num_rows($result) > 0) {
   echo mysql_num_rows($result)." rows found<br />";
   while($row = mysql_fetch_array($result)) {
      echo "Topic: ".$row['topic']."<br />
            Author: ".$row['author']."<br />
            Date: ".$row['date']."<br />
            news: ".$row['news']."<br />"; 
   }
}
else {
   echo "No rows returned!";
}

?>

It reads the data, i just need to get it into some sort of html table that i can work with and organize. If anyone has a good place to go to see something like this coded that would be great, or any input on how to get the things into a table. Thanks

Azazeal

You can hop in and out of PHP.
This is a not so fancy way of doing it, but it demonstrates the ability to escape PHP to HTML.

<?php
//script to display the news in html format or something.
$sql	=	"SELECT * FROM news ORDER BY id ASC LIMIT 0,15";
$result	=	mysql_query($sql) or die(mysql_error());
if(mysql_num_rows($result) > 0)
	{
	?>
	<table width="80%" align="center">
	<tr>
	<td width="100%" align="center">
	<?php echo mysql_num_rows($result)." rows found<br />";
	?>
	</td>
	</tr>

<?php
while($row = mysql_fetch_array($result))
	{
		$topic	=	$row['topic'];
		$author	=	$row['author'];
		$date	=	$row['date'];
		$news	=	$row['news'];
		?>
		<tr><td width="10%">Topic: </td><td width="90%"><?php echo $topic; ?></td></tr>
		<tr><td width="10%">Author: </td><td width="90%"><?php echo $author; ?></td></tr>
		<tr><td width="10%">Date: </td><td width="90%"><?php echo $date; ?></td></tr>
		<tr><td width="10%">News: </td><td width="90%"><?php echo $news; ?></td></tr>
		<?php
	}
?>
</table>
<?php
}
else
{
echo "No rows returned!";
}

?>

*not tested

corruption


$sql    =    "SELECT * FROM news ORDER BY id DESC LIMIT 0,15";
$result    =    mysql_query($sql) or die(mysql_error());
if(mysql_num_rows($result) > 0)
    {
    ?>
    <body bgcolor="#000000">
	<table width="600px" align="center" cellpadding="0" cellspacing="0">
    <tr>
    <td width="282" align="center">
    <?php echo mysql_num_rows($result)." rows found<br />";
    ?>
    </td>
    </tr>

<?php
while($row = mysql_fetch_array($result))
    {
        $topic    =    $row['topic'];
        $author    =    $row['author'];
        $date    =    $row['date'];
        $news    =    $row['news'];
        ?>


		<tr><td width="282" bgcolor="#6600FF" align="center" colspan="2"><font color="#FFFFFF" face="Verdana, Arial, Helvetica, sans-serif" pointsize=""="11px"><div align="left"><?php echo $topic; ?></div></font></td></tr>
        <tr><td width="282" bgcolor="#000000" align="center" colspan="2"><font color="#FFFFFF" face="Verdana, Arial, Helvetica, sans-serif" pointsize="11px"><?php echo $news; ?></font></td></tr>
		<tr><td width="202" bgcolor="#6600FF" align="left"><font color="#FFFFFF" face="Verdana, Arial, Helvetica, sans-serif" pointsize="11px">Posted by:<?php echo $author; ?></font></td>
        <td width="114" bgcolor="#6600FF" align="right"><font color="#FFFFFF" face="Verdana, Arial, Helvetica, sans-serif" pointsize="11px"><?php echo $date; ?></font></td></tr> 

        <?php
    }
?>
</table>
<br /><hr color="#6600FF" width="600px"><br />
</body>
<?php
}
else
{
echo "No rows returned!";
}

?>

this is displayed at http://www2.truman.edu/~d1514/Deltasig/News/displaynews.php
I want to seperate each news post with a <br><hr><br> set of tags, but i can't figure out where to put the section of code for it to work.

Azazeal

Just use the entire table in the while loop.
The changes are in bold.
The one thing that would happen with this script, you will have a horizontal rule at the bottom of the last news post.


  <body bgcolor="#000000"> 
  <table width="600px" align="center" cellpadding="0" cellspacing="0"> 
    <tr> 
    <td width="282" align="center"> 
    <?php echo mysql_num_rows($result); ?> rows found
    </td> 
    </tr> 
     [B]</table>[/B]
    <?php 
    while($row = mysql_fetch_array($result)) 
        { 
            $topic    =    $row['topic']; 
            $author    =    $row['author']; 
            $date    =    $row['date']; 
            $news    =    $row['news']; 
            ?> 

         [B]<table width="600px" align="center" cellpadding="0" cellspacing="0">[/B]
        <tr><td width="282" bgcolor="#6600FF" align="center" colspan="2"><font color="#FFFFFF" face="Verdana, Arial, Helvetica, sans-serif" pointsize=""="11px"><div align="left"><?php echo $topic; ?></div></font></td></tr> 
        <tr><td width="282" bgcolor="#000000" align="center" colspan="2"><font color="#FFFFFF" face="Verdana, Arial, Helvetica, sans-serif" pointsize="11px"><?php echo $news; ?></font></td></tr> 
        <tr><td width="202" bgcolor="#6600FF" align="left"><font color="#FFFFFF" face="Verdana, Arial, Helvetica, sans-serif" pointsize="11px">Posted by:<?php echo $author; ?></font></td> 
        <td width="114" bgcolor="#6600FF" align="right"><font color="#FFFFFF" face="Verdana, Arial, Helvetica, sans-serif" pointsize="11px"><?php echo $date; ?></font></td></tr> 
        [B]</table> 
        <br />
        <hr color="#6600FF" width="600px"><br /> [/B]

        <?php 
    } 
?> 
    </body>

corruption

I know this is a php forum, but i'm still having trouble with my stuff displaying properly in IE, stupid non-standards compliant browser. here's the page

http://www2.truman.edu/~d1514/Deltasig/index.php

everything is shifted to the left of the page, need help getting the title and the news section centered accross both columns.

php file;

 while($row = mysql_fetch_array($result)) 
        { 
            $topic   =    $row['topic']; 
            $author  =    $row['author']; 
            $date    =    $row['date']; 
            $news    =    $row['news']; 
            ?> 

        <table width="500px" cellpadding="0" cellspacing="0">
        <tr><th width="500px"><div align="center"><?php echo $topic; ?></div></th></tr>
        <tr><td><?php echo $news; ?></td></tr>
        <tr><th width="250px">Posted by:<?php echo $author; ?></th>
		<th width="250px"><div align="right"><?php echo $date; ?></div></th></tr>

</table>
        <br />
        <br />

That's it. Thanks for any help.

btw the display looks ok in Mozilla Fire Fox, just the news isn't to the left margin. Also, is there a way i can get it to not display the number of rows that it found?

Azazeal

http://www.htmlhelp.com/reference/html40/tables/td.html

You need to add an attribute to the <TD> tags.