Click here to Skip to main content
15,122,845 members

Comments by W Balboos, GHB (Top 200 by date)

W Balboos, GHB 3-Jun-21 9:57am View
   
Radio buttons are used so you can limit selection to one of some number of elements.

For what you're doing (what if more courses are added) you'd be much better using a <select> list. As you add elements you don't have to change the page format because you don't have to add more radio buttons.
W Balboos, GHB 2-Jun-21 8:01am View
   
Regardless of whether a tag close is implied or not by the language, it is EXTREMELY SLOPPY style to not close tags properly. It will come back to bite you before long.
W Balboos, GHB 14-May-21 15:58pm View
   
You see to have the feeling that Mr. Schmitz owes you a solution. You are asking him - and all who read this, for help you . . . for free, too.

From your series of questions on this same subject it seems you want it done for you: ideas then code. Posting a nasty reply won' get you much help.
W Balboos, GHB 11-May-21 9:00am View
   
Considering how you are using it, you may as well (and would be human-readable better off) if you used and identity field instead of the unique identifier. The same value appearing in both tables . . . it's obviously not unique!
W Balboos, GHB 6-May-21 9:49am View
   
No code - how are we supposed to know where a problem is. Are you really sending the data? Is it really being received on the server side? Is your SQL correct to insert the data into the database (and is the table field designated for it correctly defined) ?
W Balboos, GHB 5-May-21 10:23am View
   
I will say it again: what is the level of the class you entered since you should be in a beginners class. And also, when did classes start? I don't know where you are located but in most of the world the university year starts in September.

No one here will do your work for you so figure out something else. Or maybe study subjects for things you like to do.
W Balboos, GHB 5-May-21 10:12am View
   
What are you doing in that class? If it's not a beginners class then you don't belong there. If you don't learn to do your own work and learn how to learn you are starting your career as a failure.
W Balboos, GHB 3-May-21 7:26am View
   
Do you want the type='submit' on that button - submit is for forms and is looking for an action. Perhaps try a plain button with 'submit' merely displayed text?
W Balboos, GHB 30-Apr-21 14:07pm View
   
This is a re-post - DO NOT POST THE SAME QUESTION MORE THAN ONCE!
If you need to, fix the original.

Also, you php/HTML mixture is an extraordinary mess and likely will not work the way you think it will.
W Balboos, GHB 29-Apr-21 9:10am View
   
Actually I'm having a hard time finding the php in you code.
W Balboos, GHB 29-Apr-21 8:05am View
   
I wasn't even going near indices. Just the simple coding with a bunch of like clauses that may or may not have content along with the %'s vs. building the query piece-by-piece and just not adding the WHERE bits that aren't used.

That second path became necessary for one of our queries, indices and all, but it was heavily but necessarily over-stuffed with optional user filters. Even then, it took a while for the tables to grow large enough for it to show (i.e., a timeout). It's been preemptively applied to a few sister queries.

Mostly, tuning is done with indices and such. My boss (DBA) knows the inner workings and fixes these. Mainly, there's a boiler-plate root design because we most of this is done by the two of us - SQL mainly by him - and productivity takes a back seat to performance at times - since no one else, here, can do this.
W Balboos, GHB 29-Apr-21 8:04am View
   
Deleted
I wasn't even going near indices. Just the simple coding with a bunch of like clauses that may or may not have content along with the %'s vs. building the query piece-by-piece and just not adding the WHERE bits that aren't used.

That second path became necessary for one of our queries, indices and all, but it was heavily but necessarily over-stuffed with optional user filters. Even then, it took a while for the tables to grow large enough for it to show (i.e., a timeout). It's been preemptively applied to a few sister queries.

Mostly, tuning is done with indices and such. My boss (DBA) knows the inner workings and fixes these. Mainly, there's a boiler-plate root design because we most of this is done by the two of us - SQL mainly by him - and productivity takes a back seat to performance at times - since no one else, here, can do this.
W Balboos, GHB 28-Apr-21 14:48pm View
   
Instead of "YES" I use a date-time stamp. I also separate the jobs (clients), freelancers, and the responses into separate data tables instead of perhaps on with longer rows. A response record, the table I mentioned, has a reference to client, freelancer, and the date/time if and when they respond.

You could even use this to resubmit to multiple freelancers until the double-yes is achieved and, once this is achieved, remove from active use any other references to the task. That is to say, a job is offered until it is accepted (common sense). You could even add another level and further separate your data by removing the task information from the client and just referencing the client with it. Now you can have a client list, freelancer list, task list that references the client and finally the responses that uses a combination of the first three.

I've got to go, now.
W Balboos, GHB 27-Apr-21 14:12pm View
   
As you will be told, at least on this website, time and again: What have you tried? We're not here to do your homework - it's given to you so you struggle a bit and finally learn how to not only do the task but how to do other new tasks by learning how to learn.

SO - show us what you've done.
W Balboos, GHB 26-Apr-21 9:14am View
   
And what have you tried to mirror it (show code)?
There graphics available via javascript, as well, like SVG.
W Balboos, GHB 23-Apr-21 9:11am View
   
You say you tried it but I don't see it in your CSS . How can I determine what's wrong if it's not there? The link I included explains z-index. Make yourself a test page and experiment with it until you understand.
W Balboos, GHB 23-Apr-21 9:09am View
   
Deleted
You say you tried it but I don't see it in your CSS . How can I determine what's wrong if it's not there? The link I included explains z-index. Make yourself a test page and experiment with it until you understand.
W Balboos, GHB 15-Apr-21 15:13pm View
   
I was going to add, and maybe should have, that this might be some of the kindest advice he gets. I understand you took it as a berating but it's also a wake-up call. I didn't call him stupid or anything like that. It may be someone who is on the wrong life course - possibly pushed into it by parents or friends.

I'll try to soften it, but shouldn't there be some way of telling the poster that maybe they're in the wrong field?
W Balboos, GHB 13-Apr-21 7:13am View
   
It has been over four months since you first posted this and you still seem to have tried nothing. If this is important then maybe you should hire programmer.
W Balboos, GHB 11-Apr-21 17:36pm View
   
Glad you solved it - for future reference:
If you get a solution that works the mark it "accepted" to close the question.
I understand your confusion. The "Solution" area is for solutions offered to the problems and not posting your solution to your own question (even though it seems to make sense). If you wish to post it, you can Edit your original, or, more commonly, put it in the comment thread of the solution that worked.

No harm done - but do remember to mark the Solution (Solution 1) as "accepted" to close the question.
W Balboos, GHB 11-Apr-21 17:32pm View
   
First, that's not quite javaScript - it's jQuery (which I do not use).

However, it's great that you worked it out. You get two lessons out of it. One is the techniques that worked are now deeply learned. The other is the way to test you code to find out where it goes wrong (if you don't have a debugger then you can use alert() in javaScript and similar things in other languages).

Now - one thing to remember (here and in the future): if you get a satisfactory answer in Q&A then mark it accepted so that the question is marked "solved" and helpers can put their help into new questions.
W Balboos, GHB 9-Apr-21 9:36am View
   
The best option is for you to make a very simple page to work out what you're missing. Create two lists - only a few hand-coded entries each - where the values for both lists correspond. Add the onchange event.

If it works then you can look for error in your original - if it doesn't work on it until it does work and then update your original.

ALSO: in the function for the onchange event, put in an alert(val), especially if it doesn't work, to see what is actually being sent to the function. Also lets you know if it even gets to your function. You can even try this in your original version. Just have the alert() and comment out the document.getElement...().value.
W Balboos, GHB 5-Apr-21 13:11pm View
   
