Posts by Dani

Ewwies Davey, really sorry to hear that. But there's been some developments on my end ... last night, I bought a laptop!!!!!!!!!

Oh, I see, a skull. Nevermind :) Yeah, it's cached by your browser. Ctrl+F5 to do a hard browser refresh should fix the problem.

You have an avatar of a guitar? What is it supposed to be?

Bug fixed :)

Please email the file to me at dani@daniwebmail.com and I will try for myself. You shouldn't be getting that error message with an .xlsx file.

P.S. Attaching an image to this post just to make sure attachment uploading hasn't broken.

We currently do allow files with an .xlsx extension to e uploaded. What format was your spreadsheet in?

I currently don't have a laptop because I found that, after graduating college, the only time I used it was when I was sick in bed.

I'm a huge proponent of rich snippets and microdata. I encourage you to read and implement http://schema.org/ microdata on your site. It helps with SEO and also with site accessibility.

No, we stopped adding new forums in favor of tagging. Just create a new thread and tag it with "swift".

Oh, and also, would you be able to provide the email headers for the duplicates?

Thanks ... I'll reach out to James #1, but I believe he's feeling under the weather right now.

In your original post, you did not provide me with the schema for the customers table. I'm also still confused what format you want. Please give details of the customers table and explain what you want the output to look like.

Sure, just include those columns.

SELECT p.name, p.mrp, SUM(b.quantity), SUM(b.total), SUM(b.discount), SUM(b.price)
FROM billing AS b
LEFT JOIN productmaster AS p ON (p.id = b.pid)
GROUP BY b.pid
ORDER BY p.name ASC

I pulled a report of billing, grouping the results by matching pid, and summing up the other columns. Then, I simply did a left join to fetch the friendly name for the pid from the products table.

Sorry I don't understand your question?

You have a typo. It's billing.price. Not bbilling.

I'm just coming up with this off the top of my head (totally untested), but what about something along these lines:

SELECT p.name, SUM(b.quantity), SUM(b.total), SUM(b.discount), SUM(b.price)
FROM billing AS b
LEFT JOIN productmaster AS p ON (p.id = b.pid)
GROUP BY b.pid
ORDER BY p.name ASC

Do you use any PHP frameworks? They can cover the bare bones stuff such as dealing with URI routing (clean looking URLs), connecting to the database, and a template engine. Plus they have a lot of other built-in functionality. Pick the one that best suits your needs.

Yes. However, you probably meant ?page= and not ?ppge=

Huh?? What are you trying to do? Using a for loop? I'm incredibly confused. Is this a homework assignment?

What do you want us to do with your homework assignment??

Just replace the title with 'please delete' and I'll clean that up for ya.

When you create the login cookie, simply specify an expire time loooong into the future if the remember me checkbox is ticked.

OK fixed. Sorry about that.

Oh my goodness, you're right! I made some changes and it appears it works fine for me but not when I'm not logged in. Hold on I'll look into this ASAP.

Sorry for the confusion. Earnings next to months with a purple asterisk next to them are actually only estimated earnings. Earnings don't become available to cash out for about 45 days. So if you revisit that page next month, you'll be able to cash out.

Yes, rewards points can be cashed otu for real money which gets sent to you via PayPal. There's a link at the top of the page that says '$ Rewards' that brings you to this page, which shows how many rewards points you have earned:

https://www.daniweb.com/rewards/earnings

Once you have accumulated at least 500 rewards points, then you can cash out.

Do you know if the bug was ever fixed?

Thanks for the note. Bug fixed :)

You're a sponsor, and there was an SQL bug where it wasn't able to find people likely to be able to help you with that particular question, whom it should send a PM to notifying them.

Thanks, I'll take a look at it. Can you narrow it down to anything done differently??

You need a web server (such as Apache) that is capable of executing Python scripts.

Then, when I go to http://www.example.com/your-page.py the executed HTML appears, that my browser is able to render.

Define "crashed". Are you able to boot into Windows at all? Can you copy the file(s) you need onto an external USB disk from the older laptop and use that to transfer? USB disks can be bootable.

Social media, and focusing on having good, clean HTML 5 code that utilizes all the best SEO practices.

Looks like you're doing it a very different way than I did. I used OAuth.

Are you sure it stopped working at the exact time when you added more permissions?

Strangely, I used to use curl for Facebook OAuth, and suddenly that stopped working one day, and I had to switch to using file_get_contents().

Upvotes/downvotes are intended to be taken with a pinch of salt. Much more important is reputation points, which are only affected when someone actually comments as to what they like/dislike about your post.

A member for only a week, and already has 38 reputation points, ranks #546 out of over a million people, multiple skill and expertise endorsements, has a > 70% post quality score, only three posts currently voted down out of 43 total, and double the number of upvotes as downvotes. That's definitely a positive member profile.

Can you please provide a link to which tutorial you are talking about? That would be very helpful.

Hi there,

DaniWeb is actually built on the CodeIgniter MVC framework, and therefore we use CodeIgniter's routing functionality.

CodeIgniter also has a single index.php file that essentially takes in the name of the class and the name of the method, and then routes to calling the appropriate function.

RewriteCond $1 !^(index\.php|js|images|favicon\.ico|robots\.txt)
RewriteRule ^(.*)$ /index.php/$1 [L]

CodeIgniter just handles it from there!

That being said, I would not recommend CodeIgniter because, although I love it and they do have an expansive community behind them, EllisLab is currently looking for new owners to maintain the project on GitHub, and there hasn't been any major updates to it in quite some time. As a result, its future looks unpredictable at this point.

I like gimme.support too.

Thanks for the feedback. I've gone ahead and made the adjustment a little bit ago.

..i clicked my member badge while on my local dev machine. Is that where this could be from?

Yes :) It will go away shortly on its own.

I think this must be my fault from when I made the client secrets more secure awhile back. Try changing your secret and let me know if that does the trick.

https://www.daniweb.com/api/applications

Can you reproduce it, Jorge?

We did just switch to sitewide-https. However, you shouldn't be having login issues.

Prit, try switching all of the API endpoints to https. Did that do the trick??

More concerned right now with JorgeM who's saying he's unable to log into the site.

What a gruesome discussion!

DaniWeb gives you 'Sponsor' status for one month after each payment, regardless of how much the payment is for.

Is there a public URL you can give us of the online version to try out for ourselves?

Yes, Subscribe to Mailing List effectively lets you browse and reply to messages throughout DaniWeb entirely via email. It functions like one of those old school Listserv lists.

As long as you have receive community email checked, then you will receive email for articles that you watch.

You can watch/unwatch any article by clicking the button within the article. You can also view articles you're watching, and mass-unwatch articles that you're watching, from the 'watched articles' page (link in the header).

If you have your profile set to automatically watch articles you post in, then each time you post in a thread, you automatically begin watching it.