[Db] Domandina semplice

[Marcello Vezzelli]

graz wrote:
> $result= mysql_query("SELECT * FROM tabella WHERE segnalato ORDER BY nome
> ASC limit $start,$rec_pagina");
> Poi per calcolare il numero ho usato:
>
>
> $num_segnalati= mysql_num_fields($result);
>   

Devi usare mysql_num_rows per una select.

Dal manuale php:

int *mysql_num_rows* ( resource result )

Retrieves the number of rows from a result set. This command is only 
valid for statements like SELECT or SHOW that return an actual result 
set. To retrieve the number of rows affected by a INSERT, UPDATE, or 
DELETE query, use *mysql_affected_rows()* 
<function.mysql-affected-rows.html>.



Ciao
Marcello