wakerider017
-
Posts
2 -
Joined
-
Last visited
Never
Posts posted by wakerider017
-
-
I am trying to create an advertisement table just like LS1tech.com...
Yet I am having some difficulties...
NOTE: I am using Vbulletin...
This is my database that I have setup:
[a href=\"http://img107.imageshack.us/img107/4594/help6oo.jpg\" target=\"_blank\"]http://img107.imageshack.us/img107/4594/help6oo.jpg[/a]
Since the advertisement table is in th template I can not directly use php...
I need to put the php in another file and then call on it in the template...
Here is what I have so far:
[code]$sql = "SELECT * FROM `table_name` ORDER BY RAND()";
$result = mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_object($result))
{
$ads_HREF = "$row->HREF";
$ads_SRC = "$row->SRC";
$ads_ALT = "$row->ALT";
}[/code]
and I call on it with this:
[code]<tr><td>
<a href='$ads_HREF'><img src='$ads_SRC' name='$ads_ALT' border=0></a></td></tr> [/code]
but... there is a problem with this... it shows the same ad 5 times! I want 5 different ads!
I think I may need to use an array... but I am not sure how...
Anyone want to help?
rotaing banner ads... Need help!
in PHP Coding Help
Posted
$i=0;
$number_of_ads= //Enter the number of ads;
while($i<number_of_ads)
{
?>
<tr><td>
<a href='<?php echo($ads_HREF[$i]); ?>'><img src='<?php echo($ads_SRC[$i]); ?>' name='<?php echo($ads_ALT[$i]); ?>' border=0></a></td></tr>
<?php
$i++;
}//close while;
?>[/code]
That looks good.... except this is for my forums... I can not use PHP in the template...
So i need php and then I call on it with HTML...
Thats why I had two seperate codes in the first post!
Thanks a bunch!
Do you think your array code could be altered to do what I am looking for?