Categories > TinyButStrong general >

How use two tr and two td with mysql?

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs
By: jiichen
Date: 2005-08-18
Time: 04:31

How use two tr and two td with mysql?

I wash look the result:
<tr><td bgcolor=#79D2FE>1</td><td>2</td></tr>
<tr><td bgcolor=#B2E3FE>3</td><td>4</td></tr>
<tr><td bgcolor=#79D2FE>5</td><td>6</td></tr>....

but line 1 is <tr><td>1</td><td>1</td></tr>
line 2 is <tr><td>2</td><td>3</td></tr>
line 3 is <tr><td>4</td><td>5</td></tr>



PHP:
$TBS->MergeBlock('news10',$conn,'SELECT * FROM news LIMIT 10');


HTML:
<table>
    <tr>
              <td height="18" bgcolor="#79D2FE">&nbsp;<a href="/news.php">[news10.#]. [news10.title;block=tr]</a></td>
              <td bgcolor="#79D2FE">&nbsp;<a href="/news.php">[news10.#]. [news10.title;block=td]</a></td>
            </tr>
                        <tr>
              <td height="18" bgcolor="#B2E3FE">&nbsp;<a href="/news.php">[news10.#]. [news10.title;block=td]</a></td>
              <td bgcolor="#B2E3FE">&nbsp;<a href="/news.php">[news10.#]. [news10.title;block=td]</a></td>
            </tr>
</table>
By: Skrol29
Date: 2005-08-18
Time: 10:15

Re: How use two tr and two td with mysql?

Hello,

Use alternative sections and parameter 'serial'.
Example:
<table>
  <tr>
    <td bgcolor=#79D2FE>[news10;block=tr;serial][news10_1.#]. [news10_1.title;block=td]</td>
    <td>[news10_2.#]. [news10_2.title;block=td]</td>
  </tr>
  <tr>
    <td bgcolor=#B2E3FE>[news10;block=tr;serial][news10_1.#]. [news10_1.title;block=td]</td>
    <td>[news10_2.#]. [news10_2.title;block=td]</td>
  </tr>
</table>


By: jiichen
Date: 2005-08-18
Time: 17:01

Re: How use two tr and two td with mysql?

Thank you very much. It is right.