Paul DuBois wrote: > >Am I making wrong?, is there some function just to retrieve qty records > >selected in a query? > > mysql_num_rows() is intended for SELECT queries. Its argument should be the > result set identifier.
Thanks , I checked again, and problem was exporting scripts from Windows to Linux. For Win, case charecrs doesn't matter, so my query was 'Selcet * from Category ' , but real name for linux (and windows) was 'category' (first char = lower case). This way I receive empty set when trying to apply mysql_num_rows() on linux, although working fine on Win. Anyway, after correcting this problem, I noticed that Mysql_Affected_Rows() works fine for SELECT also, retrieving correct number found rows , ( even manual indicating to be applied for UPDATE,INSERT,DELETE) , whenever Mysql_Num_Rows($set) returns always = 0. I don't know the reason for this problem, but at last decided to use Affected_Rows() instead Num_Rows($set) Thanks very much Miguel --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
