[PHP-DB] newbie PHP/MySQL question

2006-01-02 Thread toylet
A table with a column big5 char(2) not null primary key. $target->query("delete from canton"); for ($ii=0; $ii<256; $ii++) { for ($jj=0; $jj<256; $jj++) { echo $ii .".". $jj . "\n"; $query="insert into canton ( big5 ) values ( '" . mysql_real_escape_string(chr($ii).chr($j

Re: [PHP-DB] newbie PHP/MySQL question

2006-01-03 Thread toylet
yes. Note the "delete from canton" query. I found something. case.. Somehow, mysql treat "A" the same as "a" Maybe from a previous query? I mean, did you make sure the table was clear > before starting the script? > > $target->query("delete from canton"); > > for ($ii=0; $ii<256; $ii++) {