4 replies to this topic

[Pbkilldezines]

OK, I have an affiliate script that I am testing. The way it works is the link is dynamicly generated with an ID, img location, and a counter. How ever the way I want it to look makes it so that the whole page has a line like this::

| AFFILIATE BUTTON |
|________________ |
|Clicks Out:: |
|_________________|

| AFFILIATE BUTTON |
|________________ |
|Clicks Out:: |
|_________________|

| AFFILIATE BUTTON |
|________________ |
|Clicks Out:: |
|_________________|

| AFFILIATE BUTTON |
|________________ |
|Clicks Out:: |
|_________________|

| AFFILIATE BUTTON |
|________________ |
|Clicks Out:: |
|_________________|

| AFFILIATE BUTTON |
|________________ |
|Clicks Out:: |
|_________________|




But how I want it is so that its in colunms insted of one straight row so the long line of affiliates is broken up into 2 or more cloumns.

Here is the PHP for my affiliate script:

$table = "aff_affiliates";

$sql= mysql_query("SELECT * , id , hits FROM $table");

while($row = mysql_fetch_assoc($sql))
{
echo "
<a href=\"http://www.pbkill.com/*.php?id=".$row[id]."\" target=\"_blank\"><img src=\"".$row[button]."\" border=\"0\"></a>
<br>
<font color=\"#CCCCCC\">Clicks Out: ".$row[hits]."</font>
<br>
<br>
";
}
}

PLEASE HELP!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[shao]

Why don't you use the html table format and have your desired number of columns that way. Simply open tr and close tr for say 2 records or more and than loop.

[Pbkilldezines]

Could you elabertate more on this?

[Gio]

Check out my tutorial in the php tutorials forum for a brief display of html formatting sql output. Its called affiliation tutorial or something like that

[rc69]

$sql= mysql_query("SELECT * FROM aff_affiliates");

while($row=mysql_fetch_assoc($sql))
{
echo "\n<a href=http://www.pbkill.com/*.php?id=$row[id] target=_blank><img src=$row[button] border=0></a>
<br>
<font color=#CCCCCC>Clicks Out: $row[hits]</font>
<p>\n";
}

that would probably work a little better for you... but you lost me on what you wanted to acctually do

do you want something that deals the way the affiliates are stored in the databse
or something with the way they are displayed on your site?

if you wanted something on the way they are displayed, use tables and the switch() function for 2 column display (if you want help with that just ask and i can probably figure something out).

either way, please do elaborate a little bit on what you want