my news system worked perfectly fine yesterday right but now its stopped working i get this error on show_news.php
here is lines 1 - 7 on show_news.phpWarning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/xenigmac/public_html/members/news/show_news.php on line 5
and here is the mysql queryPHP Code:
<?
include("db.php");//the database connection file
$getnews = mysql_query("SELECT * FROM extreme_news ORDER BY id DESC");
while($r=mysql_fetch_array($getnews)){
extract($r);
what is wrong :@Code:CREATE TABLE `extreme_news` ( `id` int(11) NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', `user` varchar(22) NOT NULL default '', `date` varchar(50) NOT NULL default '0000-00-00', `message` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1;