PDA

View Full Version : MySql Error in User


julius
Fri 3rd Nov '00, 5:16am
I make:

I choose Table: user
I choose Select
I choose Username
I put a username
Db shows me the record
I make or not changes
I click save


MySql gives me this error:

Database lettecom - table user
Error
SQL-query:

SELECT username from user where 1 and username like \\
MySQL said: You have an error in your SQL syntax near '\\' at line 1
Back


Anybody can help me?

Thank you

shashi
Fri 3rd Nov '00, 10:27am
You forgot to mention you are using phpMySql.
Yes I was able to recreate the problem.

But did you notice that even though it gave the error, it completed the save!!
I go back in and look at the record again and I find it has been updated properly!

julius
Fri 3rd Nov '00, 11:47am
You're true, I was talking about PhpMyadmin!
Yes it's true, it's updated, but why is there an error?
I'm a little worried about that, maybie the reason will come out in the future, with a bigger error!

Thanks