Scroller Content driven by a MySql Query

[graharo]

Hi, I am trying to create a scroller where the images are driven by a MySql querry, here is what I have... the query works but when I embed it in the scroller code it does nothing... suggestions

 

<table border="0" cellpadding="0" cellspacing="0" class="scroller">

<td>

<table border="0" style="border-collapse: collapse" id="table1" cellpadding="0" width="100%">

<div>

<?php

$result = tep_db_query("select products_image from " . TABLE_PRODUCTS);

while ($nt = tep_db_fetch_array($result)) {

$img = "babiesarelove3tier_1.jpg";

?>

<tr><td width="33%" align="center" style="font-size: 8pt" class="style4">

<img src="../images/<?php echo $img;?>" width="177"/></td></tr>

<?php

}?>

</div>

</table>

</td>

</table>

[steve_s]

Hi, I am trying to create a scroller where the images are driven by a MySql querry, here is what I have... the query works but when I embed it in the scroller code it does nothing... suggestions

 

<table border="0" cellpadding="0" cellspacing="0" class="scroller">

<td>

<table border="0" style="border-collapse: collapse" id="table1" cellpadding="0" width="100%">

<div>

<?php

$result = tep_db_query("select products_image from " . TABLE_PRODUCTS);

while ($nt = tep_db_fetch_array($result)) {

$img = "babiesarelove3tier_1.jpg";

?>

<tr><td width="33%" align="center" style="font-size: 8pt" class="style4">

<img src="../images/<?php echo $img;?>" width="177"/></td></tr>

<?php

}?>

</div>

</table>

</td>

</table>

why not simply alter this mod http://addons.oscommerce.com/info/5161 form specials to just product images