hi..<br>
i'm trying to insert value into list according to the key (ASCII) that i generate..<br>
<br>
example :<br>
<br>
win = 95, so must insert into list[95]<br>
and = 70, so must insert into list[70]<br>
<br>
this is my coding..<br>
__________________________________________________ ________________<br>
<br>
list = []<br>
<br>
try:<br>
conn = MySQLdb.connect (host = "localhost",<br>
user = "root",<br>
passwd = "508420",<br>
db = "myimg")<br>
except MySQLdb.Error, e:<br>
print "Error %d: %s" % (e.args[0], e.args[1])<br>
sys.exit (1)<br>
<br>
cursor = conn.cursor()<br>
<br>
<br>
cursor.execute ("SELECT word,id,freq,indeks FROM tablesusun")<br>
<br>
for(word,id,freq,indeks) in cursor.fetchall():<br>
<br>
first = ord(word[0])<br>
second = ord(word[1])<br>
last = first * second<br>
key = last % 100<br>
<br>
for i in range (100):<br>
if i == key :<br>
list.append([i,word])<br>
<br>
else :<br>
list.append([0])<br>
<br>
print list <br>
<br>
cursor.close ()<br>
conn.commit ()<br>
conn.close ()<br>
__________________________________________________ ________________<br>
<br>
the ouput is :<br>
[0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0],
[0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0],
[0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0],
[0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0],
[0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [and],
[0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0],
[0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0],
[0], [0];<br>
<br>
[0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0],
[0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0],
[0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0],
[0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0],
[0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0],
[0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0],
[0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [win], [0], [0],
[0], [0];<br>
__________________________________________________ ________________<br>
<br>
i want the output is like this :<br>
<br>
[0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0],
[0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0],
[0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0],
[0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0],
[0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0],
[and], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0],
[0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [0], [win], [0], [0],
[0], [0];<br>
<br>
any ideas?