RSS

PHP errors

Please support our PHP advertiser: Lunarpages PHP Web Hosting

Views: 476 | Replies: 3 | Thread Tools Display Modes

•

Join Date: Oct 2007

Posts: 2

Reputation: ta5na is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

ta5na

Offline

Newbie Poster

PHP errors

Oct 24th, 2007

Hello experts,

I'm having some difficults with the code that i have used from one of the PHP, MySQL books. As the error that appears is in bold on line 17, and the error that shows is listed below:

"Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\Testing PHP with MySQL uses online Tutorials\Testing_with_MySQL_Database.php on line 17"

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<html>
<body>
 
<?php
//Open connection to MySQL server
$connection = mysql_connect('localhost','root') or die ('Unable to connect!');
 
// select database for use
mysql_select_db('movies') or die ('Unable to select database!');
 
// create and execute query
$query = 'SELECT * FROM movies';
$result = mysql_query($query)
or die ('Error in query: $query. ' . mysql_error());
 
// check if records were returned
if (mysql_num_rows(Sresult) > 0)
{
	//Print HTML table
	echo '<table width = 100% cellpadding=10 cellspacing=0 border=1>';
	echo
		 '<tr><td><b>Customer ID/b</td><tr><td><b>Customer Full Name/b</td><tr><td><b>Date Of Birth/b</td>';
 
	// iterate over record set
	// print each field
	while($row = mysql_fetch_row($result))
	{
		echo '<tr>';
		echo '<td>' . $row[0] . '</td>';
		echo '<td>' . $row[1] . '</td>';
		echo '<td>' . $row[2] . '</td>';
		echo '</tr>';
	}
	echo '</table>';
}
else
{
	// print error message
	echo 'No rows found!';
}
 
// once processing is complete
// free result set
mysql_free_result($result);
 
//close connection to MySQL server
mysql_close($connection);
?>
 
</body>
</html>
<html>
<body>

<?php
//Open connection to MySQL server
$connection = mysql_connect('localhost','root') or die ('Unable to connect!');

// select database for use
mysql_select_db('movies') or die ('Unable to select database!');

// create and execute query
$query = 'SELECT * FROM movies';
$result = mysql_query($query)
or die ('Error in query: $query. ' . mysql_error());

// check if records were returned
if (mysql_num_rows(Sresult) > 0)
{
	//Print HTML table
	echo '<table width = 100% cellpadding=10 cellspacing=0 border=1>';
	echo
		 '<tr><td><b>Customer ID/b</td><tr><td><b>Customer Full Name/b</td><tr><td><b>Date Of Birth/b</td>';

	// iterate over record set
	// print each field
	while($row = mysql_fetch_row($result))
	{
		echo '<tr>';
		echo '<td>' . $row[0] . '</td>';
		echo '<td>' . $row[1] . '</td>';
		echo '<td>' . $row[2] . '</td>';
		echo '</tr>';
	}
	echo '</table>';
}
else
{
	// print error message
	echo 'No rows found!';
}

// once processing is complete
// free result set
mysql_free_result($result);

//close connection to MySQL server
mysql_close($connection);
?>

</body>
</html>

Please help,

Thanks,
Mitesh

Last edited by ta5na : Oct 24th, 2007 at 10:41 am. Reason: please use code tags when posting code

•

Join Date: Mar 2007

Location: Israel

Posts: 16

Reputation: Shaffer is an unknown quantity at this point

Rep Power: 2

Solved Threads: 1

Shaffer

Offline

Newbie Poster

Re: PHP errors

Oct 24th, 2007

Hello,
it says Sresult, instead of $result. It's just not a MySQL result, not a PHP variable.

Shaffer.

•

Join Date: Oct 2007

Posts: 2

Reputation: ta5na is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

ta5na

Offline

Newbie Poster

Re: PHP errors

Oct 24th, 2007

Hello,

What a stupid mistake i made, i was sitting here for a good 20mins and i was confused!

Thanks alot for you help,
Mitesh

•

Join Date: Oct 2007

Location: Chenoa, IL

Posts: 13

Reputation: bigattichouse is an unknown quantity at this point

Rep Power: 2

Solved Threads: 2

bigattichouse bigattichouse is offline

Offline

Newbie Poster

Re: PHP errors

Oct 25th, 2007

•

Originally Posted by ta5na

if (mysql_num_rows(Sresult) > 0)

Should be

if (mysql_num_rows($result) > 0)

Need a simple, powerful knowledgebase? Bigattichouse Knowledge Base finds the solution while you're still typing the problem.
http://www.bigattichouse.com/knowledgebase.html