Your instructor is being paid to instruct - ask him or her to do so.
W Balboos, GHB 5-Apr-21 10:04am View
   
Quick Hint: make your query first - then, once it's working correctly plug it into your code.
W Balboos, GHB 31-Mar-21 7:41am View
   
How ought we figure out anything when we don't have any of your actual code?

I cannot speak for ASP.NET, but CSS is not "glitchy" in this way - there is an error, somewher, perhaps other members of your CSS class (no way we can tell).
W Balboos, GHB 25-Mar-21 9:03am View
   
At his point, without seeing your data, I cannot go further. It may well be it is giving you the correct answer for the data you have. The UNION (even without DISTINCT - it's implied in UNION) supplies only unique records.
W Balboos, GHB 25-Mar-21 6:26am View
   
You do not need to run it twice with what I posted for you. It gets them all in one shot so if you run it twice each one will give them all and you get two of each!
W Balboos, GHB 24-Mar-21 10:10am View
   
Really? Twelve months? And, so far as your posting goes you have nothing to show for it?

If you want to be a programmer then you're not showing anything like realistic effort or (not intending to be mean to you) absolutely zero aptitude.

From an earlier question you posted you state " I have tried every tutorial but still have problems." - and it leads me to likely two conclusion:
1 - You're really in way over your head in attempting to write a program, even a web program
or
2 - You're trying to milk the work out of others, piece by piece, so you don't have to do anything yourself.

I'm done.
W Balboos, GHB 24-Mar-21 9:29am View
   
As you said, yourself "I have not tried anything yet, still confused on what to do. I have only made a regular table so far". You telling what you would like is not the same as you having actually put in anything like real effort. Your description "my effort" - does that mean your part and the remainder is for someone else to do? At best, you entered data - and created a wish list.

Do you even know how to code? If so - what have you done? If nothing, as I've said, come back after you have so we know it's worth some of our time because you think it's worth your time.

W Balboos, GHB 23-Mar-21 7:30am View
   
It seems like your asking us to supply you with the whole point of your assignment. You need to learn how to dig this stuff out of the internet. Just typing in code will not take you far in programming.
W Balboos, GHB 22-Mar-21 7:49am View
   
You have obviously missed your calling - time for that career change?

If not Shakespearean theater, perhaps kiddy show host?
W Balboos, GHB 5-Mar-21 9:53am View
   
Look at his code:
"var txtNewInputBox = document.createElement('div');"
and then
"// Finally put it where it is supposed to appear.
document.getElementById("newElementId").appendChild(txtNewInputBox);"

and finally you look at what he has tried - well look where the target for the string is being mapped:
"txtNewInputBox.innerHTML = "

Do you see it? NOT an element per se, but an object gotten from creation of the new node (element). For all practical purposes it can be anywhere. It doesn't need an ID or NAME attribute. The reference to the node was already created. His point is to give a NAME and ID to the element he just added to the DOM.
W Balboos, GHB 5-Mar-21 7:30am View
   
Your solution ignores his methodology - which is to create and add child-elements. Why do you think I didn't do the obvious and simplistic method you chose? Your route isn't very useful unless the original exists and has an ID of its own for the innerHTML method. Right answer to the wrong question.
W Balboos, GHB 5-Mar-21 7:26am View
   
In which case I gave the second version using "myObj" where it doesn't need the ID.
W Balboos, GHB 4-Mar-21 15:09pm View
   
So where's your php? All I see is javaScript.

That, and of course, you already posted this question and had an answer.

Are you hoping someone will do all of this for you?
W Balboos, GHB 3-Mar-21 14:29pm View
   
Well - it certainly wouldn't be the first posted code to have an error. Or maybe you're missing something?

OK - I don't know what the page is all about but suppose that $def['id'] is supposed to be $_SESSION['id']? Where would it get any $def values from, anyway?
W Balboos, GHB 3-Mar-21 13:12pm View
   
When you say it 'Im not being able to get pass through that "if" ', do you get an error message? I'd imagine it could say something like 'undefined index' or undefined for $def, itself? You've got to describe the error.

You could try print_r($def) and, if it's defined, it'll show you all of the members of $def array. If it's not defined then it will give an error of its own.
W Balboos, GHB 2-Mar-21 7:51am View
   
https://www.w3schools.com/jsref/met_win_open.asp
On this page you'll see an example of opening a child wind, how to make sure it's in a different tab, and, at the bottom, the return value
"Return Value: A reference to the newly created window, or null if the call failed"

You can use that reference to access things within the window you created from the window that created it. NEXT, look at the examples on the page - they show you how one page can put data on another.

Note: if you find your question answered, here on the Q&A, then please remember to mark it answered with the answer you have used (to help others in need and save the time of helpers who will know it's done).
W Balboos, GHB 28-Feb-21 14:44pm View
   
My first learn/exporsure to databases was a book with a title like 'database programming with C++ in 21 days'. All the examples seemed to be for FoxPro and finally I emailed the author on how the others stuff is done - and he admitted to me he didn't know how to use any other databases.

That, even with as written tutorial, should be instructive to you in its own right. Also, that entire book series isn't worth a used piece of bathroom tissue.
W Balboos, GHB 26-Feb-21 10:58am View
   
I do not write code for you - I tell you what needs to be done and possibly things to consider. You will learn nothing if I do it for you.

Telling you the methods to use has given you the answer. Computer programming requires effort - at least if you really want to do computer programming.

Think about why I picked out those two methods - how will they help? Solving problems takes practice - not google.
W Balboos, GHB 25-Feb-21 6:39am View
   
Actually, no samples beyond what you got in the previous email: <br>. You need to dig in and figure it out - and thus learn from this.
W Balboos, GHB 24-Feb-21 9:21am View
   
There are other ways in HTML to make a space:
Margins, for one, and <br> for another
W Balboos, GHB 19-Feb-21 8:16am View
   
So, you have an ADD button and onclick='addEmployee()'

And what happens in that function? Are we to guess? Considering that the contents of that function (at the least) are critical to the form doing anything at all, perhaps you should enlighten us!
W Balboos, GHB 12-Feb-21 13:47pm View
   
For completeness, could you also add the "ANY" key to the switch?
W Balboos, GHB 28-Jan-21 9:23am View
   
As a general rule, no one here will click on your link and risk the virus/malware/etc. attack that may occur.

Give code.
Give error message if any.
W Balboos, GHB 7-Jan-21 11:08am View
   
Aside from agreeing with those first two comments, I have found that when I start a session it is best put on the same line as <?php
W Balboos, GHB 30-Dec-20 9:15am View
   
Now I'll ask you a question!

Extra functionality: does that mean features not part of CSS3 or just different ways to access them? Like jQuery not really adding to javaScript but just wrapping parts of it up as simplified access features?

If it does, indeed, supply unique functionality I'd keep away from it, myself as it would lock me into Microsoft's environment. A beauty of web development is that it crosses O/S boundaries effortlessly.
W Balboos, GHB 30-Dec-20 8:52am View
   
My sympathy for having a client tell you how to code.

I'd do a typical problem isolation by rolling back to the simplest level and then incrementing forward.
First - put the style in the element via a style= attribute and make sure that works
Second - go back to your sheet but change it from a "#" declaration to "." and then add that class as an attribute to your element first, as a in-file declaration and then via your external style sheet. This also checks your path!
Third, - go back to "#" if you think it necessary.
Finally, when all of the above are satisfactorily settled, return it to SASS.

If it works - done - you probably found an error somewhere. Done.

If it doesn't work, SASS is the enemy. Have you ever used it before? I have not - my editor is not VS, but MS Expressions 4 (obsolete, simple, and obedient). Do you have a simple and working SASS page for comparison?

Just break it down to small pieces and isolate the problem.
W Balboos, GHB 24-Dec-20 12:05pm View
   
One problem is using a framework - and now you exchange some ease, up front, for a loss of true flexibility and control. That's your choice.

The solution you posed is, essentially what my second paragraph says: use the returned array and index through it adding items that are correlated via the index.
W Balboos, GHB 22-Dec-20 14:13pm View
   
That depends a lot upon what you want to do with it.
AJAX returns are always as an ECHO of some string. It would also need a target element for the data or some other use - and that really depends upon what you're doing with the data. See https://www.w3schools.com/js/js_ajax_intro.asp for how to use AJAX - but beyond that

it's really up to you to return the data (as a character string!) in some manner. If you want to return the array then you can use JSON, as well, with the AJAX.
W Balboos, GHB 22-Dec-20 7:05am View
   
If/when everything's working, mark the question "answered" so it doesn't get unnecessary attention.
W Balboos, GHB 21-Dec-20 15:48pm View
   
That's small enough to download the entire table. I talk about the arraylist object because you can access elements of its (changing) length via a random function of your choice and remove it from the arraylist. Pick another, etc.,etc.

Not via random access, but I've downloaded some rather larger arrays from SQL to javaScript on the page and used it to page through a table some fixed number of records (forward, backward, wrapping). A thousand is very small vs. a beta test of the paging we conducted with 50Kb data.
W Balboos, GHB 20-Dec-20 9:30am View
   
Adding/removing a sting in php code is generally very simple - that you have to ask means you probably wrote little of the code your using - maybe none.

If this is a problem for you then you should think about learning the languages before you mess around with the code.
W Balboos, GHB 18-Dec-20 13:38pm View
   
/ Check if $myList is indeed an array or an object.
if (is_array($myList) || is_object($myList))
{
// If yes, then foreach() will iterate over it.
foreach($myList as $arrayItem){
//Do something.
}
}

Makes the error go away. Think: that means it doesn't try to execute the foreach() loop. That means the it failed both of your conditional tests. And if you think about it, that is why it fails in your program.

Check to see if you're actually putting data in $myList before you try to loop through it. If it has no data (but exists) it may be null or an arbitrary value.
W Balboos, GHB 14-Dec-20 7:52am View
   
What you posted, above, does nothing to help solve the problem.

Depending upon the server, file names may be case-sensitive.

I don't know where your files in in what sort of folder structure: you do. If a file cannot be found it is because what you are asking for is not there. Find out what's wrong with what you are asking for: Where is your page, where is the not-found page it wants to open? Exactly how is it spelled?

Now it also seems, with that copyright notice, that you copied the code from somewhere - Maybe you should figure out what it does and what it need. PERHAPS YOU DIDN'T COPY OVER THE FILE IT NEEDS SO IT CANNOT BE FOUND BECAUSE IT IS NOT ON YOUR SYSTEM.
W Balboos, GHB 13-Dec-20 16:46pm View
   
I think his problem is that 'Nothing" is case sensitive.
W Balboos, GHB 8-Dec-20 6:54am View
   
Just a question on what may be a matter of taste.

When I'm incrementing through an array, for example, that needs to restart at the beginning when it reaches the end, I use modulo division and don't bother with the conditional. (such as
colorIndex%=colors.length;
in this case).

Any opinions?
W Balboos, GHB 4-Dec-20 7:43am View
   
You say you had a "hard time to find the right answer". I am hoping you're trying to learn to program. You shouldn't be looking for "the right answer". You should be looking on how to create an answer. How to do some specific thing - which is learning how to do something you can use again and again.
W Balboos, GHB 1-Dec-20 7:47am View
   
I pulled it from near the top of the list - it was apparently updated that day. So, by who? The OP, perhaps? Someone pulled it back to the unanswered cue's top with the update.

Maybe they were still waiting!
W Balboos, GHB 25-Nov-20 8:57am View
   
You don't have any time anymore?
How did you spend your time between when you got the assignment until now?
W Balboos, GHB 11-Nov-20 7:03am View
   
My stuff, at work, is mostly absolute or semi-absolute. The latter, div elements that that contain internal components that are absolute and it's location . . . depends. This came about, initially, because the workplace was split between FireFox and IE7 (at first) - now it's just FireFox but in order for me to pages work I turned to absolute positioning - and got quite used to it.

Since all my pages are born from php, I have the convenience of making pages that can calculate spacing/positions so everything always fits.

You don't have to declare your positioning type for every element. Now I do realize that % is very tempting. I've found certain other style don't seem to work without a real value. I live in px land but some new ones exist that I really should look into.

There's no simple answer: I just found https://web.dev/min-max-clamp/ and it would seem to be able act as an alternative to the media styles, each with different values. Some places give "best practices" - I say - you're own experience and way of thinking will create your own practices. I love tables - and don't give a crap that they want you to use div's, instead.

You've got to play around with this stuff until you develop your instincts (really knowledge that just flows).

Last thing: for this or any Q&A: if you get your answer mark it 'accepted' so it doesn't keep getting attention.
W Balboos, GHB 8-Oct-20 9:21am View
   
Just a thought for you - maybe it will save you from further searches and inquiries:

If a blog could be done much more simply, as you'd wish to do it, wouldn't that be something already done and tutorials available?
W Balboos, GHB 30-Sep-20 6:45am View
   
I can give you one comment, a bit peripheral:

Letting your users do this is a recipe for disaster - unless they're already quite astute with database usage. You'll still get your calls, only now, after their debauchery, you'll have a mess to clean up as well and will end up doing what they did so it works.
W Balboos, GHB 16-Sep-20 8:18am View
   
Toxic or thoughtful?   your question, if this was truly your purpose, was to bait someone into a negative response for a strong implication of laziness. Find someplace else to be with others who think their first impression should be negative.

However - if you feel it's toxic (indeed, I hope you do), you are welcome to leave. I'm sure stackoverflow will greet you with a hug and a kiss.

The response you want is the response you got - and . . . you're welcome!
W Balboos, GHB 13-Sep-20 15:17pm View
   
Here's how you convert multiple related rows in a table to a single row.
SELECT A.commonality, A.val, B.val, C.val
FROM ATable as A
INNER JOIN ATable B
On A.commonality = B.commonality
INNER JOIN ATable C
ON A.commonality = C.commonality
-- The WHERE clause, although optional in theory will be necessary
-- to pick up the data you actually want
WHERE A.something is something
AND B.something is something_else
AND C.something is another_thing

Another point: if you will not always get a match for all columns and you want the results anyway then you will need to do things like LEFT JOIN or RIGHT JOIN to pick up the sets that are incomplete. Now if the value isn't always present for all of the 'columns' you are making they'd still show with a NULL for the missing values.

Experiment on something simple - once you get it you'll know the power!
W Balboos, GHB 10-Sep-20 12:43pm View
   
I don't use vue or know anything about it. I use straight javaScript and straight php (HTML5, CSS3) - in other words, I'm independent of the whims of those who build these frameworks. You can pick up PHP pretty quickly at W3Schools if you don't already know it.

It (like javaScript and so much else) like 'C' - and even shares a lot of the same name functionality. I'll give you one heads=up to be very careful about.

If you start a PHP session, the session_start() must be the absolutely first thing on the first line - once other "headers" are sent you cannot start it (you'll get an error). Start the session on every page you wish to be aware of the values.

Finally - if you think all is well, mark the question as answered so it doesn't distract helpers from helping others.
W Balboos, GHB 9-Sep-20 15:40pm View
   
somehow got popped to the main part of he list of active questions - makes it easy to overlook the dates. Hopefully he's enjoying driving his ice cream truck.

It was updated 10 minutes ago (!).
W Balboos, GHB 4-Sep-20 10:25am View
   
So, for lack of more information, it sounds like you copied a lot of code from online sources and want one of us to assemble it for you into a working project ?

Start here: https://www.w3schools.com/php/default.asp . Everything you need to know is there. With examples. If you need their SQL/MySQL tutorial, as well, it's there.

Post back with real problems based upon your own work (copy/paste from online sources does not count as work or a "what you tried".)
W Balboos, GHB 28-Aug-20 7:12am View
   
No - it would be going back (or forward) through the tab's history. Assuming, of course, you don't modify the history, first.

DOM can control the content of a page and also send you to new ones - I guess it may be whether or not you consider location, history, &etc part of DOM of javaScript.
W Balboos, GHB 12-Aug-20 8:05am View
   
A long-term hint: if you give it proper thought, you can set up your numeric array indices so that they actually identify the data. This is particularly easy in php since you can declare an array element without having to create the intermediate ones. An example would be using the year as an index dimension, then at the next level, the month (etc.). This way, if you had something you needed to put into January 1984 you could have an array element: stuff[1984][1]

Since it is php, you don't need to have empty useless ones such as stuff[1492] but you could create it at any time if you need it.

The idea is the value gives the index - you don't have to search: it defines itself.

Don't forget: if my or some else's solution solves your problem mark the question answered.
W Balboos, GHB 11-Aug-20 10:21am View
   
OK - then do just that: replace the dummy array entry, when you have a real one.

One thing you might want to do is to not have one big giant array for the whole week. Why not the same array for each day array and have each day in a member of the day-of-week array?

But you need to learn more about array handling in php - it's really easy but you absolutely MUST learn this!

Start here: https://www.w3schools.com/php/php_arrays.asp and don't miss the link to the various array functions (PHP Array Referenc) you can use along with just directly accessing members. https://www.w3schools.com/php/php_ref_array.asp

My style of responding is to not "give away the answer" but guide the user into to to get the answer - to lean - so they can do it themselves forever after,
W Balboos, GHB 30-Jul-20 13:53pm View
   
I gave you a link for tutorial help. Also, the major hint "subquery" which can be used to control what you see in, for example, your WHERE clause. SUBQUERY - a lovely thing sometimes.
W Balboos, GHB 30-Jul-20 13:13pm View
   
I have to assume you can do the following:
Write a SELECT query requesting the MAX() of some value
Write a query that can ORDER BY some value in DESCending order
Write a query with a SUBQUERY and understand the comparison operators such as <,>, =, != (etc).

You may wish to look into a tutorial as all of these are pretty basic:
https://www.w3schools.com/sql/default.asp
W Balboos, GHB 2-Jul-20 8:31am View
   
Maybe you're looking in the wrong spot.

Where do these dated come from that fill your table? If it's a database you have the ability to do this server-side.
W Balboos, GHB 12-Jun-20 8:01am View
   
Why not make your life a lot easier and use a simpler editor for your website - no inteference from VS and all of it's defaults and background handling.

I use Expression Web 4 - a now FREE Microsoft product. It understands (i.e., autocomplete) HTML, CSS, javaScrit, php . You save text files to the place you want to save them. If you create (or add) your files to a "website" in VS it handles searches and interconnected changes nicely.

It's simple. You get to know more of what you're doing.
W Balboos, GHB 11-Jun-20 9:00am View
   
No - I'm very simple about this. You can build a query string in a loop so it handles each of N components.

Another way: create a #temp table with on substring's match results. Then deleted from that table all that do not contain the other substrings.

That's really the same net result as the bunch of AND'ed LIKE clauses.

Nothing mysterious - straight up direct. If I were doing this I'd be building my string in php (or C or C++) and sending it to the server already built.
W Balboos, GHB 11-Jun-20 8:38am View
   
The splitstring results, in a series LIKE .... AND LIKE ... seem like they'd do the trick. AND's force all the matches but anywhere in a string would do it for each.

You need to build the QUERY dynamically based upon the number of elements in your split-string results (or should, it' makes a better exercise)
W Balboos, GHB 10-Jun-20 7:43am View
   
You still haven't said what's wrong - did you try anything and get an error? What was it? If you don't get an error message, what is happening? If you don't see an error message then you need to see what your SQL looks like - it all may be working and your asking it to change something that's not in your table.

Does any of it work?


You can't expect me to rewrite the entire section for you.
W Balboos, GHB 14-May-20 11:47am View
   
As a free bonus help: if you are using an indexed data type, like your $row[], you need to wrap it in curly braces if it's within a double-quoted text string.

Like this: $text = "My name is {$row['name']}";
W Balboos, GHB 3-Apr-20 8:56am View
   
How will your code know who-is-who? How do you know who-is-who? - use that information to differentiate you from not-you. Store each players "me !" information with them. PHP Session variable? Local Storage? Whatever is appropriate.
W Balboos, GHB 31-Mar-20 13:06pm View
   
That link I gave you to W3Schools - they have a MySQL Tutorial, as well. The rest follows what I answered, initially.
W Balboos, GHB 10-Mar-20 9:14am View
   
Someone had to do something to push it up towards the top of the list - although in this case I think I agree with you. Well - at least now it's off the list.
W Balboos, GHB 6-Mar-20 10:45am View
   
Well someone posted this in your code sample,above:

"select * from Kitaphana" - my suggestion? Maybe try to learn some SQL before you try to use it.
W Balboos, GHB 6-Mar-20 9:10am View
   
To read one column you use it's name instead of '*'. You can list whatever columns you want, combinations of them and many other things - but '*' just means show me all of them.
W Balboos, GHB 5-Mar-20 7:53am View
   
Tell me - would you use a youTube video before doing your own dental work? How about fixing an automobile transmission?

Go here: https://www.w3schools.com/js/default.asp and learn the language - it's done in a very relaxed manner with the ability for you to try things out. You didn't even know what language variant you were using in your topic selection
W Balboos, GHB 2-Mar-20 11:00am View
   
Considering you are new to programming that is a rather ambitious project. I can't be sure about this but it seems either like homework, or worse, someone, somewhere will need to depend upon you design - possibly paying for it.

If it's homework, the struggle is where you learn.
If it's real work and someone is going to depend upon it (aside from you, yourself) then they are being cheated by the person who assigned this to you.

Again, I cannot be sure - but such posts lean in that direction
W Balboos, GHB 13-Feb-20 7:54am View
   
Each of your list has an onchange='someFunction()" event and its own ID (lets call them id='s1' and id='s2' .

When either is changed it goes to you someFunction() script.
Inside the script it tests the value from both

function someFunction () {
var test1 = document.getElementById('s1').value;
var test2 = document.getElementById('s2').value;

switch(test1) {
default: return a value when no s1 selection;
case a-possible-test1-value:
switch(test2) {
default: return a value when no s2 selection
cases that handle combinations of tes1 and test2
}
break;
case another-possible-test1-value:
switch(test2) {
default: return a value when no s2 selection
cases that handle combinations of this test1 and test2
}
break;
case etc etc etc
} // end of switch(test1)

You need to handle the various possibilites - including if either has no selection. How you pick your values is up to you.
}
W Balboos, GHB 21-Jan-20 10:01am View
   
Addendum to original answer: set up a screen dump of the actual SQL you're sending to the server. Is it what you think? Are the quotation marks properly matched. If you build the option lists as I noted, the values sent to the form target are ready for insertion "as is".

For example, is
 $sql = "INSERT INTO files VALUES (
   (SELECT * FROM customers c WHERE c.cust_name = $cust_name),
   $register_date,
   (SELECT * FROM objects o  WHERE o.name_object = $name_object)
   )";

really giving you what you want for input?
W Balboos, GHB 16-Jan-20 11:35am View
   
In my original answer I gave you a link to a tutorial that makes it very simple with examples. Please go there and see how it is supposed to be done and then you can understand why yours doesn't work.
W Balboos, GHB 16-Jan-20 11:31am View
   
My script, with the ". . ." was not a script. It was an example showing the beginning and end of the query. In other words, it was incomplete (that's what the . . . means).

If the error was something else then you should remember that if you don't post the error message no one can solve your problems.
W Balboos, GHB 16-Jan-20 10:43am View
   
You can also download and install the free WAMP server, Vertrigo. MySQL support is built in. Plain SQL add-ons, available free from MicroSloth.

I've used it for years . . . run's half the company where I work on a single instance.
W Balboos, GHB 25-Nov-19 9:48am View
   
Let's just consider the effect of the add-blocker (usually on client side).

It's an additional step that parses the page and removes object or not, based on it's logic. As an additional step it cannot help but take more time.

HOWEVER, IT'S NOT THAT SIMPLE!

If the ads it blocks are themselves slowing down the site then blocking them can actually spend lest time then rendering them.

Normally, the first consideration, above, dominates - but not always.
W Balboos, GHB 6-Nov-19 7:47am View
   
I gave you a method to answer your question which you will also to be able to continue to use for improving your work into the future:   speeding up your queries.

Presently I have my own work to do and cannot delve into the logic of your specific query as you keep expanding the scope of your question.
W Balboos, GHB 27-Sep-19 14:05pm View
   
I think we need a new icon for Q&A: something symbolizing "pull the handle to flush".
W Balboos, GHB 27-Sep-19 12:05pm View
   
At least as posted when I saw it, the loops are nested. I re-did the code wrapping and it's easier to see. Maybe this is an updated version and you're referring to the previous one ?

The formatting is really weird - printing by columns instead of rows. Somewhat of a mess - the displayed output doesn't jive with the code.
W Balboos, GHB 25-Sep-19 10:42am View
   
And how are any of us supposed to know how to get your store code when, at the very least, we don't know how your data is stored?

That, and from what you have tried, you don't ask for it, wherever it is.
W Balboos, GHB 22-Sep-19 16:51pm View
   
Try using the debugger or other such contrivance to see what size is actually be set for the font.
W Balboos, GHB 16-Sep-19 11:20am View
   
Just a thought based upon how you wish to update the multiple-duplicate instances:

You would be creating a new set (smaller by 1) of duplicates. How do you propose to handle that, if at all? At the least, you'd need to run your procedure multiple times to get through this. Alternatively, you can serialize the duplicates.
W Balboos, GHB 28-Aug-19 6:42am View
   
My email? Not going to happen.
Use the forums -
W Balboos, GHB 7-Jun-19 13:10pm View
   
Don't forget to mark the question answered so attention can be given elsewhere!
W Balboos, GHB 29-May-19 6:52am View
   
I cannot diagnose your system from here.

You have 'no idea where to look for problems' - what have you done?
Have you Googled for answers? Gone to any forums dedicated to such problems?

????
W Balboos, GHB 28-May-19 10:29am View
   
My suggestion (i.e., my php teacher): W3Schools
(actually, it was php 5, there was no 7, yet). I use it's references and those found at Official Manual.

I affirmatively do not use any form of ASP - my preference is for the open software available to everyone (free) and not likely to make arbitrary changes that force me to buy O/S upgrades.
W Balboos, GHB 28-May-19 7:12am View
   
There's no reason php cannot connect to pre-installed MySQL - if you have the connection string correct. I connect to MS SQL - totally separate application. Even on totally separate servers. I don't use IIS -

From your writing, it sound like you already have php installed. Is it working as php? Why bother at all with that limited version of IIS when the Vertrigo server is a full implementation of all of its contents? PHP->MySQL is a built-in set of functionality by default.

I would conclude that you can't connect because you have the connection code incorrect or you haven't given yourself access to MySQL.
W Balboos, GHB 27-May-19 14:36pm View
   
Debugger . . . . ???
W Balboos, GHB 23-May-19 13:37pm View
   
If any of the solutions answer your question, don't forget to select it an mark the question as answered (and thus allow attention to be given to other questions).
W Balboos, GHB 23-May-19 11:10am View
   
It's all in that WAMP package - all nicely integrated together (apache for your server, php for it's www folder content.

What flavor of php you have depends upon what version is with the Vertrigo you install. It's complete, as is.

Currently, where I work, that freeware serves about 100K pages/week without a hitch and has done so for years.
W Balboos, GHB 23-May-19 8:47am View
   
Generally, it should just work - what do you see (or not see?).
If you see nothing at all, then just for laughs, give it a real length and width.
If you see an empty rectangle, try copy/paste from your URL. First, another page in your domain and then other. Just t be sure you've got your syntax correct.
W Balboos, GHB 14-May-19 7:49am View
   
Whatever your reason, the rules for php won't change for you. You need to define a variable before you use it in such context's as an array index or function argument.

Supposed it let you do what you wanted - from where would it get a value?

You need to get a value into $transaction_id before you use it.
W Balboos, GHB 9-May-19 14:44pm View
   
You haven't told me it's yours - and a good thing, since the commentary is clearly not yours on grammatical and syntactical grounds. You come here for help - but not for your own work but to have us complete the acts of copy and paste so that it works. The disrespect is, in fact, your trying to use this forum to do your work for you.
W Balboos, GHB 9-May-19 14:30pm View
   
For help, yes - for grabbing hunks of code and trying to pass it off as their own and needing help to make it work because they're clueless about even the fundamentals? It is getting more common - and is pathetic. Don't confuse "help" with "plagerism"
W Balboos, GHB 6-May-19 15:23pm View
   
Thanks. I'm rather old-school and used to do various numerical modeling applications. Often, an "call" would happen tens of millions of times. That really adds up with functions vs. inline. Remember, too, how much slower CPUs were. So - the habit sort of sticks - doesn't cause any harm if it's a one-time event.

Think of a pecking order of efficiency:
Direct inline conversion
Function-conversion via by input strings
Function-conversion, a character at a time.

The last, obviously extreme, emphasizes the point - although I'm quite sure you already have it. Someday, you may even need it.
W Balboos, GHB 6-May-19 15:12pm View
   
Neither is bad - but the if this were done a lot, each function call would have overhead such as pushing and popping stack values. Now if this is compiled, the function could possibly be inlined and do this anyway.

It just saves overhead but requires you code a loop instead of a function call with an input and returned value.

Internally, one way or another, you'd be using the lookup table concept in a function.
W Balboos, GHB 30-Apr-19 9:00am View
   
There's available free version of SQL Server - limited number of connections.

I suppose you could dig up a copy of FoxPro, somewhere - although far better than Access, it hasn't been supported in years.

If his equipment is so old it cannot support any of this - he's long passed the point of saving money by not updating.
W Balboos, GHB 22-Apr-19 11:27am View
   
When you finally figure out how to use the data from the answers, consider, as well, how to make sure you actually have pairs of IN/OUT times for each employee - if they didn't do an OUT - what will you do? What if they skipped OUT on day one and IN day two ? Summing the daily differences is, in fact, the easy part.
W Balboos, GHB 26-Feb-19 9:37am View
   
Your code is NOT javascript. Maybe jquery? You should make it your business to know what you're using - the answer depends upon it.
W Balboos, GHB 26-Feb-19 9:34am View
   
1) Why didn't you ask the source on stack overflow?
2) At the least, come back AFTER you try something - this isn't a code-writing service. Try to figure out what to do.
3) If (1) and (2) don't work, then perhaps just find something else to keep you busy.
W Balboos, GHB 21-Feb-19 11:23am View
   
I disagree.

Take for example his "expected solution" post. It really means "wanted solution" - he wasn't given what he wants on a silver platter.

On a different Q&A, I went against the crowd and gave an hint - even if it was homework - because it was a push in the right direction and still required their homework to be given some work.

Here - it strongly indicated someone who'll spend their life looking for someone to give them "The" answer.

Googling, itself, is a skill. One anyone in this business of ours should learn and learn early.
W Balboos, GHB 21-Feb-19 8:15am View
   
A developer needs to use their brains and figure things out. If you think you'll find everything exactly as you want it you are in the wrong business.
W Balboos, GHB 21-Feb-19 8:09am View
   
Expected Solution?
If you know what to expect then do it.
If you don't know how to do it how can you expect anything?

In either case - you call yourself a 'developer'. No - you want to be a developer. You've a ways to go.
W Balboos, GHB 21-Feb-19 8:03am View
   
Google it - not much harder than posting here.
And bookmark the anyplace that's a good reference.
W Balboos, GHB 19-Feb-19 7:01am View
   
It's unlikely anyone will read that book of code you posted = unable to connect almost invariably implies either your connection string is bad or you don't have permission. Trim the above down to the connection string.
W Balboos, GHB 21-Jan-19 14:48pm View
   
Every element can be read, via the DOM, for example, as a value, or, in some cases, as the innerHTML. As for which to read - you could associate the id of the text containing area with the id of the checkbox (area1->chk1, area2->chk2). There a so many ways to do this sort of thing, depending up the circumstances. If you must use a form, then the checkbox state can set/clear a value in a hidden form element. If value not empty, save; if empty, ignore.

Use some imagination!
W Balboos, GHB 17-Jan-19 9:29am View
   
Also - you're using jQuery, not just javascript. There's a difference.
W Balboos, GHB 14-Jan-19 6:27am View
   
Now, I didn't mention a country - so you clearly have one in mind.

However,

I've seen and used software made in "The Land of the Call Center" and it reeks of the quality of how the programmer-curricula are designed to turn out huge numbers of incompetent fools. Sad, indeed, because some excellent programmers will be lost in the vast crowd of substandard drones.

Upon reflection - even the standards for the call centers have gone down.
W Balboos, GHB 9-Jan-19 14:09pm View
   
Check how you are initializing the value - it should be zero. What have you done to make it otherwise? You should be controlling the indices values, possibly in a loop. How is your loop initialized? If this is the basic start of the application than you need to make sure you do not assume any of the initial values for your symbols. Test them !

The debugger is your friend.
W Balboos, GHB 9-Jan-19 6:06am View
   
It returns a string - ECHO it

If you've just been cutting/pasting and don't really know how to do this I suggest you try: HERE
W Balboos, GHB 27-Dec-18 14:44pm View
   
For VIEWS, use

CREATE VIEW viewName
AS
. . . put your SQL in here . . .

See here: https://www.w3schools.com/sql/sql_view.asp
You'll never learn to do things until you struggle a bit with actually doing them.

Also, when your question is answered please pick the answer you like and "accept it" to close your question.
W Balboos, GHB 24-Dec-18 6:56am View
   
In general, and slightly leaving the scope of the question, would a DISTINCT directive be a good idea to add to this? Not knowing what the data looks like, the potential for any number of duplicate records exists (particularly if there's no unique id'ish type field in table2 or table3)?

Of course, they may want the duplicates.
W Balboos, GHB 21-Dec-18 7:41am View
   
One problem with your reply . . . it doesn't change the fact that you're trying to get through school on other peoples brains. The quality of development I've seen coming out of India only goes to confirm my assertion.

I suggest you retrain for work in a call center.
W Balboos, GHB 14-Dec-18 10:38am View
   
For now, get over this idea of 'certifications'. Being certified doesn't make you good at anything. Perhaps knowledgeable, but no skill in usage is implied . . . certainly not in real life. Like studying music doesn't mean you are able to play music, let alone play well.
W Balboos, GHB 14-Dec-18 7:23am View
   
This would be an incredibly dangerous feature if it existed. You data and personal information can be passed system-to-system for any purpose. Sessions were not designed for this. Consider them a mechanism to keep you client and the server coordinated during the brief periods they must share information - before the server drops interest in you until the next data request.

Data can be transmitted, for example, via the URL across systems.
W Balboos, GHB 26-Nov-18 14:25pm View
   
Try running this without wrapping it in a transaction - if it works than adjust your code/query order appropriately.
W Balboos, GHB 15-Nov-18 14:40pm View
   
Do you have google on the internet where you live? If you do, did you try it to find entity classes? A long list of v's as to what you've done so far is not going to encourage anything in the way of a response.
W Balboos, GHB 15-Nov-18 14:37pm View
   
Did you run it? Does it work? What is it that you want us to do?

Not using built-in methods? Does that mean for the date difference or does it mean anything having to do with dates?

Please revise your question to a specific question.
W Balboos, GHB 9-Nov-18 9:05am View
   
As noted, non-conventional.

Since it's internet based - how much loss will really be observable in performance?   It's not how I'd do it. It appears, as submitted, that the activity of the items is link-based - so no events (if you don't count clicking a link) are in jeopardy. It does, in its way, illustrate my strength and hamartia: Aut inveniam viam aut faciam

