… that there seem to be so many SQL-related questions in the PHP board?
Yes, I know most of the questions are framed with PHP coding. But the actual questions themselves relate to the data returned by the SQL query itself, not how the PHP code uses that data.
Where is the best place to post a question about an IE 6 problem? Specifically about background images used in a UL for a Nav bar. In IE 7 the bg images are visible in IE 6 they are invisible. I can provide code but before I do I would like to know best place to post.
Before anyone says why bother, let me say it is a mandate of the project. I’ve scoured the internet and found this: UL {position:relative;} but this did not fix it. I also discovered the setting of a height attribute to 1% but haven’t yet had a chance today to access the code. (it is still early morning on the east coast of the American continent.)
As others has mentioned, the main issue is that they dont know where in the code the issue is located. Or in some cases even worse, they dont even know there is a difference between PHP and SQL.
Word!
I am certain what you guys actually mean is that most PHP developers has a basic understanding of SQL. There is a big difference from being able to write a query to fetch data, to having a good understanding of SQL.
My experience is that few PHP developers have a good grasp of SQL programming, considering mainly creating efficient database models, efficient queries etc.
I agree that a majority of the time it’s because the OP doesn’t know.
For example “____ doesn’t work!” might involve PHP, MySQL, HTML, CSS, and javascript. So where to post? Easy if you know what’s causing the problem, not so much if you don’t.
That’s an option the board admins have (whether to leave a follow-on link)… it’s generally used so that the person posting the question doesnt think their question has been deleted.
The thing is you have to have a pretty good understanding SQL to be able to achieve anything useful in PHP. That is why those types of questions end up here and actually get a good answer most of the time.
I have yet to come across a job opening that requires PHP with database knowledge optional. You really need to know SQL to be useful with PHP. At least that is what people expect it seems.
The process really is a simple one if you understand SQL. If the application code runs but the database does not return the expected results, update, etc than echo SQL and test for accuracy. However, without a solid understanding of SQL its difficult to do that. That seems to cover the majority of those types of question. Either the SQL is completely wrong or something is lost when translating a static query to a dynamic one using the application language.
I think many of them don’t really have a clue if the problem is in the sql or the php code. Or even that there is a dedicated MySQL forum.
Well, if I believed that someone posts in the wrong forum on purpose, I’d just ignore him Never happened so far. And I really don’t think you’ll get an answer sooner in the PHP forum than in the MySQL one.
Besides, posting in the right forum increases your chances of getting a CORRECT answer.
Well yes if they were completely different forums. But most PHP developers do tend to use mysql databases anyway and have a good grasp of it. So I don’t think they would get an incorrect answer here.
But yeah, they should post in the right forum.
But then again, this topic has nothing to do with php the language either.
Actually the problem or my opinion is, though it is a SQL problem, some programmers things that…it is related to PHP, why bcoz they are using PHP code and it is not working properly.
so they think that, it should be a part of PHP rather than MySQL.bcoz the interface is PHP, my point is clear ?
