mysql_num_rows() http://www.php.net/manual/en/ref.mysql.php
:-) On 9/15/07, Chris W <[EMAIL PROTECTED]> wrote: > Mahmoud Badreddine wrote: > > it is more of a PHP question , I admit. > > I tried mysql_fetch_array, mysql_data_seek, mysql_result . Same result. > > And I am sure there's more than zero rows to be fetched, because it works in > > the first call, but not the second. > > > > That just means there is one row in the result and only one row. > > you should really print the query and then execute it using some other > tool to see the result, I would be willing to bet there is only one row > in the result. An error that has caught me more than once is having > another query inside the look and using the same result variable. > > > > -- > Chris W > KE5GIX > > "Protect your digital freedom and privacy, eliminate DRM, > learn more at http://www.defectivebydesign.org/what_is_drm" > > Gift Giving Made Easy > Get the gifts you want & > give the gifts they want > One stop wish list for any gift, > from anywhere, for any occasion! > http://thewishzone.com > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]