And ultimately - it will, at least, work.
W Balboos, GHB 8-Nov-18 9:26am View
   
What you can take away from the above answer to the question and your own comment is that you need to plan your data storage carefully. The difference can be between making things easy and making things very difficult or impossible.

It is one of the most important steps.
W Balboos, GHB 26-Oct-18 7:23am View
   
Good catch. I guess he'll need to leave the commas in place! Meanwhile, tail between legs and grinning on this end.
W Balboos, GHB 26-Oct-18 7:22am View
   
Philosophical Interlude:

A few things are all but ubiquitous, like "googling something". On the other hand, the internet is a big place and room for an unlimited number of private views of its world. Still, one becomes familiar with their view and can forget that it is a unique place.

For example - here, at CP - approaching 14 Million members - so one can safely assume that most people have not heard of it. It's all a bit amazing because of the scale, flexibility, and constant change.

So - nothing to be sorry about.   In fact, I've been into photography since my pre-darkroom days (B&W, of course). Not as a collective - my world, but I should get around to more of that. You've supplied me with reference material.
W Balboos, GHB 26-Oct-18 7:14am View
   
That's why I called it a back-handed solution, although I wasn't thinking of it as homework. Aside from that, neat way to recast the problem, no?
W Balboos, GHB 25-Oct-18 12:53pm View
   
