PHP errors

•

What is DaniWeb IT Discussion Community?

You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 456,557 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,433 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our PHP advertiser: Lunarpages PHP Web Hosting

Thread Tools Display Modes

Views: 428 | Replies: 3

•

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