[Phpmyadmin-devel] strange " bug

Alain Brissaud alain at brissaud.com
Tue Aug 7 19:44:47 CEST 2001


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.

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

No problem if you key is an int. Yuk.



P.S : php 4.0.5, phpmyadmin cvs, mysql 3.23.39

More information about the Developers mailing list