Aside: For the small arrays, shown, that would be OK. However, if the matching fails then the search needs to continue just past the last initial match to see if the substring still exists further down the big string. Just noting, really for the original questioner, that "it ain't over 'till it's over"
W Balboos, GHB 25-Oct-18 9:39am View
   
Demagoguery? In your vocabulary, that seems to translate to any suggestion of imperfection another might observe in you. Well - if that's how you see this place, why not find another more to your liking? Let me ease your conscience with the assurance that you will not be missed.
W Balboos, GHB 25-Oct-18 9:21am View
   
Neither did you write as to whether or not you'll bey at tonight's full moon.

The Point?   We don't know what you won't do, just because you didn't mention it. The information you mention, DOB, has legal restrictions on its distribution - is it not better I err on the side of caution?
W Balboos, GHB 25-Oct-18 8:34am View
   
Well - I didn't know about IMGUR until just now. Don't assume that something very familiar to you is familiar to others. The real point is, however, that a link can be pointing to a malicious website (or one newly compromised by a third party).
W Balboos, GHB 25-Oct-18 8:31am View
   
I would NOT want my private information, such as my birthday and email address, posted to any third party cite without my permission (like mailchimp). That's some serious personal information you're giving away!
W Balboos, GHB 19-Oct-18 13:48pm View
   
