Search results for query: *

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...

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!

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>

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!

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.

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'...

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...

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...

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...

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.

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...

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...

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.

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...

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...

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...

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...

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...

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...

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...