RE: [PHP-DB] mysql_num_rows

Hm, if the result you want is the number of distinct nodeid values, why not use a query like this: "select count(distinct(nodeid)) as nodecount from books where bookid = $bookid"; Then the number of nodeid's is stored in nodecount. You might also want to look into the GROUP BY clause. That might give you a better handle on what you want to do. At 12:09 PM 1/6/2002, Gurhan Ozen wrote:

I am pretty sure that the query is correct. here is the actual query:

                $query="select  distinct(nodeid), nodename  from books where

bookid=$bookid";

                $result=mysql_query($query);
                $num_results=mysql_num_rows($result);

I have loaded a book into the tabel called "books". I have gave each section a nodeid and each book a bookid. SO i wanted to get number of distinct nodeid's (i.e. sections) in the book so that i could use a for loop to display all of them and an inner for loop to display each page under each section. The funny thing is that if i write the same query without "where bookid=$bookid" then the mysql_num_rows works but with where statement it doesn't. By the way the web hoster i am using has PHP Version 4.0.6 . Thanks. Gurhan

Sliante, Richard S. Crawford http://www.mossroot.com AIM: Buffalo2K ICQ: 11646404 Y!: rscrawford MSN: underpope@hotmail.com "It is only with the heart that we see rightly; what is essential is invisible to the eye." --Antoine de Saint Exupéry "Push the button, Max!"