Supplied argument is not a valid MySQL result resource

[Ice]

damn... take a look at this code and tell me whats the error.. i cant find it at least... the dbuser authentication is correct so i cant see why it gives me this error 🙁

Warning: Supplied argument is not a valid MySQL result resource in /hsphere/local/home/wavearti/waveartists.com/index.php on line 76

<?php
	$host = "mysql.server.host";
	$username = "waveadmin";
	$password = "my_password_";
	$database = "wave_temp";
	mysql_connect($host,$username,$password);
$query = "SELECT newsCaption, newsText, newsTimeStamp, newsTimeInfo, newsAdmin, newsCat FROM news";
		$result = mysql_query($query);
		while($row = mysql_fetch_array($result))
		{
			$row['newsCaption']=$caption;
			$row['newsText']=$text;
			$row['newsTimeStamp']=$timeStamp;
			$row['newsTimeInfo']=$timeInfo;
			$row['newsAdmin']=$admin;
			$row['newsCat']=$category;
			print("<table width=80% cellpadding=0 cellspacing=0 border=0>");
			print("<tr><td><span class=\"newsHeadText\"".$caption."</span></td></tr>");
			print("<tr><td><span class=\"newsSmallText\">".$category." - at ".$TimeInfo." by ".$admin."</span></td></tr>");
			print("<tr><td><span class=\"newsRegText\">".$text."</span></td></tr>");
			print("</table><br>");
		}
		?>

see it for yourself at www.waveartists.com
i originally used the

[jacob_kochi]

Select a database

$connect=mysql_connect($host,$username,$password);
mysql_select_db($database,$connect);

[Ice]

damnnit.... how could i be so stupid.??

thanx... happy newyear.. 🙂

[Ice]

ok now it almost works... but only these words are shown.:

• at by

which is some of the text on the second line... none of the variables are printed.. ive made sured over and over again that ive using the correct names of the database fields...

[xblue]

Hi there,

I'd think e.g. this: $row['newsCaption']=$caption;

should rather be the other way around: $caption=$row['newsCaption'];

Otherwise you'd overwrite the variables that hold the values you just received from the database with something else (not much point in querying the DB at all if that's what you intend 😃)

[Ice]

ahh thanx alot man.... now it works..... 😃