<div dir="ltr"><div>Hello all, I'm becoming a regular here now, aren't I?</div><div><br></div><div>So I have this table in mysql:</div><div><span style="font-family:monospace,monospace">+----------+----------+--------+-----------+---------+<br>| key_name | key_type | value1 | value2 | value3 |<br>+----------+----------+--------+--------+--------+<br>| key1     | 1        | valueA | valueF | valueK |<br>| key1     | 1        | valueB | valueG | valueL |<br>| key1     | 1        | valueC | valueH | valueM |<br>| key2     | 1        | valueD | valueI | valueN |<br>| key2     | 1        | valueE | valueJ | valueO |</span></div><div><span style="font-family:monospace,monospace"><br></span></div><div>I was hoping I could have all this information available in an sht, where for example:</div><div><pre class="gmail-programlisting">$sht(a=>$key1[0]), $sht(a=>$key1[1]), etc<br></pre><pre class="gmail-programlisting"><span style="font-family:arial,helvetica,sans-serif">would </span>return:<br></pre><pre class="gmail-programlisting">"valueA,valueF,valueK", "valueB,valueG,valueL" etc</pre><pre class="gmail-programlisting"><span style="font-family:arial,helvetica,sans-serif">but I can't figure out how to setup htable to import this data on restart. I have tried various combinations of module parameters such as:<br><br></span>modparam("htable", "htable", 'my_htable=>size=8;autoexpire=86400;dbtable=my_table;cols="key_name,<span style="font-family:monospace,monospace">value1,value2,value3</span>";'<br></pre><pre class="gmail-programlisting"><span style="font-family:arial,helvetica,sans-serif">I'm either getting errors, or dumping htable will only show one of the value sets (key_type is not set to array).</span><br></pre><pre class="gmail-programlisting"><span style="font-family:arial,helvetica,sans-serif">Does anyone have a working config to share? Thanks!<br></span></pre><pre class="gmail-programlisting"><span style="font-family:arial,helvetica,sans-serif">George</span><br></pre></div></div>