php rotation of banners via array

Question

I got 20 flash banners, 10 armenian ones, 10 english ones.

$query="SELECT* FROM `reklam` LIMIT 5";
$result=mysql_query($query);

while($row=mysql_fetch_array($result)) {
    if($_SESSION['lang']=='arm') {
        $swf_name=$row['swf_arm'];
    } else {
        $swf_name=$row['swf_eng'];
    }
echo'<tr>
        <td>
        <div style="text-align: center">
            <object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" width="290" height="299" align="middle">
                <param name="movie" value="reklam/'.$swf_name.'.swf" />
                <param name="quality" value="high" />
                <param name="bgcolor" value="#ffffff" />
                <param name="play" value="true" />
                <param name="loop" value="true" />
                <param name="wmode" value="transparent" />
                <param name="scale" value="showall" />
                <param name="menu" value="true" />
                <param name="devicefont" value="false" />
                <param name="salign" value="" />
                <param name="allowScriptAccess" value="sameDomain" />
                <!--[if !IE]>-->
                <object type="application/x-shockwave-flash" data="reklam/'.$swf_name.'.swf" width="290" height="299">
                    <param name="movie" value="reklam/'.$swf_name.'.swf" />
                    <param name="quality" value="high" />
                    <param name="bgcolor" value="#ffffff" />
                    <param name="play" value="true" />
                    <param name="loop" value="true" />
                    <param name="wmode" value="transparent" />
                    <param name="scale" value="showall" />
                    <param name="menu" value="true" />
                    <param name="devicefont" value="false" />
                    <param name="salign" value="" />
                    <param name="allowScriptAccess" value="sameDomain" />
                <!--<![endif]-->
                    <a href="http://www.adobe.com/go/getflash">
                        <img src="http://www.adobe.com/images/shared/download_buttons/get_flash_player.gif" alt="Get Adobe Flash player" />
                    </a>
                <!--[if !IE]>-->
                </object>
                <!--<![endif]-->
            </object>
        </div>
        </td>
        </tr>';
        }

The name of the banners are coming from database. If site language is set on armenian, it should appear armenian banners, if english - english one (session). As i said there is 10 banners, but i need to show 5 at once, so i included in query LIMIT 5. Now the task is, i need to do rotation of that banners. I mean when i refresh the page, it should choose banners randomly. How should i do it?

Thanks!

Spudley · Accepted Answer · 2013-05-13 10:55:08Z

4

There are a whole bunch of ways to do this, but given that there's only a small number of records, you don't need to do anything too clever.

The easy options for you are:

Use ORDER BY RAND() in the SQL query.
Just load all the records, use PHP's shuffle() function to randomly re-order the array, and then just show the first five from the array.

To be honest, with the number of records you're talking about here, it won't make a huge amount of difference. For larger databases, neither of these options is a good idea, for performance reasons, but for tables as small as the one you've got both are perfectly fine.

answered May 13, 2013 at 10:55

Spudley

169k39 gold badges240 silver badges309 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Edwin Alex · Accepted Answer · 2013-05-13 10:36:26Z

4

You can use MYSQL RAND()

$query="SELECT* FROM `reklam` ORDER BY RAND() LIMIT 5";

answered May 13, 2013 at 10:36

Edwin Alex

5,0944 gold badges31 silver badges51 bronze badges

Comments

Svetoslav · Accepted Answer · 2013-05-13 10:58:55Z

0

You can add 1 field at your Table called - views (int)

To pick the banner with the less displays and after that run 1 update:

$sql = "SELECT * FROM `reklam` ORDER BY `views` ASC LIMIT 5";
$sql = "UPDATE `reklam` SET `views`=`views`+1 WHERE ID IN(IDS FROM SELECT)";

This way you will get and statistics how much displays your ads have..

answered May 13, 2013 at 10:58

Svetoslav

4,6872 gold badges30 silver badges43 bronze badges

Collectives™ on Stack Overflow

php rotation of banners via array

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related