I would suggest your first study on how one creates a search engine, and/or, trains one where and how to search.
W Balboos, GHB 15-Oct-18 6:34am View
   
You don't give us any information at all - presumably you have no clue as to what you are doing. Building a website is more than just putting words and pictures on a screen. If you want to know how to build a website - or do anything else in this world - you'll need to study how it is done.
W Balboos, GHB 28-Aug-18 8:44am View
   
Well perhaps because I don't complain about it (because I'm among the hapless who answer them when they reappear because who checks?).

What drew my attention was the down-vote that was, as it turns out, given across the board. I suppose it can be traced, but likely the account is abandoned and a new one created.
W Balboos, GHB 24-Aug-18 12:45pm View
   
Per your reply to Solution 4 - I just pulled it off the list - which I rarely if ever check for currency as it's the 'live' list. But Alas, the deed is done.

2014 !
W Balboos, GHB 24-Aug-18 9:21am View
   
Do you really think a good solution is to retype the table? He may as well type his original data into a spreadsheet and manually pivot it, for example, with Transpose, as needed
W Balboos, GHB 24-Aug-18 9:15am View
   
Well - so far you've done nothing. If you're just learning, the first thing you should learn is how to look things up and not ask someone to point the way.

I gave you a site, somewhat pre-selected to your needs, that will teach you how to make a link.

