[SOLVED] Echoing number of results

[sted999]

Hiya all.

 

I am trying to query the database then display the number of results from the query. I have used an example from a book but it does nothing? Can anyone suggest what I am doing wrong?

 

Thanks.

 

		$query = "SELECT * FROM Journey WHERE startStreet LIKE '%$startStreet%' AND startTown LIKE '%$startTown%' 
				AND destinationStreet LIKE '%$destinationStreet%' AND destinationArea LIKE '%$destinationArea%' AND destinationTown LIKE '%$destinationTown%'
				ORDER by date LIMIT 100";

	$result = mysql_query($query);

	$num_results = $result->num_rows;
	echo "<p>Number of matches found: " , $num_results , "</p>";

[mmarif4u]

There are many ways to do it, one is count in your query, but here you can use:

mysql_num_rows.

$num_results = mysql_num_rows($result);

 

Let us know, it worked or not.

[wildteen88]

$result = mysql_query($query);

 

Should be

 

$result = mysqli_query($query);

[sted999]

Thanks for the help. Managed to get it working through mmarif4u approach.

 

Cheers guys