Member Avatar for kazitula

hi
I have got a table for "internet access" with user ID, it has 3 columns user ID, starttime and endtime, i want to make another column which will show how many mins or hours that user was logged in to the internet and also add the total time if the user logged in more than once. can anyone please help me...
thanks
kaz

  • 4 Contributors
  • 4 Replies
  • 140 Views
  • 7 Months Discussion Span
  • Latest Post Latest Post by Drlionheart

Recommended Answers

All 4 Replies

Member Avatar for debasisdas

i think simple subtract will do that for you.

Member Avatar for Juniour

i think simple subtract will do that for you.

Hi debasisdas,
i also have the same problem and have a mysql table with two columns 'purchases' and 'sales' and would like to have another column 'balance' which is the result of subtracting purchases from sales. I am newbie to MySQL, would you kindly explain more about the simple subtract?

I highly appreciate your help and anyone out there with good ideas.

Member Avatar for debasisdas

what you get when you try the following

select purchase,sales,purchase-sales as balance from table_name
Member Avatar for Drlionheart

Hi

I Suggest you that it will not work through SQL Query only.

You have to create Proceduers or Packages to Update users previous logging time.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.