benanamen

OP was already advised about his code on another forum and did not implement any of the advice whatsoever. His response was "Could you please write it to me". OP, we are not a coding on demand service. You apparently didn't even attempt to copy and paste the complete working example from the tutorial you were referred to. If you just want someone to write it for you then post a job offer on any of the forums jobs section.

WHERE `district`= {$_SESSION['g_district']} ");

There is no such thing as a "from" tag.

Can you please provide the default sql so we can run the code.

OP, do you seriously think we can do something with PICTURES of CUTOFF CODE?

That is not the way to handle it. Set a unique constraint on the DB column(s) Attempt the insert and catch the duplicate error if any.

OMG! I could care less about your code dude! I was just trying to help you. Good luck getting assistance with that attitude.

Hi @NotionCommotion, long time no chat. This is all interesting stuff. I was just wondering, are you actually having a problem to where this matters or is this just for learning?

Tell you what, if you can provide a zip of your files I will review it and tell you what is wrong.

In that case, just remove the session start from your include files. You should have no need to check if a session has been started.

I'm sorry, I assumed you wanted to learn how to do things better. My bad.

The better approach is to have a single point of entry to the site/application. Then as mentioned, you set the session once in the main file. Here is a free video series tutorial on Php by the Laravel Laracast guy. Even I, after more than 30 years of programming learned several new things. https://laracasts.com/series/php-for-beginners

Sure you could but you are going to need code gymnastics to cover every possible case. Not really optimum IMO. The "extra data input" is a one time insert and you are done with it. At that point, it is as simple as selecting the column in your query.

Based on the site link I would say what you are looking for is a "short name" for the schools. I would add a column to the DB to hold that data. So you have columns city, school_full_name, school_short_name