I mean, really, what did you expect from your post? Ready-to-run code (ASAP, no less)?

You learn by DOING and STRUGGLING not COPYING!
W Balboos, GHB 21-Aug-18 6:28am View
   
Consider that once you hide a row with a button-click, if you wish to un-hide it how do you do it - aside from a separate button to "unhide all"?
W Balboos, GHB 27-Jul-18 12:52pm View
   
Is that all you have? One incomplete statement? How are we supposed to know what you are doing and what you have done.

What do you do and and what happens for you to decide this doesn't work?
W Balboos, GHB 28-Jun-18 8:45am View
   
Let me rephrase for you what is in the past several responses:

You show us what you tried. Well? What happened?

As you wrote it, for all we know, what you tried worked perfectly.
W Balboos, GHB 28-Jun-18 8:38am View
   
Why do you has AS to name the return field in subqueries?

It would, of course, be useful, too, if you:
1 - gave us the actual error message your received
2 - respected us enough to actually write out words and not use texting garbage abbreviations.
W Balboos, GHB 18-Jun-18 9:33am View
   
Did you check the page source to see if your script even got there, and if so, that the relative paths are correct?
W Balboos, GHB 18-Jun-18 7:38am View
   
That's quite a chain of events you wish the store procedure to implement. From your "What I have tried:", the answer is apparently - nothing.
W Balboos, GHB 14-Jun-18 7:36am View
   
