maybe mysql cannot COUNT the result from more than 1 table, hence the mysql_num_rows function - but isn't it good programming practice to get the SQL to do as much work up front? --------------------------------- Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard