Posts by hericles

Well, telling us the detailed fault message would help. And the inner exception showed no error message?
Are familiar with tools ike Fiddler? They can catch the response coming back and you can look for the error there too.

Use a JOIN to connect the two tables. For that to happen both tables need to share a common key that you can JOIN them ON.
A sample JOIN looks like:

SELECT a.col1, b.col2 FROM tablea AS a JOIN tableb AS b ON a.col1 = b.col1 WHERE <some flter> 

As an aside you mentioed a widget to show the last 5 songs but your query, ifit is the query for your widget, gets all songs from the table. You can use LIMIT <some number> to specify how many rows to return.

You need AJAX. A standard button click will process all server side code and then cause a postback to the page, meaning nothing will update until the process is complete.

The header command needs to be ran before any other output (read the docs on header) so if you have HTML tags, comments, etc, before that code segment it won't run.

Looks to me like the IF statement only runs once, there is no looping through the returned records. So the first result = 'cellphone' and thats all you see.

That is actually a very good point. +1

For a start you database design could be better. You should have a table for employees, a table for department and a linking table that holds just employee IDs and department IDs to show who is in what.

emp (id, name)
dep (depid, dep_name)
emp_dep(empid, depid)

Now you join all three (if you want to search by name) or just emp and emp_dep if searching by depid is enough and you can use NOT IN or something similar to separate out your employees.

Have you checked your extension_dir setting in the config file? It may be making PHP look in the worng location for extension modules.
Otherwise, I got nothing...

Any information about what goes wrong, displayed behaviour or error messages, would help us out a little.

Put the second div inside the first div, then the mouse never leaves div 1 and the mouse out event never fires.

Can't be that awake, you didn't read my first post ;)
Brandy1, I really can't see what is causing the problem. I have looked at the PDF and gone through it but there isn't any cause for the doubling that I can see. Can you confirm the PDF is the actual code you are using? Maybe re-post the actual code so we stop getting confused.

The language used doesn't have much of an affect on the solution to be honest, not once OS restrictions are out of the way. You should pick a language that meets any special requirements (you don't seem to have any) and that you can code well enough in to create the solution.

As to how to proceed - how skilled are you in software development? You have only given us a very brief overview and want to know how to code the solution?

In the sample you posted above you aren't calling getExamGrades at all so dblMidTerm and dblFinal never change from zero. You then pass 2 zeros into CalculateTotalAverage and get nothing back.
You are calling getExamGrades in the PDF though.

I'm not sure what you want is possible. Have you coded this application yourself or is this something you want to achieve in other software?
Naturally, if you selected and copied some text and then hit Ctrl-V of course the text will get pasted into the same textbox, thats where the cursor is.
If you clicked elsewhere so no control had focus how would the OS/software know WHERE to copy the text? It definitely wouldn't decide to paste the text into some control in some form in the background.

What difference exactly are you looking for? Rows in one that aren't in the other or changes to individual cells in a row?
Is the number of rows the same in both datatables?

Most payment portals have an API that allows the website to make calls to the payment provider. exactly how they operate and fit together depends a lot on the particular provider and their API.
Obviously, PHP skills help a lot. Did you understand how the API works and looks at examples? Most have a sandbox you can use to test as well.

A canidate key is any column in the data that can be used to uniquely identify the rows. For example if you had an employee table that included the company's employee number for each person and each person's social security number, both of those would be canidate keys to be actual keys.
A natural key is one that directly relates to the data. In the example above both would be natural keys if used as they both come from the data itself.
A surrogate key is one that is created for the data to provide uniqueness. Creating an identity column, a GUID or an auto incrementing primary key are all exmaples because they make each row unique but aren't a natural part of the data.

I think it may be because FROM and TO are reserved words. You need to delimit them as you have Sheet1$. Or rename your columns because that'll catch you out time and again...

Firstly, an indication what the problem is beyond "it's not working" would help a lot. As would actual code. You've just given us HTML which isn't a lot of help.

This article should help you

The easiest way would be to use the id column as a unique key in the sql server. Then if it already exists the insert would fail. You'd just need to code around the error so it didn't stop processing. The problem there is that every row in the access database would get pushed to the sql server to see if it would be inserted or not. That gets inefficient as the access database grows.

option 2: extract all IDs out of the sql server first and then match the access database, only inserting a row when !contains is true. Saves on unneeded INSERT queries but could be a terrible solution based how you implemented the !contains check.

or you could drop or truncate the sql server table and simply reimport the whole thing each time.

Or possibly alter the access table so after an import all rows imported have a flag set indicating they were replicated. But that may not be possible and could go wrong easily.

OK, so you don't have a problem then? Is there anything going wrong or did you just post a code snippet?
Oh wait, I see. Your <option> isn't displaying correctly is it?

you need to echo the actual option tag as well or you're just printing rows to the page as text.

echo '<option>'. $row['name'] . '</option>'

You pretty much have it correct. If no data lends itself to being a natural key (i.e. nothing int the data is unique across rows) a surrogate key needs to be supplied.
If you created a id column using [int auto_increment primary key] then you have a surrogate key because, although the column uniqiuely identifies each row, it has no real world realtionship with the data.
Using unique 'business' data means you are using a natural key e.g. social security numbers in a payroll database

Matter of opinion about which is the 'best' I guess but I believe the most used language for game programming is C++.

Where are you specifying your connection information? Is this all of the relevant code?

The windows Live Mail assistant may be off.
Type services.msc in search box, and run as Administrator.
Then find Windows LIve ID Sign-in Assistant and make sure it is running, even restart if it says it is running.

see link at bottom of original post

What does the developer tools in your browser say? Any error coming up as a clue? Although, on closer inspection, I can see this:

$("a#inline").fancybox({
            'hideOnContentClick': true
        });

but no matching #inline anywhere. Is that correct or an error?

Post up your code and we'll have a look. Its hard to fix someone's problem when you can't see what could be causing it...

Not interested in just using a background image (one including the arrow) for the hovered element?
If you want to keep it as CSS3 I've seen attempts to do this where the bottom line would be broken up into four sections and transform is used on the 2nd and 3rd to rotate them and position them so they form a V. Probably worth researching as it sounds feasible.

The issue isn't with the SQL which is why the query works fine. The error clearly states you are using mysql_fetch_array wrong.
You want to be passing in the result of your query, not the query string.

$totalDates = mysqli_fetch_array($result, MYSQLI_NUM);

If you simply want to validate the input, make sure values are entered in required fields, that emails are in email format, etc you can just use jQuery to monitor each input for changes and validate them.
If you need to check the input against a database for any reason then you need AJAX to post the query away and get a response without leaving the page.
Both of those methods happen as the user enters data into the page and have nothing to do with the form submission (in fact, once anything is flagged as bad or a required field is incomplete you could disable the button).
Recording the info and sending an email would be handled by the PHP script on form submission.

I doubt you will find a custom script that works exactly as you want and PHP scripts won't work the way you want anyway as they require post back.

Two ways the query could work (depending on your database design):
Your database query could be a query to return everything from the users table for that login.
You then parse that result set to locate an empty elements and if any are found display the alert box.

Or, query for all fields in the database that are '' or NULL. If anything is returned then you know to bring up the alert box.

Once the user has clicked the link to complete their profile you can either show just the empty fields or show everything to allow them to make changes to every field. Save the changes to the database.

You mention it should be the same script that does all this but it doesn't have to be and preferrably won't be. You want one script to detect empty fields, if any show message to take user to editing page.
From that page second script runs the update.

Its too big a pool to answer that with any certainty at all. They could ask anything. One strategy is to pick something you know well, or intend to learn well before the interview, and redirect the conversation. They ask about topic A, find some way to talk about topic B.
Confidence is important and being able to show you know something is better than nothing, as is showing you have the ability to learn and adapt quickly.

I'm not sure what you mean when you say 'Class Form'. Are you referring to the form class? E.g. the class used to create Forms in winForms programs?

A class diagram is a text/graphical display of a class, outlining various aspects of its structure such as name, parameter types, included methods, etc.
Diagrams incorporating several classes are uses to show how software components fit together and interact.
A picture would explain it better. google images for class diagram and you'll find plenty of simple examples.

Java does an automatic compilation process where any dependent classes it finds referred to within the class it is compiling are compiled too.
This is nested so if your Vehicle class referred to another class, the .java of which was in the same directory, it would also be compiled when you typed
javac VehicleDemo.java

Which browser are you using because the 'questions 24/7 support login' section is to the right in Chrome and it looks pretty good...

I have no experience with Pycharm so I can't help with that. IDLE was OK but when I started using Python I was already used to eclipse so using eclipse with the python mod was an obvious choice.
Eclipse is almost certainly the IDE you will want to move to eventually.

this should help

Using System.IO you can use the Directory class to get a string array of all files in a directory. Then you can check the array for the file name you need to see if it exists.
Once you know it exists you can use the URI as the source for the picture box.

Well, to be honest, that approach isn't really needed for something like this. You're dealing with two fairly simple classes with limited interaction. I tend to jump start into projects like that.

So, lets recap. Where are you at now?
Do you have your BankAccount class done, with the needed private variables and getter/setters for each?

Thats fine, I just wanted so advice as to whether a custom modue is a better approach than tearing out the product/account fetching code that is already there and replacing it with queries for the third party accounting package.

Foreign key constraints prevent INSERT and UPDATE commands if the corrosponding key is found in the referenced table.
That means the s_id value you are trying to insert into student_academic_history must already exist in students.
This is half the reason you put in a foreign key constraint anyway.

Taywin is referring to at least outlining the classes you will need, either is pseudo code (which a close approxmation of code but written to give you an overview and clarity) or something even more basic. You would end up with skeleton classes that, as a minimum, showed the variables and methods needed by each class, method signatures, parameters and return types, etc so you could know your proposed solution addresses the problem.

well, thats encouraging...

Close but your

this.Accountnumber = AccountNumber;

needs to match the variable defined at the top of the class (nextAccountNumber) otherwise this.Accountnumber won't match anything.
I notice the specs say the amount needs to be formatted and includes decimal points so you'll need to switch away from int.

public void setBalance(int bal) { // double, float or decimal maybe?
   this.balance = bal;
}

setBalance() is then called by the class that creates and uses the BankAccount class.
Man, I'm a soft touch...

Mutators and accessors are simply ways of accessing and/or changing the private variables instead of accessing them directly.

So, instead of having BankAccount.balance = 20000 you would have a method in the class that sets the value (generally these methods start with get and set so their use is obvious).
E.g.
BankAccount.setBalance(20000);
and in the class a method setBalance that accepts the input and alters the private variable. So, in terms of your question the eight methods referred to would be the get/set for each private variable - one to set it and one to return it.

I don't know much about Magento so I need some advice. I do know PHP.
A client wants to update their website to ecommerce and use Magento as the framework but they want to use their current accounting package for user logins, products, orders account, etc because the data is already there.

So, what is the best way to tackle it in Magento? Should I be looking at doing an entirely new custom module or overriding the existing code for database queries? Like I said, I don't know much about Magento or its internals so I'm not even sure the second option is feasible...

Any advice from people that have done this (or are just familiar with Magento)?

Ah Google, where would we be without you?

Click Here