7 Aug
2001
7 Aug
'01
7: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