Help with combining and displaying array

Anon

I have a link list that will display all links from my "Main" table. I would like to inject advertising links from a second table every so many links (say 20). I can not figure out how to combine the results of 2 different queries and have them display the way I want. What I am looking for is the first 20 displayed results will be from Query1 then the 21st will be the first item from Query2 22nd thru 42 will be from Query1 and so on....

This what I have so far, but do not know how to progress.

Any help would be most appreciated.

<?php

// Include Configuration file
include("userConfig.cfg");

// Get all posts within the main list
$query1 = "select * from tblMainList ORDER BY id DESC";

// Get all advertisement links
$query2 = "select * from tblAdList ORDER BY id";

$result = mysql_query ($query1)
or die ("Query failed");

// Display results in a list

$cat = $r["category"];
$url = $ r["url"];
$desc = $r["description"];
$date = $r["date"];

echo "<a href=\"$url\"><b>$cat</b></a></font> <font color=#0033CC>$desc</font> $date <BR>";

}
echo "</table>

</div>
</td>
</tr>
</table>";

} else {
echo "<p> </p><font color=red><h3><b>No Links Found</b></h3></font>";
}
?>

amcgrath

Try something like this:
$counter = 1;
while ($r = mysql_fetch_array($result)) {

$cat = $r["category"];
$url = $r["url"];
$desc = $r["description"];
$date = $r["date"];

echo "<a href=\"$url\">$cat</a> $desc $date <BR>";

if (!$counter % 20) { // meaning 0
echo
$acat = $ad_array[$counter - 1]["category"];
$aurl = $ad_array[$counter - 1]["url"];
$adesc = $ad_array[$counter - 1]["description"];
$adate = $ad_array[$counter - 1]["date"];

echo "<a href=\"$aurl\">$acat</a> $adesc $adate <BR>";
}
}

amcgrath

I forgot, increment $counter at the end of the first while... $counter++....

vsego

add counter (i.e. $linkIdx = 0 before
while ($r = mysql_fetch_array($result))
After
echo "<a href=\"$url\">$cat</a> $desc $date <BR>";
add
if ((++$linkIdx % 20) && ($add = mysql_fetch_array($result2)))
echo "display add here";

Oh, and after
$result = mysql_query ($query1)
or die ("Query failed");
add
$result2 = mysql_query ($query2)
or die ("Query 2 failed");

I think this should work and is fairily simple.

amcgrath

Verd, thanks for correcting me... your way is a lot smoother and after really looking at mine, i think the possibility of an error appearing is possible.

Anon

Thank you both very much for the help. I will try it and let you know what happens.

Anon

OK, so I have spent the past 4 hours trying to make this work and am still not getting it right (ok, so I'm a tad mental). If I keep the code the way I have it below, I am getting an ad display every other listing (rather than once every 20).

Also, just as a test, I tried to echo out the description only from the tblAdList (using $adescription) and nothing is showing up. So, I now have a blank row every other one.

Can you see what it is I am doing wrong?

Sorry to be a pain in the butt.

<?php

// Include Configuration file
include("userConfig.cfg");

// Get all links in Main Table

$query = "select * from tblMain WHERE date <='$datime' AND date >= '$date2' AND accept='yes' ORDER BY id DESC";

// Get all advertisement links
$query2 = "select * from tblAdList";

$result = mysql_query ($query)
or die ("Query failed");

$result2 = mysql_query ($query2)
or die ("Query 2 failed");

if ($result) {

echo "<table width=100% border=0 cellpadding=10>
<tr bgcolor=$bgcolor valign=top>
<td height=100%>
<div align=left>
<table width=100% border=0 cellspacing=0 cellpadding=0>
<tr>";
$linkIdx = 0;
while ($r = mysql_fetch_array($result)) {
$cat = $r["category"];
$url = $r["url"];
$desc = $r["description"];
$date = $r["date"];

echo "<a href=\"$url\"><b>$cat</b></a></font> <font color=#0033CC>$desc</font> $date <BR>";

if ((++$linkIdx % 20) && ($add = mysql_fetch_array($result2)))
	echo "$adescription<br>";

}
echo "</table>

</div>
</td>
</tr>
</table>";

}
?>

amcgrath

You sre it's not like in your html or something? You look like you're closing the table after the first record...

vsego

To Allen: I wasn't correcting you. Through time here, I got to respect you (and vincent, btw) too much to correct you. You simply posted your message after I started typing mine, so I didn't know you were already on it. :-)
It has to be " if (!(++$linkIdx % 20) && (..." (exclamation mark!) because we want true if $linkIdx can be devided by 20 (i.e. $linkIdx%20 returns 0) and we want false otherwise. I often forget that a%b basicly means "a NOT devidable by b". Sorry 'bout that. :-)