record count from ibase_query=("SELECT HOWTO FROM this.FORUM");

i only founded function that can tell me how many fields are returned in dataresult , but how to detect how many records i hav received in result set

thanks, for helping

I may not have your question right, but to determine how many records your database search returns, use this:

$sql_count="SELECT * FROM ..."; // database query

$result_count=mysql_query($sql_count); // counts results

if (mysql_num_rows($result_count) >0 ) { // there are results
do something

} else { // if there are no results
do something else

}

how 'bout:-

$result=mysql_query("SELECT COUNT(*) FROM ...");
$num_records=mysql_fetch_row($result);

SORRRY PEOPLE, i am USING INTERBASE, not mysql

if i want to get count of records, yes i also use
select count (ID) from TABLE

it is right but,

my uqery get into result dataset only fields with data

some people told me that i must to use this

$var_first=select count(ID) from table_1
$var_second=select (ID) from table_1

this people told me that i must to use two same sql querys , into first var i get count, and into second var i get real data

it is not right !!!!

my php script must send two same querys but with different results,,,

also for this situation is only one way, STORED PROCEDURE,
because two querys executes on the server side and speed is more better

but in stored procedure i also dont want to use two queries like

1) select count(TT) from table TT into :variable_record_count;

2) select (TT) FROM table TT INTO :variable_real_data

why in ibase i cannot get returned record count ???

what is the reason, that ibase developers dont include this function ???

thanks for helping