Click here to Skip to main content
15,885,757 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
suppose i have two user one is ram and second one is shyam,
ram has one bill bill no is 24 he passed this bill and shyam return this bill so it will show automatically on ram user , please give me this query code
Posted
Comments
DaveAuld 15-May-14 6:24am    
Your question makes no sense, what have you tried yourself? People will not just give you code...
OriginalGriff 15-May-14 6:27am    
This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind.
Use the "Improve question" widget to edit your question and provide better information.
Member 10799106 19-May-14 4:31am    
tanks

1 solution

add a field "boolean" to your DB table,now with each bill generation set the value of boolean as 0
when a bill no is returned then update it to 1

so when ram passes bill no. 24 then its boolean is 0,hence it can not be given to shyam because when you are hitting the auto max bill generator then you are giving a condition as "where boolean=0".

:P
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900