i have this code
[code=php]//ads_frontpage
$ad = mysql_query(“SELECT * FROM _ads ORDER by ad_id DESC LIMIT 3″);
$dynamic[‘adhead’] = ‘<center><table width=”70%” cellpadding=”0″ cellspacing=”0″ border=”0″ class=”front_ads”><tr>’;
while($adq = mysql_fetch_array($ad)){
$dynamic[‘adbody’] = sprintf(‘<td><a href=”http://’.$adq[‘adurl’].'”><img src=”‘.$adq[‘adimage’].'” border=”0″ alt=”‘.$adq[‘addesc’].'” title=”‘.$adq[‘adname’].’ – ‘.$adq[‘addesc’].'”/></a></td>’);
}
$dynamic[‘adfoot’] = ‘</tr></table></center>’;
$dynamic[‘ads’] = $dynamic[‘adhead’].$dynamic[‘adbody’].$dynamic[‘adfoot’];
let’s say i have 3 items in the database and i need to put it in stream..all three in the loop…
how can i do it?….
please respond…