Concatenated Query Problem

[maxabee]

I cannot get my code to work that concatenates multiple lines of a query. I am doing this because there are too many to list on one line. My source code is here:

http://nohsinc.com/idn/functions.phps

Help me please!

~Max

[eoghain]

My god!!! Who built your database?

It is extreemly bad form to have a table that size, it becomes unwieldly for someone to write queries againt (as you are finding out). Besides that it doesn't look like you are validating any of the data in your variables, if that data is comming from the user then you need to make sure you "escape" all of the string values so that a stray ", or more likely a deliberate attack, doesn't screw up the formatting of your query and or mess up your database.

[maxabee]

This was done by a nice Romanian on eLance. Nonetheless, I am losing data right now so I need to make the data at least go into the db and I can clean up everything later... Any ideas?

Thanks!

[eoghain]

I'd recommend that you check each variable for valid data before you put it into your query, and either escape the invalid data or inform your user that the data entered is invalid.

Other than that you are in a very big hole and the only way out is to do alot of digging. You are probably going to have to re-write the entire thing.