sql,query very urgent
-
hi, in my database i have the two tables... 1)programs 2)reserved in the programs...two fields 1)program id 2)maxseats................these details wil be entered by admin in the reserved table two fileds ..1)PRogramid 2)status my requirement is .. i need the available seats..means if any body is intersted in any program...they wil select the program...then status becomes approved(1).. then i need the o/p as available seats ..means if any body selects the program...then the maxseats should be decremented by 1...o/p should be the remaing seats..
-
hi, in my database i have the two tables... 1)programs 2)reserved in the programs...two fields 1)program id 2)maxseats................these details wil be entered by admin in the reserved table two fileds ..1)PRogramid 2)status my requirement is .. i need the available seats..means if any body is intersted in any program...they wil select the program...then status becomes approved(1).. then i need the o/p as available seats ..means if any body selects the program...then the maxseats should be decremented by 1...o/p should be the remaing seats..
I sincerely hope that you are not asking for code. Let us know what you've tried and where is that you got stuck with.
beklo.com/rameshgoudd wrote:
Subject:Re: sql,query very urgent
I am afraid that you are going to be taken in for a chance. :~
-
I sincerely hope that you are not asking for code. Let us know what you've tried and where is that you got stuck with.
beklo.com/rameshgoudd wrote:
Subject:Re: sql,query very urgent
I am afraid that you are going to be taken in for a chance. :~
hi, ' i need to count how many seats are filled up ..and how many seats are there at to be filled.. i am unable to write the query for this yyar
-
hi, ' i need to count how many seats are filled up ..and how many seats are there at to be filled.. i am unable to write the query for this yyar
What prevents you from using a simple count(*) on the table with the where clause querying an appropriate approved status value? Have you tried it first?
Vasudevan Deepak Kumar Personal Homepage
Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson -
hi, in my database i have the two tables... 1)programs 2)reserved in the programs...two fields 1)program id 2)maxseats................these details wil be entered by admin in the reserved table two fileds ..1)PRogramid 2)status my requirement is .. i need the available seats..means if any body is intersted in any program...they wil select the program...then status becomes approved(1).. then i need the o/p as available seats ..means if any body selects the program...then the maxseats should be decremented by 1...o/p should be the remaing seats..
beklo.com/rameshgoudd wrote:
very urgent
Please desist from using such words like 'Urgent' or 'Please help'. Read this first: http://www.codeproject.com/scrapbook/forumguidelines.asp[^]
Vasudevan Deepak Kumar Personal Homepage
Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson