how to do faq page ..pls help

Discussion in 'MySQL' started by kcm4web, Apr 2, 2010.

0
  1. #1
    Hello Gurus

    i have a faq page . where admin will create faq category .after that admin will post questions to each faq category. but problem is that when admin delte the faq category it should alert him that " pls delete the question first then delete the category" i dont know how to do this. pls any body help me??
     
    kcm4web, Apr 2, 2010 IP
  2. killaklown

    killaklown Well-Known Member

    Messages:
    2,666
    Likes Received:
    87
    Best Answers:
    0
    Trophy Points:
    165
    #2
    get the # of rows that belong to that category...

    
SELECT COUNT(id) as cnt FROM tablename WHERE category='ID'
    Code (markup):
     
    killaklown, Apr 3, 2010 IP