Can some one help me out here?

I am receiving the following error when I run my script to connect and return simple results for my dB.

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\inetpub\wwwroot\sites\mapq1.PHP on line 77

Error line (77) is marked in red below.

//connect to the database server
$connection = mysql_connect($db_host, $db_username, $db_password) or die(mysql_error());

//select database
$db = mysql_select_db($db_name, $connection);



$sql="select regid,firstname from users";

$rs=mysql_query ($sql, $connection);

while( $row = mysql_fetch_array($rs) )		{
			echo("user: ".$row["regid"]);
			echo("-First Name: ".$rown["firstname"]."<br>");
		}
?>

</body>
</html>

Can anyone see what I am doing wrong?

This...

PHP Code:

$rs=mysql_query ($sql, $connection); 


With the space is invalid although I don't see why it did not throw a parse error first. Try removing the space though and let me know if that worked.

I don't think the space matters as PHP removes all spaces before the code is parsed.

You should be checking for errors everytime you issue a statement against the database. I've rewritten your code to include error checking.

PHP Code:

//connect to the database server
$connection = mysql_connect($db_host, $db_username, $db_password) or die(mysql_error());

//select database
$db = mysql_select_db($db_name, $connection) or die (mysql_error());



$sql="select regid,firstname from users";

$rs=mysql_query ($sql, $connection);
if (!$rs) die ("ERROR: ". mysql_error());


while( $row = mysql_fetch_array($rs) ){
echo("user: ".$row["regid"]);
echo("-First Name: ".$rown["firstname"]."<br>");
}
?>

</body>
</html> 


Hi,

I think this will sort it, CHANGE THIS: -

PHP Code:

while( $row = mysql_fetch_array($rs) ){ 
echo("user: ".$row["regid"]); 
echo("-First Name: ".$rown["firstname"]."<br>"); 
} 


TO THIS

PHP Code:

while( $row = mysql_fetch_array($rs) ){ 
echo("user: ".$row["regid"]); 
echo("-First Name: ".$row["firstname"]."<br>"); 
} 


Note the change to the second echo statement in the while loop, $rown has not been defined which will cause the error you are getting.

Hope it works.

Ian

This error....

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\inetpub\wwwroot\sites\mapq1.PHP on line 77

Definatly means that there is an error with either the query itself, it could also be that your SQL itself is invalid.

Thanks for the help. I do believe it helped. But I found that the dB had errors as well. But I got them fixed so thanks again