random... Need a little help

[wakerider017]

Ok this is the code I have so far:

$sql = "SELECT * FROM `ads` 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";
}

I am to call on this code within my forums using this:

<a href='$ads_HREF'><img src='$ads_SRC' name='$ads_ALT' border=0></a>

Here is my problem:

I have 5 ads in my database And I want all 5 to show up in a random order. Right now 5 of the same ad appears.

I think I may need to use fetch_array to do this.... But I am not sure how to do it????

Anyone know?

[Installer]

If your html-generating code is within the while block, it should work. Otherwise, yes, you'll end up with five identical links, all being the last one of the random set.

BTW, the quotes are unnecessary.

[wakerider017]

I am using this for my forums.... and my forums can not have php i the template....

So I am storing the actual php in another file...

I am putting the html in the forums template...

What do you think

Here is my site if you want to look:

http://lsxgto.net/?styleid=9

[Installer]

Since the template apparently will accept PHP variables, how about an array?

[wakerider017]

Installer wrote:

Since the template apparently will accept PHP variables, how about an array?

Can you show me what that looks like?

I am sorry but I am very new at this... Up until 2 weeks ago the only thing I ever touched was html... :o

[laserlight]

Retrieve 5 records in random order, then print them in a loop:

$sql = "SELECT * FROM `ads` ORDER BY RAND() LIMIT 5";
$result = mysql_query($sql) or die(mysql_error());

while ($row = mysql_fetch_assoc($result))
{
	echo '<a href="' . $row['HREF'] . '">' . '<img src="'
		. $row['SRC'] . '" name="' . $row['ALT'] . '" alt="' . $row['ALT']
		. '" border="0"></a>';
}

[wakerider017]

laserlight wrote:

Retrieve 5 records in random order, then print them in a loop:

$sql = "SELECT * FROM `ads` ORDER BY RAND() LIMIT 5";
$result = mysql_query($sql) or die(mysql_error());

while ($row = mysql_fetch_assoc($result))
{
	echo '<a href="' . $row['HREF'] . '">' . '<img src="'
		. $row['SRC'] . '" name="' . $row['ALT'] . '" alt="' . $row['ALT']
		. '" border="0"></a>';
}

that works AWESOME! but... it puts all the ads on the top of my page 🙁

look: http://lsxgto.net/?styleid=9

[laserlight]

If something is not where you want it to be, just move it.

[wakerider017]

Here is my entire template for the banner:

<!-- logo -->

<table width="$stylevar[outertablewidth]" border="0" cellpadding="0" cellspacing="0" align="center">
	<tr>

<td width="120" valign="top" style="padding: $stylevar[cellpadding]px;">




<img border="0" src="/vendors/filler5.gif" width="120" height="160">















<table bgcolor="#000000" border="1" bordercolor="#cccccc" width="120" id="table1">
	<tr>
		<td align="center"><font color="#cccccc" size="1">Vendors</font></td>
	</tr>


<tr><td>
<a href='$ads_HREF'><img src='$ads_SRC' name='$ads_ALT' border=0></a></td></tr> 

<tr><td>
<a href='$ads_HREF'><img src='$ads_SRC' name='$ads_ALT' border=0></a></td></tr> 

<tr><td>
<a href='$ads_HREF'><img src='$ads_SRC' name='$ads_ALT' border=0></a></td></tr> 

<tr><td>
<a href='$ads_HREF'><img src='$ads_SRC' name='$ads_ALT' border=0></a></td></tr> 

<tr><td>
<a href='$ads_HREF'><img src='$ads_SRC' name='$ads_ALT' border=0></a></td></tr> 






<tr><td><a target="_blank" title="Click Here to Become a Vendor!" href="http://lsxgto.net/payments.php">
		<img src="http://lsxgto.net/vendors/logo3.jpg" border="0"></a></td>
	</tr>


</table>






<p>&nbsp;</p>






<table bgcolor="#000000" border="1" bordercolor="#cccccc" width="120" id="table1">
	<tr>
		<td align="center"><font size="1" color="#CCCCCC">Our Other Sites:</font></td>
	</tr>



<tr><td><a target="_blank" title="StangForums.net" href="http://stangforums.net">
		<img src="vendors/othersites/stang.gif" border="0"></a></td>
	</tr>


</table>




<p>&nbsp;</p>



<!-- BANNER HERE -->







<p>&nbsp;</p>


<!-- BANNER HERE -->



<p>&nbsp;</p>


<!-- BANNER HERE -->







</td>

<td valign="top">







<a name="top"></a>
<table border="0" width="$stylevar[outertablewidth]" cellpadding="0" cellspacing="0" align="center">
<tr>






<td align="center"><a href="$vboptions[forumhome].php?$session[sessionurl]"><img src="$stylevar[titleimage]" border="0" alt="$vboptions[bbtitle]" /></a></td>







</td>
</tr>
</table>
<!-- /logo -->


















<!-- content table -->
$spacer_open

$_phpinclude_output

[laserlight]

That means you need to populate your template variable as an array:

$sql = "SELECT * FROM `ads` ORDER BY RAND() LIMIT 5";
$result = mysql_query($sql) or die(mysql_error());

$ads = array();
while ($row = mysql_fetch_assoc($result))
{
	$ads[] = array(
		'HREF' => $row['HREF'],
		'SRC' => $row['SRC'],
		'ALT' => $row['ALT']
		);
}

Then later use $ads[0]['HREF'] etc.

[wakerider017]

laserlight wrote:

That means you need to populate your template variable as an array:

$sql = "SELECT * FROM `ads` ORDER BY RAND() LIMIT 5";
$result = mysql_query($sql) or die(mysql_error());

$ads = array();
while ($row = mysql_fetch_assoc($result))
{
	$ads[] = array(
		'HREF' => $row['HREF'],
		'SRC' => $row['SRC'],
		'ALT' => $row['ALT']
		);
}

Then later use $ads[0]['HREF'] etc.

like this:

<a href=$ads[0]['HREF']><img src=$ads[0]['SRC'] name=$ads[0]['ALT'] border=0></a>

[wakerider017]

function getSponsorBanner()
{
         $ads = $db->query_first("
                 SELECT          *
                 FROM            ads
                 ORDER BY        rand()
                 ");

      if ($db->num_rows($ads) == 0)
              return NULL;

    while ($adrow = $db->fetch_array($ads)) {
  $retStr .= "<tr>  

         <td ><a href=\"$adrow[web]\" target=\"_blank\" title=\"$adrow[company]\"><img src=\"images/ads/$adrow[button]\" border=\"0\"></a></td>
       </tr>";
    }
         return "$retStr";

}

[wakerider017]

this is the code phpadsnew gives me:

<?php
    if (@include('/homepages/1/d154697587/htdocs/gto/phpadsnew/phpadsnew.inc.php')) {
        if (!isset($phpAds_context)) $phpAds_context = array();
        $phpAds_raw = view_raw ('', 0, '', '', '0', $phpAds_context);
        $phpAds_context[] = array('!=' => 'bannerid:'.$phpAds_raw['bannerid']);
        echo $phpAds_raw['html'];
    }
?>