[thelist] something wrong with my SQL query

[rudy]

> You need to check (mysql_num_rows($result) > 0)

tom, if you just want to find out whether the category is being used,
you don't need return all the items like you're doing with this --

   SELECT item
        FROM menuitem
            WHERE categoryID =  $id

do this instead --

  SELECT count(*) as numberofitems
        FROM menuitem
            WHERE categoryID =  $id

this will always return exactly one row, so then you just test the count


rudy