Wrong parameter count for mysql_numrows()

[run2web]

Can Someone please explain to me what this means in in this error?

	$query_owners = "SELECT * FROM $own WHERE 1 ";   //ORDER BY $order
	// if the OwnerID has a value 
	if ($_POST['OwnerID']){ 
	$query_owners = $query_owners." and OwnerID LIKE '$ownerid%'"; 
	} 
	// if the LastName has a value 
	if ($_POST['LastName']){ 
	$query_owners = $query_owners." and LastName LIKE '$last%'"; 
	} 
	// if the first name has a value 
	if ($_POST['FirstName']){ 
	$query_owners = $query_owners." and FirstName LIKE '$first%'"; 
	} 	
	// if the City has a value 
	if ($_POST['City']){ 
	$query_owners = $query_owners." and City LIKE '$city%'"; 
	} 
	//if State has a value 
	if ($_POST['State']){ 
	$query_owners = $query_owners. " and State  = '$state'"; 
	} 
	// if the Zip has a value 
	if ($_POST['Zip']){ 
	$query_owners = $query_owners." and Zip LIKE '$zip%'"; 
	} 
	// if the hidden has value 
	if ($_POST['hidden']){ 
	$query_owners = $query_owners." and hidden LIKE '$hidden%'"; 
	} 

//run the query 
$result_owner = mysql_query($query_owners);  
//query Plots
$query_plots = "SELECT * From $plots ";
$query_plots = $query_plots. "and plot_details($thePlotID) LIKE '$thePlotID%'";
$result_plots =mysql_query($query_plots);
$results= mysql_numrows($result_owner,$result_plots); //ERROR IS FOR THIS LINE
$item= 0;

TIA

[rIkLuNd]

You must write mysql_num_rows, not mysql_numrows!

[run2web]

rIkLuNd: You are correct about the mysql_num_rows however I that did not change my error.

Now it just shows
Warning: Wrong parameter count for mysql_num_rows()

[rIkLuNd]

I don't think that you can use [man]mysql_num_rows[/man] on more than one query at a time, since you can only count the rows in one table with each command.
I think that you have to do something like this:

//run the query 
    $result_owner = mysql_query($query_owners);  

    //query Plots
    $query_plots = "SELECT * From $plots ";
    $query_plots = $query_plots. "and plot_details($thePlotID) LIKE '$thePlotID%'";
    $result_plots =mysql_query($query_plots);
    $results= mysql_num_rows($result_owner);
    $results2= mysql_num_rows($result_plots);
$item= 0;

[run2web]

I am figuring that out but I can't find a solution anywhere. I have been pouring over the manual for hours. :mad:

[rIkLuNd]

Well, look at my suggestion. Let me know if it fixed your problem!

[run2web]

No, now it is giving this error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/hagerstown1/www/HagerstownCemetery/report_admin_html_nu.php on line 371

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/hagerstown1/www/HagerstownCemetery/report_admin_html_nu.php on line 372

[rIkLuNd]

then I'm not sure what's wrong... 🙁
these errors are probably coming from the things I changed... By the way; What is it that you are doing with this script?!

[run2web]

Originally posted by rIkLuNd
What is it that you are doing with this script?!

I am trying to pull information from several tables (2 currently, 5 eventually) to allow internal searching of the database and create reports based on the search criteria.

It is for a cemetery :eek:

[rIkLuNd]

ok... 🙁

[rIkLuNd]

what do you want to do with the [man]mysql_num_rows[/man] query?

[run2web]

num_rows is used to count the number of rows in the query based on the criteria. I think that somewhere I am missing something that defines the number of rows but I can see it. Going to look at it with a fresh view today and maybe get somewhere. I am about to trash this one and start from scratch. :mad: