warning error

Anon

I set my site up on a free isp so I could get the php and mysql working.

Once the site was close to being finished, I have uploaded it onto a payed isp that supports these facilities.

I now get a warning (as below) on the page.
Which was originaly a news item.

Warning: 0 is not a MySQL result index in /home/naughty/naughtydesktop-www/tuesday.php3 on line 37

This is the php code where it stats there is a error...

<?
$SQL = "SELECT * FROM tbl_News WHERE Active = 1 ORDER By DateAdded Desc LIMIT $numNews";
$result = mysql_query($SQL);
while ($myrow = mysql_fetch_row($result)) {
$ID = $myrow[0];
$Title = $myrow[1];
$Content = $myrow[2];
$Active = $myrow[3];
$DateAdded = $myrow[4];

	echo "$Content";
	echo "$newsSeparator";
}
?>

Can anyone help me..

Anon

1.) Is your DB and tbl_News setup in MySQL?
2.) Line 37 is which line?
3.) Is your connection to the DB setup?

Anon

It's much simpler:

<rant>
Marco:
Include some error checking in your script.
check if your mysql commands actually worked,
use the flippin' IF statements, and PRINT the mysql_error() if it failed.

That is much smarter than writing tons of code, uploading it, getting a very basic error, and posting a question to this forum.

</rant>

Anon

1) Yes
2)while ($myrow = mysql_fetch_row($result)) {
3)I assume so

Anon

Output the MySQL error, and look what it says ...

cya Rob