fulltext gave an error in mysql_query()

[Sangre]

The following gave me lots of error:

SELECT id, introtext, fulltext, writer FROM table WHERE id='$newsid' LIMIT 1

after doing an hour of googling without results, i found what the error was.

its the 'fulltext'

after i changed the colomname into fultext, and changed the $sql into fultext, it all worked.

Is fulltext an reserved name or something? not a legal columnname?
If so then why does Joomla creates a column with that name 🙂

[dougal85]

yes, fulltext is a reserved word!

http://www.ispirer.com/doc/sqlways38/Output/SQLWays-1-199.html

As to the second part of your question, I've no idea.

[bradgrafelman]

Sangre wrote:

If so then why does Joomla creates a column with that name 🙂

Well, if Joomla works, it's probably because they were smart enough to enclose all of their column/table names with backticks, e.g.:

SELECT `column1`, `column2` FROM `myTable`

[Sangre]

thnx for the feedback, i was really going mental with the errors i could not tell what was wrong 😃