My rant for the day.

Status
Not open for further replies.
Nate

Nate

New member
Nov 10, 2006
95
0
0
NY
So I am not a very good programmer, but I'd like to think I know the very basics. Anyway, I purchase a database from a well known software site and I cant get it to work with php for the life of me.

I kept getting a conflict with one of the columns in the database I bought. I'd take the column out and all would work, put it back in and it wouldn't work. Me being a noob I decide to hire a programmer to get this to output it how I want. He tells me there is some major error in the database I purchased. Saying, "I can get it to work, but I will have to redo much of the code and it will take a long time." I say screw it and just send me the code he has complete.

Now I'm thinking wtf, I've now spent a couple hundred on what seems like useless info. I have to make this work somehow....after dickin around for about 30 minutes, I ended up renaming one word of the entire database. I renamed the column from 'desc' to 'a_dumby_name' and it works like a charm. wtf:mad: Is 'desc' a protected word/command in mysql?
 


You're right, it does probably belong there, but the programmer was from sitepoint and he obviously didn't know the answer to the prob. This is the programming section...excuse my bitching, but I was pissed.
 
desc is a MySQL protected word. Basically just means to put in descending order, the opposite is asc
 
Nate, ignore him you posted in the right place and as was said before it is a protected word. If you're paying a programmer to do mysql/php development he SHOULD know this. He should also know that a quick fix is just putting backticks around the column name though naming a column desc isn't that great of an idea.
 
Status
Not open for further replies.
Top Bottom
Back