I can't figure out how to code this...

Anon

Here's my code that needs to be modified:

while($row = mysql_fetch_array($result))
		{ 

		echo "<tr><td bgcolor=$color><CENTER>$row[id]</center>\">";
		echo "<td bgcolor=$color><center><font face=verdana size=1>$row[field1]</font></center></td>\n";
		echo "<td bgcolor=$color><center><font face=verdana size=1>$row[field2]</font></center></td>\n";
						}

So, basically , this while loop fetches data from a table and list them in a html table (the while loop is wrapped around by the start and end code for a html table)

Here's my question, how can I make it so that the html lists, say, 10 rows, then stops for other html codes (like an advertisement) then continues from 11th row after the advertisement?

Is this possible? Can it be done?

Thanks for reading!

Anon

here's an example:

|field 1 | field2 | ID |

| * | * | 3 |

| * | * | 2 |

| * | * | 34 |

Advertisement here

| * | * | 41 |

| * | * | 5 |

| * | * | 10 |

I hope the above made the question easier to understand. Note that the ID is sorted randomly, this is because the table wont be called according to the ID, but to field 1 or 2.

deckrdx

while($row = mysql_fetch_array($result)){
echo "<tr><td bgcolor=$color><CENTER>$row[id]</center>\">";
echo "<td bgcolor=$color><center><font face=verdana size=1>$row[field1]</font></center></td>\n";
echo "<td bgcolor=$color><center><font face=verdana size=1>$row[field2]</font></center></td>\n";

    if($count++ > 9) {
            include("banner_ad.php");
            $count = 0;
    }

}

[deleted]

Yup, simple enough.
Notes:
- remember to first set the $count to zero before starting the loop.
- the include is done several times. That means that you cannot define functions inside the included file, or you will get an error. It might be better to just define a banner function inside your script and call it from inside the loop.
- Ofcourse you'd have to close and re-open the table before and after each advert.
- In some cases you could get an empty table at the bottom of your page,
for example if you put an ad in after every 10 results, and there are exactly 10 results, the add will be printed and the table will be opened again for more results, but there are no more results, so there's an empty table at the end. That may need checking if you use fancy table coloring etc.

Anon

Thank you guys sooo soo much!!

that was fast response 🙂

Anon

so this is the code after I modified it:

while($row = mysql_fetch_array($result))
{

echo "<table border=0 cellpadding=2 cellspacing=1 border=0 width=100%>\n";

echo "<tr><td bgcolor=$color><CENTER>$row[id]</center>\">";
echo "<td bgcolor=$color><center>$row[field1]</center></td>\n";
echo "<td bgcolor=$color><center>$row[field2]</center></td>\n";
}

    $count = 0;

if($count++ >3) {

		echo "</table>\n";
		echo "TESTING ADVERT\n";

		$count = 0;

echo "<table border=0 cellpadding=2 cellspacing=1 border=0 width=100%>\n";

		}


		}

		echo "</table>\n";

Also, If I use that script you showed me, which will display the advert script every 3 rows right? What If I want it to show ONLY once, say after the first 3 rows...

I came up with this:

    $count = 0;
    if($count++ = 3) {
            include("banner_ad.php");
            $count = 4;
           }

Will this work? given that the first script is fixed and working.

Thanks a million!

[deleted]

Yihung:

Think about what you need to do.

do a query
open a table.
-- while there are results of the table...
--- print the results of the query
--- was this the 3rd result?
----yes:
----- close the table
----- print the add
----- open the table
----no: do nothing
-- end while loop
close the table

Now start replacing those lines with the real code, and keep reading it to see if it is still doing what it should.
Don't just cut and paste some routines and hope for the best. 🙂

Anon

Hi vincent..

but really, I thought I did exactly what you said I should have done... 🙁

if($count++ >3) {

echo "</table>\n";
echo "TESTING ADVERT\n";

$count = 0;

echo "<table border=0 cellpadding=2 cellspacing=1 border=0 width=100%>\n";

If it's more than 3 counts, first I echo to close the table, then I echo for advert, reset counter back to 0, then I start another table again...

Does it make sense? To you?

Thanks

Anon

Oops, sorry, it works.. just need some work on table close and open...

I was editing the wrong part of the script that's why it appeared not to be working.

Thanks for the response..

Anon

Also, make sure that you end your rows with </tr>. no-one likes poor html 🙂