Quiz systems are available all over the internet.
Try some google searches.
W Balboos, GHB 7-Jun-18 7:19am View
   
Thanks for the thanks. As an aside, if you post in Q&A and get a satisfactory answer, you should mark it 'accepted' and thus close the question.

It's not done nearly enough - but good housekeeping and all.

Oh - a coding tip:   I comment my code. Not for just other programmers but for myself. You good stuff may be use for years and YOU WILL FORGET!
W Balboos, GHB 4-Jun-18 11:26am View
   
Somehow I remember doing this type of thing in the past - but obviously not with the div. If you check my revised answer, I gave a link to one of the various work-arounds. Now I'm wondering if this was something I did in .NET just transferred the idea without check. Glad you caught it. The idea of hiding the link (via div) would work but isn't really what's asked for.
W Balboos, GHB 31-May-18 6:29am View
   
So you can't look into Access features and find the same functionality? If that's too hard to do, or too difficult to grasp - you should consider another field of study as soon as possible.
W Balboos, GHB 17-May-18 9:20am View
   
A bit of a warning for your future coding.

Although, in javaScript it doesn't matter, there is a difference as to how calculations will end up if you use 1000000 and not 1000000.0 - in how they are stored, which number is first in a calculation if you mix types, and any number of other rules for a language implementation.

Round off errors during calculations could give you unexpected results.
W Balboos, GHB 16-May-18 13:14pm View
   
"Seriously" - from the small patch of code you include with your question and all the missing information (like how and where do you build $connection), that's all the information that I can offer.

Several different tests you can do. That's how you debug a problem. Break it down until you see the bit that's not working.

Try using a debugger to see where your code goes wrong.. If you don't have one and plan to continue writing code, you should get hold of one.
W Balboos, GHB 16-May-18 12:17pm View
   
So, since you say it looks the way you think it should and it works when run directly, you need to check your php connection.
$result=mysqli_query($connection,$query);

And I don't know you parameters, password, or system, so that's something you'll need to work out yourself.

ONE MORE THING: Does your code even get as far as the MySQL call? Check that, too.
W Balboos, GHB 16-May-18 12:05pm View
   
I asked two questions:
1 - Does it look the way you expect it to look?
2 - If you run (the result of 1) it directly on you MySQL server, does it work?

If it works than you need to check you connection string.
If it doesn't work when used directly - then it would not work through php, either. You need to fix it.

But first, make sure it works without php. If necessary, post the result of '1'.


If it
W Balboos, GHB 10-May-18 9:41am View
   
No problem with php before the DOCTYPE.

In fact, a session must be started ABSOLUTELY as the first statement following the <?php or it will throw an error (headers already sent).
W Balboos, GHB 10-May-18 6:30am View
   
Try debugger.
W Balboos, GHB 9-May-18 9:47am View
   
Am I to understand you correctly:   you don't know what you need to do to divide by twelve ?
W Balboos, GHB 7-May-18 6:22am View
   
Don't know how to create what? A key? At table? The query to use a key?

SO far, your error description is a 'blank page'. How is anyone supposed to help you with that error? It's your code on your computer - so find out the error.

.
W Balboos, GHB 7-May-18 6:19am View
   
If you want the search results to be triggered from your table you need to populate the table with reference to the links (link or AJAX). I would use AJAX.

However, if you just started learning PHP, you should spend some time learning it before you make a project spanning so many features. The expression "crawl before you can walk; walk before you can run". AJAX calls php through javaScript.
W Balboos, GHB 4-May-18 13:17pm View
   
Check any maintenance cycles which correspond to this failure schedule.
Also, check your applications for memory leaks.
W Balboos, GHB 4-May-18 11:48am View
   
C# has a namespace for access to the databases
- build the query that calls your stored procedure and use it.
- when the results come back - do what you want with them.

You "WANT" a lot - well, then start looking up how to do it! You have amazing resources available to you with the internet. I taught myself to do these things from real books - limited resources - and a lot of resolve. You need to make the effort - which is usually hard work.

Also, note that "c.customer_id = 'cus1' " in your query, above, is going to really limit your results!
W Balboos, GHB 3-May-18 13:03pm View
   
I do so on a consistent basis.
Are they on the same instance of the MySQL server? Are all the permission in place?
You may need to link the servers.

Since you've not supplied your actual query, I can only guess at some general problems.
W Balboos, GHB 3-May-18 6:44am View
   
Maybe he did and got an Indian customer support service call center and . . .
W Balboos, GHB 3-May-18 6:42am View
   
