[SOLVED] CREATE TABLE PROBLEM

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

User avatar
iknownothing
Forum Contributor
Posts: 337
Joined: Sun Dec 17, 2006 11:53 pm
Location: Sunshine Coast, Australia

Post 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.
dream2rule
Forum Contributor
Posts: 109
Joined: Wed Jun 13, 2007 5:07 am

Post 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 :) :)
Post Reply