7 Aug
2001
7 Aug
'01
8:44 p.m.
Hello,
Step 1 :
CREATE TABLE `test` (`id` VARCHAR(50) not null, `txt` VARCHAR(50) not null ,
PRIMARY KEY (`id`), INDEX (`id`));
INSERT INTO `test` (`id`, `txt`) VALUES ('1', 'test "test"
test');
Step 2 :
Use phpmyadmin to Select id 1 (using tbl_select.php3),
Click Edit (do nothing) then click save.
<phpmyadmin>
SELECT `id`,`txt` FROM `test` WHERE 1 AND `id` LIKE \"1\" LIMIT 0, 30
MySQL said: You have an error in your SQL syntax near '\"1\" LIMIT 0,
30' at
line 1
</phpmyadmin>
No problem if you key is an int. Yuk.
Regards,
Alain.
P.S : php 4.0.5, phpmyadmin cvs, mysql 3.23.39