Code: Select all
<?php
// Copyright: haym37
require 'config.php';
$link = mysql_connect("$dbhost", "$dbuser", "$dbpass") or die("Could not connect to database: " . mysql_error());
mysql_select_db("$dbdatabase") or die("Could not select database: " . mysql_error());
$result = mysql_query("SELECT * FROM news LIMIT 30");
$newsinfo = mysql_fetch_array($result);
extract($newsinfo);
echo "<br>
<table width='75%' border='1' align='center' bordercolor='#000000' bgcolor='#FFFFFF'>
<tr>
<td><div align='center'><font color='#000000' size='2' face='Verdana, Arial, Helvetica, sans-serif'>On
<b>$date</b>, <b>$author</b> posted <b>$title</b></font></div></td>
</tr>
<tr>
<td><div align='center'><font color='#000000' size='3' face='Verdana, Arial, Helvetica, sans-serif'>$news</font></div></td>
</tr>
</table>
<br>";
mysql_close($link);
?>If you could somehow help me display all of the news that I posted, that would be great. I even tried echoing it twice, but it displays the same news twice. Any help would be great. Thanks!
feyd | added
Code: Select all
tags :: [/color][url=http://forums.devnetwork.net/viewtopic.php?t=21171][color=red]:arrow: [u][b]Posting Code in the Forums[/b][/u][/color][/url]