requinix

FFS dil_bert. This is one of the most requested mod_rewrite things in existence. Do you know what I'm going to say next? I honestly don't know if you do. Google it.

Is this file in some particular syntax? It looks like there's a format to it. Still don't know what "query_complaint_type_list" or "status_0" have to do with it, but the first step is probably to read the file into a PHP structure. Why bother? Just make it a .txt file and be done with it. Don't clutter up the file with stuff that doesn't belong.

Here is a good place to start.

Is that the actual way the contents of the file look? Because the file has a .php extension but that is not PHP code. I also don't see "query_complaint_type_list" or "status_0" anywhere in you example. Aren't those important?

Okay. Here's what you need to do: You need to show us the full version of the code that does not work. Talking about the stuff displaying at the top of the table doesn't help. Showing single lines of code doesn't help. Reiterating what works and what does not work doesn't help. Make sure your code is written so that it tries to do what you want it to do, then post the whole thing so we can tell you what's wrong with it.

I don't see where you output the success message.

Not according to the code you posted. Either your code is wrong and gw1500se is right, or I don't know because you haven't posted your real code.

What's the C++ code you're working from?

Get your members by seniority and assign them to teams in a round-robin way: first 6 are leaders, second 6 are assistants, and so on.

rocky@rockysMacBookPro ~ % php-fpm [21-May-2020 13:36:05] WARNING: Nothing matches the include pattern '/private/etc/php-fpm.d/*.conf' from /private/etc/php-fpm.conf at line 143. [21-May-2020 13:36:05] ERROR: failed to open error_log (/usr/var/log/php-fpm.log): No such file or directory (2) [21-May-2020 13:36:05] ERROR: failed to post process the configuration [21-May-2020 13:36:05] ERROR: FPM initialization failed Have you looked into that?

Think about your logic. If $number is 101 then it <>102, right? And if $number is 102 then it <>101, right? Also, please do what the rest of the PHP community does: use the && || != operators instead of AND OR <>. The first group is what you see in programming languages. The second group is what you see in SQL. PHP is not SQL.

Could be them marking as spam. Make sure your unsubscribe link is obviously visible at the bottom of the email. Consider disabling the recipients and sending them a one-time "are you still there" notification. For comparison, a spam rate of 5 in 500 is high. Note that spam and bounce reporting is another thing paid services offer.

You really should go for a paid service. Many of them bill based on volume and usage, not on a monthly or annual basis. Consider what it will cost you just trying to maintain all this email stuff. If you must do it yourself then you need to get a dedicated server/IP address and set up SPF and DKIM records for your domain. You also need to stay on top of your bounce rate to make sure that doesn't get you (temporarily) blacklisted.

$teamnaam = $lidnummer = ''; That's the only time you ever assign values to those variables.

How about posting the rest of the code instead of just that one line?

Make sure you're doing everything with the same encoding - preferably UTF-8. What operating system? IIRC Windows and Linux deal with it differently.

It's an Apache module. Look in your Apache setup to see if you have it.

Guess again. Too bad. Doesn't matter. Nobody cares what the names of your indexes are as long as you didn't manually name them something stupid.

Yes. Is it an actual foreign key as in you told MySQL it's a foreign key and there's now a constraint and index for it? No. Stop that. The ID is a primary key. It is unique by itself. Do not combine it with some other column to create a composite key. That's stupid and wasteful and did I mention stupid. Technically no, because if you don't then MySQL will do it for you. Which is what the documentation says, so either you didn't read the documentation or... well, that's it. I stopped reading your question when you mentioned the dumb composite key thing again, but the answer is probably either "no" or "don't do that because it's stupid".

No "programs". Use a third-party service.

Switch to a JSON data type for that column, deal with any invalid data that crept in, then create a VIEW that does the nasty work of extracting values and parsing strings and whatever. Then use the VIEW for your deduplication work.

Why are you storing JSON in there? Can you switch to a JSON data type? Does it have to be SQL to get the information, given that code could probably do it more easily?

A 500 means there's something wrong with your script. Could be a syntax error. But it's really hard to spot syntax errors when you only post "very simplified" code. Do you know how to configure php.ini settings on your server(s)? Change display_errors to "on" and error_reporting to -1. Then restart your web server and/or PHP and try running your script again. There should be error messages this time.

Do you have mod_security installed?

I think you're creating something far more complex than you actually need.