[miniature]

Hi, i'm new here.
I have a question:
---
I have this code:

PHP Code:

$query = @mysql_query("SELECT name, Count(*) FROM table WHERE name Like '%$q%'");     

echo "&nbsp;&nbsp;&nbsp;There's&nbsp;<b>" . $query . "</b>&nbsp;results for the query&nbsp;<b>" . $q . "</b>.\n"; 

This code count in how many rows the query exist.
How can I do that it count how many times the query exist?

Thanks,
Yoav.

[Nico]

PHP Code:

$nr_rows = mysql_num_rows($query) 

[miniature]

Your code doesn't work.

[Nico]

Oh, sorry! I misunderstood your question. My bad.

[NabZ]

try somthing like this...

$sql = "SELECT COUNT(*) FROM table WHERE name Like '%$q%'";
$result = mysql_query($sql);
$nabz = mysql_result($result, 0);

echo "Database Count: $nabz";

hehe. like the name of the var ey?

[miniature]

OK, thanks.
How can I combine it with a 'mysql_fetch_array' while query?

[miniature]

Someone?.. Please.