Maybe, since you also seem to have c# available, you should read the flat file and use String.Split() on it? Then you can insert it in a preexisting table and be done with it.
W Balboos, GHB 1-May-18 10:33am View
   
If your talking about each individual row, you can add a new field of type INT, and then, per the link I gave your, convert it to an IDENTITY field. It will automatically fill with sequenced numbers.

You can now select any record for any process by referring to this value in your WHERE clause. It will always return just that record as these values are NEVER repeated. You have to determine how your list knows which record identity to associate with each item. Fill the list via a query or hard-code it.

NOTE: if you find a answer that solves your question, mark it as accepted so it can be properly closed.
W Balboos, GHB 27-Apr-18 8:34am View
   
When I think about it, I don't actually know what a 'banker' is, except for someone who works in a bank in some way.

But - you've been an IT Tech for seven years and started school in this last year. You really don't qualify as 'new' to the point that your question's quality implies.

Where I am, there are IT techs - keeping everything running. They do not (and generally, can not) write code. They set things up and fix things. Some help users. The very clever ones even have access to account maintenance. But they don't code.

That's OK - but the question, after all these years, is what are you looking for? The way to code is to attack the question with all your resources - look things up (and thus learn them) - particularly, the basic operators for our language of choice. 'C', by the way, is not an easy starting point. How did you come to select a course in 'C'?
W Balboos, GHB 26-Apr-18 11:52am View
   
Two things:
1 - easiest solution all around - let simple Q&A go as just that
2 - Why does Sean have a negative rep-points total? Does he have so many it rolled around in a signed int, or . . .
W Balboos, GHB 26-Apr-18 8:41am View
   
Now I feel like a hamster running in one of those wheels.

Wheeeeeeeee!
W Balboos, GHB 26-Apr-18 8:24am View
   
Checking the dates - I can see how that makes sense. I'll probably end up doing it again because, alas, I often zone-in on things (quickly) and reading the question, existing answers, and determining if I've anything of value to add consume most of my mental threads.

None the less, I'll still try to keep check-the-date in mind, somewhere. Maybe when I read the "what I have tried" part.

Maybe a way to close out a question (after a year or so) to any further answers might be a solution?
W Balboos, GHB 26-Apr-18 8:11am View
   
Well - I pulled it from the 'current' list. Something brought it up. I noticed, now that you pointed it out, that answers are mainly 2012, another at 2014.

Perhaps solution 8 will satisfy whoever keeps activating it? For whatever reason, it was just updated. Maybe they're still working on this problem?
W Balboos, GHB 25-Apr-18 7:59am View
   
I only follow links from trusted sources -
W Balboos, GHB 24-Apr-18 7:06am View
   
Is this even your code? You don't know what language it is and apparently haven't a clue as to what you're doing.

Maybe you should find out who made it and ask them!
W Balboos, GHB 19-Apr-18 8:21am View
   
Duplicate Entry - Other already answered.
W Balboos, GHB 18-Apr-18 8:59am View
   
It sounds like a product for a business - which they will use to make money. If that is the case, they should pay the developer. If that is someone here, at code project, then they should be compensated for their time.
W Balboos, GHB 11-Apr-18 8:21am View
   
I was going to help - but I saw your attitude.
So - you continue to get nothing.
W Balboos, GHB 11-Apr-18 6:54am View
   
Stop Re-Posting this question.
You've posted it (at least) three times.
W Balboos, GHB 11-Apr-18 6:50am View
   
Stop Re-Posting this question.
W Balboos, GHB 4-Apr-18 13:59pm View
   
Please reread my previous comment.
Or find a WordPress forum, somewhere, with people who like and know WordPress.
I am not one of them.
W Balboos, GHB 4-Apr-18 6:38am View
   
Deleted
Please mark answer accepted so other helpers know it's done!
W Balboos, GHB 4-Apr-18 6:20am View
   
I suggest that you pause in your work and study how WordPress actually works (if you plan on continuing to use it). I create my web pages "from scratch" and they are just plain files (.php, .js, .htm, .h and .css for example) and they are stored exactly where I put them. You are in WordPress' world and you need to study how that world works.
W Balboos, GHB 30-Mar-18 9:05am View
   
It's not likely anyone will read your listing - especially since you don't even give a hint as to where it's gone wrong. Reformulate the question so that the problem is highlighted - not hidden.
W Balboos, GHB 29-Mar-18 13:44pm View
   
Wordpress is completely database contained. Even the pages. There are probably online forums about where these things are stored and how they work together - but that requires you have access to that particular database. Unless it's your own copy, you most likely don't - will need to find whatever interface it has available for such control.
W Balboos, GHB 27-Mar-18 7:41am View
   
Both myself and answer (1) have supplied you with some help. Problems pointed out and alternate methods of getting date difference.

That's help. "Do my work for me", if that's what you mean, is not help.
W Balboos, GHB 27-Mar-18 7:26am View
   
Contact your bank - and hopefully they'll tell you that you cannot do this! If anyone could write software to access bank accounts so easily, you'd be quite a fool to put any money in them.
W Balboos, GHB 23-Mar-18 7:37am View
   
Path where you need to put the cookies? No - cookies are put in a browser determined location.   Mozilla: the cookie jar; IE, each was a file; Chrome: whatever.

Check the cookie filter settings on Chrome. Also, are your cookies being set for your current site or for a third party site? That matters.
W Balboos, GHB 20-Mar-18 13:08pm View
   
Your answer's close enough to mine that I won't submit one. Here's the change.
int counter[2]; 


Then, for all numbers you could simply have:
counter[num&0x01]++;

Just a nuance, but I thought you might find it interesting.
W Balboos, GHB 14-Mar-18 8:11am View
   
Think of it as an assault on castle. You have powerful allies, like google or even bing - especially if you have an error number or cut/paste the exact error message.

Like programming, itself, it's really always made of a lot of small pieces. Even the failures often end up helpful.

That being said, it depends upon where your strengths lie. You'll find many programmer on this site more knowledgeable than I. My strengths are in (very rapid) problems solving (and clever retorts). No compartmentalization of knowledge. Your assets will likely be different. Your contribution to countless gestalts.
W Balboos, GHB 12-Mar-18 13:09pm View
   
Google is your friend (C# stacks)
https://www.dotnetperls.com/stack - for example

There are a few basic commands push, pop, peek -
You need to do the comparison based upon whatever type you are trying to compare. In your case, the type you'd most likely use is string - and depending upon your source, you can make comparisons case sensitive or not (human or machine generated).

Stacks are really powerful and important tools - essential for a parser - which is what you're making.

You push 'opening' items, be that tags, parenthesis, quotes, whatever. For things like tags or closing parenthesis, peek at the top item on the stack it must match if things are to close in the order opened. If it matches, pop it off the stack (it's closed and thus complete). If it doesn't match - you have found your problem.
W Balboos, GHB 7-Mar-18 10:28am View
   
Select A.Colum1, Sum(A.Colum2) - is only looking at data from the "A" return values. The only thing your join is doing is acting as a filter to limit those that come back to those that have matches.
W Balboos, GHB 7-Mar-18 8:38am View
   
You can join a table to itself. It's actually common.

I use it, for example, to take rows and convert them to columns. Actually exactly what you're doing if you think about it.

Just give each version of the table its own letter
SELECT A.x, A.y, B.y, C.y from TABLE as A
INNER JOIN TABLE as B
ON A.x=B.x
INNER JOIN TABLE AS C
ON A.x=C.x

This will give me the key (x) and the values for y as three additional columns. You probably want to name the columns, as well, so they can be told apart.