is the word 'Starting' a keyword in sql or php? Also is there a link to keywords out there? Spent to much time trying to debug and saw that changing that one word fixes everything.... I see the word Start is a keyword but not starting itself. I guess you can't have words that look the same?

mysql_query("insert into one(Starting) values('$starting')"); didn't work

mysql_query("insert into one(Beginning) values('$beginning')"); worked...

[Edited on November 5, 2008 at 5:45 PM. Reason : ..]

11/5/2008 5:43:54 PM

Quote :

"is the word 'Starting' a keyword in sql or php?"

Yes, Starting is a reserved keyword in MySQL

Quote :

"lso is there a link to keywords out there?"

Seriously?

http://www.google.com/search?q=mysql+reserved+words

http://www.google.com/search?q=php+reserved+words

11/5/2008 5:50:36 PM

yeah search engines are blocked here. so i still can't see your links....

[Edited on November 5, 2008 at 6:02 PM. Reason : .]

11/5/2008 6:01:41 PM

tender your resignation immediately

would not write code under such conditions

11/5/2008 6:40:22 PM

deleted

[Edited on November 5, 2008 at 6:50 PM. Reason : s]

11/5/2008 6:43:26 PM

OMRTFM!

and: this thread is handy

to answer your question, STARTING is used (in at least this example) in the LOAD DATA statement.

example:

LOAD DATA LOCAL INFILE 'myfile.txt'
INTO TABLE mytable
FIELDS TERMINATED BY ','
LINES STARTING BY '' TERMINATED BY '\n';

11/5/2008 8:14:31 PM

yes, STARTING is reserved.


and what sort of fucked up company blocks search engines? i couldn't do my job very well without google.

11/5/2008 8:33:43 PM

i couldn't do my job very well without google.

11/5/2008 9:32:45 PM

LOL at the OP.

11/5/2008 9:33:25 PM