| |
|
|
MAJESTIC FLOORING
LLC | OUR SPONSORS
|
|
| \r\n"; // loop the blank cells in
}
}
if($result){
echo ''."\r\n";
$tdcount = 1; //start cell count at one
while($rows=mysql_fetch_assoc($result)){
if($tdcount % $cols == 1) echo "\r\n"; // check to see if new row needs to be started
echo "";
$id=$rows['category_id'];
include("sponsors/connector-db.inc.php");
$query2="SELECT * FROM sponsor_link_tbl where category_id='$id'";
$result2=mysql_query($query2);
$num2=mysql_numrows($result2);
mysql_close();
if ($num2!=0){
echo "";
}
//if ($num2==0){
//$tdcount=$tdcount-1;}
$i=0;
while ($i < $num2) {
$name_of_company=mysql_result($result2,$i,"name_of_company");
$street=mysql_result($result2,$i,"street");
$city=mysql_result($result2,$i,"city");
$state=mysql_result($result2,$i,"state");
$zip_code=mysql_result($result2,$i,"zip_code");
$website=mysql_result($result2,$i,"website_address");
$description=mysql_result($result2,$i,"description");
echo "
";
echo "".$street."";
echo "
".$city.", ";
echo "".$state.", ";
echo "".$zip_code."";
echo "
".$website."";
echo "
".$description." ";
echo "
";
$i++;
}
" | \r\n";
//if ($num2!=0){
if($tdcount == $num_rows) echo $extra_cells; //echo extra cells into row
//}
//if ($num2!=0){
if($tdcount % $cols == 0) echo " \r\n"; // check to see if row needs to be ended
//}
//if ($num2!=0){
$tdcount++; // add one to cell count
//}
}
echo " \r\n";
}
?>
|
| Vote Here! |
|
|
|
|
|
|
