Page 2 of 2

Posted: Sat Aug 04, 2007 1:15 pm
by iknownothing
bdlang wrote:
iknownothing wrote: Should look more like this (may or may not need '' around variables in SQL statement):
No, table and column names SHOULD NOT be surrounded by quotes, please don't confuse the OP any more than necessary.
He would have figured that, if my example did not work the first time, showing an error, it would have if he removed the quotes. I'm only trying to help, no need to go off the deep end.

Posted: Mon Aug 06, 2007 1:42 am
by dream2rule
bdlang wrote:To dream2rule I say this, since all posts thus far have apparently not given you the hint: you're formatting the CREATE TABLE statement as if it were something to display to the end user. Thus, SQL != HTML. Sure, it looks good when the user views the page (and you can copy and paste the output into phpMyAdmin), but MySQL does not understand

Code: Select all

CREATE TABLE sometable (<br>&nbsp;
...

Yes bdlang, i had a problem with &nbsp;(non-breaking space)
MySQL does not understand "&nbsp;" but takes into account if an empty space is given.

Thanks all for replying. The problem seems to have been solved now. :D :D :) :)