Longtext and long text

[Anon]

Hello,

thanks in advance for any help provided.

Im having major minor problems with a longtext field.

Its for a news articles table called news.
one of the fields is called text and is set to 'longtext'.

I use a form to input the data into the table. The text field contains the text of the article. I can input the text just fine. and i can extract it and echo it. My problem is that within phpmyadmin, when i try to edit the particular row, i always get an error. i can't even delete it! it always says something like

"You have an error in your SQL syntax near..."

at first i thought it might be that im adding html tags into the article for display purpouses. but thats not it. then i thought i could be because of the (') located throughout the articles (words like "it's"). but when the data is placed in the table the (')'s are excaped automatically.

I have no idea whats going on, and i wish i can explain it better. But if anyone can lend me a hand. i will be very gratefull.

Thank you.

Mike

[[deleted]]

PHPMyAdmin sucks, why does nobody believe me? 🙂

PHPmyadmin is famous for the mistakes it makes with escaping characters.

You can try to change the settings in your php.ini to get it to auto-escape, but you're probably better off using a windows client like mysqlfront.

[Anon]

Hey man, umm thanks for the help in finding a new way to manage, run, and edit mysql databases and tables...

but there is a problem with mysqlfront. Whenever i use it to edit a tinytext field. it changes all the records.

for example if i say i had 6 records, and a field called id where the data in that field is "15_02_02_01" (for day, month, year, article #) and i were to change one of the records' id to another number, then all the records end up with that id!

what is going on here?

first problems with phpmyadmin, and now mysqlfront. please help. Thanks.

Mike

[[deleted]]

Does your table have a auto_increment primary key? if not, give it one, you need it.

[Anon]

why would i need an auto-increment primary key? whats the importance of it? i don't really need it, do i?

how would i go about it setting it up properly?

[[deleted]]

It's a good idea to always give all your tables an auto_incrementing primary key.

You need it when SQL has no other ways of identifying which row you want to edit.

For example, if you have a table like this:
name | price
Apples | 54
Pears | 62
Potatos | 54
Apples | 54

and you want to change the second apple entry to bananas, the SQL would be:

UPDATE table SET name='Bananas' WHERE ... where what?

There is nothing that uniquely identifies the second Apples record, SQL cannot do this, it must fail.

Now if you have an auto_increment PK, the table looks like this:

ID | name | price
1 | Apples | 54
2 | Pears | 62
3 | Potatos | 54
4 | Apples | 54

Now you can identify the second Apples record by it's PK value:

UPDATE table SET name='Bananas' WHERE ID=4;

get the picture? :-)

[Anon]

Ok, i will add another column to the table, you have convinced me. Thanks for your help.

Mike