register_globals gives me weird errors...

Feyi

help...

I used to work with register globals On,.. now I'm working on a new project for my final essay for my study and at my work I found out the whole issue about the register_globals.

So at work I decided to code my script the right way, so like $_POST['var'] etc..

At work it works fine, I even try to code flawless with error_reporting(15).

But then,... I'm at home, I want to make some new scripts. Same PhpTriad install as at work. Same scripts as at work, register_globals Off like I have at work.

But it won't put my info in the database..! So I tried to figure out where I was mistaking, cuz I didn't get any errors or warnings..

Then I found out that the fault was here:

         $number=$_POST['number'];
         $week=$_POST['week'];
         $time=$_POST['time'];
         $title=$_POST['title'];
         $country=$_POST['country'];
         $q_home=$_POST['q_home'];
         $q_draw=$_POST['q_draw'];
         $q_away=$_POST['q_away'];

$sql="INSERT INTO match (toto_number, toto_week, toto_time, toto_title, toto_country, q_home, q_draw, q_away) VALUES('$number', '$week', '$time', '$title', '$country', '$q_home', '$q_draw', '$q_away')";

I always did it this way and it's the right way, it always worked and still works on my scripts which work for register_globals on...

Now my problem... I tried to look if the fault was in my database so I used Phpmyadmin to insert a new row into the table.

Then I got something like this:

INSERT INTO `match` (`match_id`, `toto_number`, `toto_week`, `toto_time`, `toto_title`, `toto_country`, `q_home`, `q_draw`, `q_away`) VALUES ('', '12', '23', '13.00', 'title', 'country', '1.45', '1.80', '2.10');

What I saw: ` instead of '

So I tried it out with the `and then my script works..

so what's you're problem you think?

well... why doesn't it work the way it should, with the normal apostrof???

Somebody PLEASE give me an explanation...

My system is the same as my work: Pentium 4 Windows XP
PHP Version 4.1.1, MySql Client API version
3.23.39, Server API CGI

Register_globals is Off, but I already tried it On. I tried all kind of quotes, only these weird ones work.. and it only happens to my register_global=Off kinda scripts...

I'm desperate, someone help me out🙁 🙁

Feyi

By the way... I echo'ed the variables to see if they were filled before inserting them, and they were there...the problem is the quotes.

magical_quotes is on, like it is at my work.

diego25

Don't worry about the back ticks, that's only important when you have weird characters in the field names (like a space).

Have you tried outputting $query and pasting that in PHPMyAdmin?

Have you tried outputting what mysql_Error() returns?

Why do you think it's a problem with quotes?

Diego

Feyi

Ok, here we go again: I outputted the query like you said and putted into phpmyadmin:

My query:

INSERT INTO match (toto_number, toto_week, toto_time, toto_title, toto_country, q_home, q_draw, q_away) VALUES('99', '99', '99', '99', '99', '99', '99', '99')

The outcome of phpmyadmin:

Database auth wordt uitgevoerd op localhost
Fout
SQL-query :

INSERT INTO match (toto_number, toto_week, toto_time, toto_title, toto_country, q_home, q_draw, q_away) VALUES('99', '99', '99', '99', '99', '99', '99', '99')

MySQL retourneerde:

You have an error in your SQL syntax near 'match (toto_number, toto_week, toto_time, toto_title, toto_country, q_home, q_dr' at line 1

I can't see the error....

diego25

Take out the last 2 fields for now, see what happens. Then add one field, test it, and then add the last field.

Diego

Feyi

nothing...🙁

I took the q_home, q_draw and q_away part out.. just nothing happens,.. no errors no nothing,...

andit's so weird it does work when I put the around the columnnames, so INSERT INTO match (toto_number`, etc)

When doing INSERT INTO match ('toto_number', etc) or INSERT INTO match (toto_number, etc) nothing happens... it echos the right query but nothing happens in the database. I double checked the database 1000th of times now. The script that works for me at my work doesn't work here. All scripts that work are the scripts which don't use the $_POST['var'] type of coding..

😕 😕

diego25

Then put the back ticks then 🙂 I guess the underscore is a special character too...(I never use underscores, I just capitalize the second word, like NewsTitle instead of news_title).

Diego

Feyi

oh, I don't think it's a problem with this quotes, but in my opinion it are the wrong quotes.. besides that, I've been coding for two years now, always the ', never the so I'm very very very confused now why it doesn't work.

I just want to know, no.. I NEED to know how to get this thing fixed..

diego25

Well, I know one thing for sure. You're not supposed to use single quotes around field names or table names, coz that would make it a string, instead of a symbol. So that's why you use back ticks.

Try renaming your fields so that they don't have underscores. See if that's why you need to use back ticks...

Diego

Feyi

no, I use underscores in my databases a lot. Besides that, I changed it now, so my query became:

INSERT INTO match(totonumber, totoweek, tototime, tototitle, totocountry, qhome, qdraw, qaway) VALUES('123', '123', '123', '123', '123', '123', '123', '123')

I did the whole thing again, echo query, put it in phpmyadmin, still the same error...

somebody,....??

Feyi

even if I don't use variables and fill in real values I need to use the backticks...😕

Feyi

YEHAAAAAAAAAAAAAAAAAAAAA

NEVER EVER EVER EVER CALL YOUR TABLE MATCH

MATCH is a preserved word!

Dear MySQL, why don't you make an errormessage telling people that they are using a preserved word?!?

But ok, I can sleep again, now my problem has dissapeared..