news script error

GrEEn_DoG

Hi
I tried to code my first news script but i got this error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/pixel/public_html/news.view.php on line 7

Any idea what might be wrong?

hand

There is a SQL-Statement error - Please post it, to let me see

GrEEn_DoG

I'm sure this is the only error I got!

siwis

What hand means is that without seeing the actual php code we cannot tell you why mysql is returning that error.

Paste the code from the point your script where your initially query (ie from the lines quoted)

GrEEn_DoG

Oh, sorry here it is:

<HTML>
<BODY>
<?
$db = mysql_connect("localhost", "pixel_pixel", "8651vivo");
mysql_select_db("news", $db);
$query = mysql_query("SELECT date, headline, text FROM news ORDER BY date DESC LIMIT 0, 5");
while($data = mysql_fetch_array($query)){

echo "<B>$data[1]</B> - ";
echo date("j/n - Y", $data[0]);
echo "<BR>$data[2]<BR><BR>";
}
?>
</BODY>
</HTML>

hand

Pleas try it again with or directive

<HTML>
<BODY>
<?
$db = mysql_connect("localhost", "pixel_pixel", "8651vivo");
mysql_select_db("news", $db);
$query = mysql_query("SELECT date, headline, text FROM news ORDER BY date DESC LIMIT 0, 5")
	or print "&gt;&gt;&gt; MySQL-Error: ".mysql_errno()." -&gt; ".mysql_error()."<br>\n";

while($data = mysql_fetch_array($query)){
	echo "<B>$data[1]</B> - ";
	echo date("j/n - Y", $data[0]);
	echo "<BR>$data[2]<BR><BR>";
}
?>
</BODY>
</HTML>

siwis

Have you tried removing the starting point for your LIMIT (as it starts from 0 anyway 🆒

<HTML>
<BODY>
<?
$db = mysql_connect("localhost", "pixel_pixel", "8651vivo");
mysql_select_db("news", $db);
$query = mysql_query("SELECT date, headline, text FROM news ORDER BY date DESC LIMIT 5", $db);
while($data = mysql_fetch_array($query)){

echo "<B>$data[1]</B> - ";
echo date("j/n - Y", $data[0]);
echo "<BR>$data[2]<BR><BR>";
}
?>
</BODY>
</HTML>

The only other thing I've done is to redeclare your $db connection within the sql. Your query is almost identical to one of mine in a news script which is as follows (only difference being the lack of $db in your original).

	$headlines_result = mysql_query("SELECT news_id,news_title,news_date FROM $newstable WHERE news_status = 1 ORDER BY news_id DESC LIMIT 5",$db);