Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. notsoevilgenius

    Error Updating From mySQL To MySQLi

    Hello, I have a simple connect, query and display db rows that needs to be upgraded. Everything was working last week when I was last using my website now I'm getting errors because mySQL is finally dead. I now have <?php $db = new mysqli("$host","$username","$password","$database") or...
  2. notsoevilgenius

    Help Calculating Time Worked

    Got the first part working! <td><?php $t_total = strtotime($row['t_out']) - strtotime($row['t_in']) ; echo gmdate('H:i', $t_total);?></td> This returns the value of 1:05 as it should. Thanks for the help!
  3. notsoevilgenius

    Help Calculating Time Worked

    I'm now formatting correctly, but I'm still fine tuning the calculation - <td><?php $t_total = $row['t_out'] - $row['t_in'] ; echo number_format((float)$t_total, 2, '.', '');?></td>
  4. notsoevilgenius

    Help Calculating Time Worked

    Hi feherke, Yes, that's better. <td><?php $t_total = $row['t_out'] - $row['t_in'] ; echo $t_total?></td> I'm now returning a value of 1 in the table row. I should have 1.08. I'm much, much closer than I was a minute ago. Thanks!
  5. notsoevilgenius

    Help Calculating Time Worked

    I think I'm making progress. I've change the calculation to: <?php $t_total = strtotime('$t_out') - strtotime('$t_in') ; echo $t_total?> This gives me a value, but with $t_in = 12:00 PM and $t_out = 1:05 PM I'm getting a value of 0. Better than a blank... but still not correct.
  6. notsoevilgenius

    Help Calculating Time Worked

    Hello! My on again, off again database project is on again with new bosses. Now they would like to track time worked. I have a table with date, time in and time out. I need to calculate the hours:minutes worked and show them in the table: <tr> <td><?php echo date('m/d/Y'...
  7. notsoevilgenius

    Help to Compare New Sheet to Master and Update

    It's been a quite awhile since I had to do any VBA, but I have a new project. There is a master.xlsx with all the data on it. Each month the user downloads a new batch of data. 1. I need to compare the "Subscriber" columns (value is lastname, firstname) of the new.xls to the master.xlsx to...
  8. notsoevilgenius

    NEWBEE NETWORK SETUP

    Hello, I normally just do basic server support and mostly client computer support. Occasionally I have to make changes in configurations for something to work and I often do that with technical support of whatever hardware/software system I'm working on at the time. I don't do setups, but I...
  9. notsoevilgenius

    CSS Precedence - Can I override the CSS Style Sheet

    Thanks guys. I was getting close when I got pulled off this project for something else. I'll be back at it tomorrow morning. I know and I've told the client that. I don't know why this is such a big deal to her...
  10. notsoevilgenius

    CSS Precedence - Can I override the CSS Style Sheet

    Thanks! I'm now trying to narrow down where to massage the CSS. I've been looking the lines in the CSS - .container .column and .column .one-third. Now I'm not so sure that's where I need to be looking.
  11. notsoevilgenius

    CSS Precedence - Can I override the CSS Style Sheet

    Browsing around and refreshing myself with the rules of css precedents I'm pretty sure I'll have to effect changes in the CSS Stylesheet. Here's the CSS for governing the various devices /* Table of Contents ================================================== #Base 960 Grid #Tablet...
  12. notsoevilgenius

    CSS Precedence - Can I override the CSS Style Sheet

    I'm back trying to solve this issue in my ongoing shopify development. I have these three elements that are next to one another on a large screen, but drop under one another on mobile devices. The client doesn't want that to happen. <div class="one-third column alpha"> <a...
  13. notsoevilgenius

    Change CSS for Mobile Portrait

    I fixed this by changing the CSS code for min-width, max-width that the prior developer put into the HTML page instead of the CSS page.
  14. notsoevilgenius

    Change CSS for Mobile Portrait

    I forgot this part of the css /* #Mobile (Portrait) ================================================== */ /* Note: Design for a width of 320px */ @media only screen and (max-width: 767px) { .container { width: 300px; } .container .columns, .container .column...
  15. notsoevilgenius

    Change CSS for Mobile Portrait

    I have a friend that has a site on Shopify with is enough of a pain in the ass. This is what she has now... This is what she wants it to look closer to... She kept telling me she wanted the flexslider on the page to only show part of the image when displayed in portrait on a smartphone...
  16. notsoevilgenius

    Upload and append data monthly

    I have to develop a new commissions database. The data will come from a corporate company each month in xls format. The user will need to upload the sheet each month - from a simple user gui a. An automated process will have to strip out the data that doesn't pertain to the client (I'll use...
  17. notsoevilgenius

    Summarizing data from different worksheets

    I didn't name any ranges, but I was thinking I could go through and name the agents and totals, but doing that would probably take longer than the cutting and pasting. I think I'll have to grab two months of historical data (directly from the source data) to develop the process. Automating the...
  18. notsoevilgenius

    Summarizing data from different worksheets

    I just looked to see if I could just cut and past aug data under jun data and then sep under aug etc. That would assume the columns in all the worksheets are the same with the exception of new agents in which case I'd only need to use the column headers from the last month. The only thing we can...
  19. notsoevilgenius

    Summarizing data from different worksheets

    No, but that's the way I get it. The original workbooks are still intact. How do I consolidate it without typing (or cutting and pasting) 6 months of data? I want to avoid that. The client is a broker. Each month they log into each corp they sell for and download the monthly commission report...
  20. notsoevilgenius

    Summarizing data from different worksheets

    Hi Skip. Yeah, I knew this wouldn't be easy. I don't have an issue providing the user a consolidated table of agents with yearly totals if that's the easy way, but it has to be done by formula or code. I can run through the individual sheets and define name ranges if I need to as well. I already...

Part and Inventory Search

Back
Top