What the heck? Totally Clueless as to why this simple query doesn't work.

FoxhoundX

$sql = mysql_query("INSERT INTO rpg (username, password, email, str, end, agi, wis, int) VALUES('$username', '$password', '$email', '$str', '$end', '$agi', '$wis', '$int')") or die (mysql_error());

Returns with

You have an error in your SQL syntax near 'int) VALUES('God', 'snip', 'Firebird@t4cbible.com', '20', '20', '20', '10', '' at line 1

Obviously, it's the $int variable which isn't being inserted correctly. However, I can $echo it just fine, meaning something would be wrong with the statement.

Help?

dougmcc1

INT is probably a reserved word. Try renaming it to something else.

drawmack

1) that is the problem

2) that was the problem the last 6 times a noob decided to make an rpg using php

3) the boards have a search feature

4) the boards also have an ignore button

<?php
if(2) {
   echo "<b>STFF</b>";
   click 4
}
?>

jediman

4) the boards also have an ignore button

Noobs are noobs...sometimes you can't expect a NEW PERSON to know what to do flat right out unless its spelled out for them you know! We have all been new before, so what gives you the right to put others down in such a manor?

Your reply was a bit rude now wasn't it?

FoxhoundX

Wow, I don't think that was called for.

I don't consider myself a newbie to PHP at all -- It's just that I have never read about reserved words which couldn't be used. I tried searching, but I didn't come up with anything.

I could really care less if you chose to ignore me, you seem like an idiot anyways.

jediman

I'm with you Fox! If someone is not going to post something relevant to the situation, then do not post at all.

Fox, int is reserved. It specifies a type, so you can not use it. The best solution would be to use something along the lines of brain, or intg , although its best to not use anything close to a reserved word. Brain or brainpower would work too, plus you still know what it would represent. I hope that helps 🙂

drawmack

I'm an idiot that knew the answer to your question.

FoxhoundX

No, you are an idiot that just confirmed what dougmcc1 said.

You are still an idiot nonetheless. I have never had the need for an 'int' field before, so Why Would I have the need to KNOW that it is a reserved name?

drawmack

I'm sorry my comments were uncalled for.

However so is name calling, I am not an idiot - that implies stupidity and if you take a look at some of the code I've posted in other places you'll see that is not true.

Next time please search the forums and the appropriate manuals before posting.

Danicek

It is useful to search forums and manuals.
However sometimes it takes too much time and I believe forums are right place to ask about such things.
Every forum member (and longtime member much more) must know that he/she will be forced to listen to same questions again and again. And it is not a bad thing. Because otherwise nearly all forums could be closed, because there is not large amount of questions that were never answered.

This is little bit offtopic. But I still think that to be rude just because poeple have same and same and same problems is not a good decision (you know, anger is not healthy) :].

stolzyboy

However sometimes it takes too much time and I believe forums are right place to ask about such things.

That is the only thing I have a reply for. I have searched and searched many time before to find my answer. Why would I want to waste my time helping someone that needs an answer without even taking their own time to find that answer?

You have to do a little work before you ask questions, or you won't learn by your mistakes. It's just like cheating on homework in primary schooling, come test time, you won't know the answer.

Search, Search, dig, dig, for the answer, who knows , you may surprise yourself!

🙂 stolzyboy

Danicek

Ok, you are right

[: taking shovel, pick, overalls, 1 kg chocolate (for energy) and heading to forest :]

FoxhoundX

I did take quite some time searching -- However, I didn't know what i was searching for. I looked into the INSERT INTO Query for quite some time, rewriting my query numerous times. I had no clue that PHP had reserved words.

When you don't know what to search for, I find it fairly difficult to actually conduct a search. As I said above, I had searched for quite some time, looking for people with the same problem, but with lack of an actual explanation, it's difficult to find the same problem.

Sorry for wasting everyone's time,
Thanks for the answer,

Fox.

stolzyboy

My post wasn't geared towards you persay, it was geared more towards Danicek's response.

However sometimes it takes too much time and I believe forums are right place to ask about such things.

LordShryku

If anything, check the sticky threads on the forum. They contain links to the most common problem/answers. The very top one on this forum has a link to the MySQL Reserved Words list. I think the general advice here is to look around a bit before you post. More than likely, something related to what your problem is has been posted before.

dougmcc1

Ok, I'm glad we got that settled 🙂

Now can anybody help me with my question?

http://www.phpbuilder.com/board/showthread.php?l.s=&threadid=10261637

Thanks.