Congratulations to all monthly winners of May 2013 !!! They have won INR 2900 cash and INR 27497 worth prize.
DotNetFunda.Com Logo
Twitter TwitterLinkedIn
YouTubeGoogle
 Online : 12418 |  Welcome, Guest!   Register  Login
  Home > Community Home >

Pulling Data..MySQL

  Posted on: 5/16/2012 10:18:03 AM | Views: 6

Recommend an Articles | Recommended Articles | Search Resources | Community Home |


Advertisements


Hi,
I need some help that relate to database and if...else statement.
Below are the thing that i want to do,
a.pull the latest data from database
b.check whether start_time and end_time got value
c.if end_time got value means the student done her exam ard, system will show label.text="End"
d.if start_time got value but end_time is empty, this means the student still in exam, system will return label.text ="Start"

Below is my database,
column Name    column Starttime     column Endtime
Jenny               1/5/2012 8.00am    1/5/2012 10.00a.m
Alan                 2/5/2012 9.00a.m
Can someone guide me how to code the above problem?
Thanks.SmileGo to the complete details ...

Found interesting? Add this to:


About Us | Contact Us | The Team | Advertise | Software Development | Write for us | Testimonials | Privacy Policy | Terms of Use | Link Exchange | Members | Go Top
General Notice: If you find plagiarised (copied) contents on this page, please let us know the original source along with your correct email id (to communicate) for further action.
Copyright © DotNetFunda.Com. All Rights Reserved. Copying or mimicking the site design and layout is prohibited. Logos, company names used here if any are only for reference purposes and they may be respective owner's right or trademarks. | 6/19/2013 3:58:14 AM