foreach help

[stackumhi]

I am trying to display a simple table with 3 columns.

 

I have some business categories in a mysql DB(about 24 of them) and I would like 3 columns of 8 categories. I would like each category to be a link. I have read many posts here but can't seem to find my solution.

 

Any help would be great.

 

Here is my current (wrong)code:

<?php
include 'includes/dbconnect.php';

$result = mysql_query("SELECT category FROM CATEGORIES");
echo "<table cellpadding=\"2\" cellspacing=\"2\">";
$array = mysql_fetch_array($result);

foreach ($array as $temp) {
    
	echo "<tr><td>". $temp. "</td>". "<td>".$temp. "<td>".$temp."</tr>";
	echo "<br/>";
} 

?>

[kratsg]

Question... what exactly is going wrong?

 

Also, are the categories the NAMES of the columns or the values of rows in the database?

 

You want to loop through by doing this:

 

<?php
include 'includes/dbconnect.php';

   $result = mysql_query("SELECT category FROM CATEGORIES");
   echo "<table cellpadding=\"2\" cellspacing=\"2\"><tr>";
   $i = 0;
   while($array = mysql_fetch_array($result)){//loop through
      
      echo "<td>". $array['category']. "</td>";
      if(!$i%3){echo "</tr><tr>";}
      $i++;
   } 

$num_rows = mysql_num_rows($result);
$find_colspan = 3 - ($num_rows%3);//if there are 6 rows, this is 0, if there are 7, this is 1.
for($i=0;$i<$find_colspan;$i++){
echo "</td>";
}
      echo "</tr></table>";
?>

[stackumhi]

Thanks for the very fast reply!

 

It is getting closer now...all the cats are being pulled from the DB but they are mostly in a single <tr>.

 

Answer to your question - category is the column name...CATEGORIES is the table name

 

Thank you for any more help you can think of.

 

 

 

Here is the view source:

 

<table cellpadding="2" cellspacing="2"><tr><td>Accommodations - Hotels & Resorts</td></tr><tr><td>Arts & Entertainment</td><td>Automotive</td><td>Business & Professional Services</td><td>Clothing & Accessories</td><td>Community & Government</td><td>Computers & Electronics</td><td>Construction & Contractors</td><td>Education</td><td>Food & Dining</td><td>Government, Community, Schools, Churches</td><td>Health & Medicine</td><td>Home & Garden</td><td>Industry & Agriculture</td><td>Internet</td><td>Legal & Financial</td><td>Media & Communications</td><td>Personal Care & Services</td><td>Real Estate</td><td>Shopping</td><td>Sports & Recreation</td><td>Travel & Transportation</td><td>Wedding Services</td><td>Non-Profits</td></td></tr></table>

 

[kratsg]

Replace:

 

      echo "<td>". $array['category']. "</td>";
      if(!$i%3){echo "</tr><tr>";}
      $i++;

 

With:

 

      $i++;
      echo "<td>". $array['category']. "</td>";
      if(!$i%3){echo "</tr><tr>";$i=0;}

[stackumhi]

I made the change, now all results are in the same row. I would like (if possible) 3 columns with 8 rows.  I added a border of 1 to see results better.

 

<table border="1" cellpadding="2" cellspacing="2"><tr><td>Accommodations - Hotels & Resorts</td><td>Arts & Entertainment</td><td>Automotive</td><td>Business & Professional Services</td><td>Clothing & Accessories</td><td>Community & Government</td><td>Computers & Electronics</td><td>Construction & Contractors</td><td>Education</td><td>Food & Dining</td><td>Government, Community, Schools, Churches</td><td>Health & Medicine</td><td>Home & Garden</td><td>Industry & Agriculture</td><td>Internet</td><td>Legal & Financial</td><td>Media & Communications</td><td>Personal Care & Services</td><td>Real Estate</td><td>Shopping</td><td>Sports & Recreation</td><td>Travel & Transportation</td><td>Wedding Services</td><td>Non-Profits</td></td></td></td></tr></table>

 

Thanks again.

[stackumhi]

Got it working with the code below.

 

Now can anyone help me toward getting each category to be a link to it's corresponding page?

 

Example..."Home & Garden" would be a link to the home & garden page...etc..

 

Thanks again.

 

Working code below:

 

<?php
include 'includes/dbconnect.php';

   $result = mysql_query("SELECT category FROM CATEGORIES");
   echo "<table border=\"1\" cellpadding=\"2\" cellspacing=\"2\"><tr>";
   $i = 0;
   while($array = mysql_fetch_array($result)){//loop through
      
$i++;
      echo "<td>". $array['category']. "</td>";
      //if(!$i%3){echo "</tr><tr>";$i=0;}
  if($i == 3){echo "</tr><tr>";$i=0;}
   } 

$num_rows = mysql_num_rows($result);
$find_colspan = 3 - ($num_rows%3);//if there are 6 rows, this is 0, if there are 7, this is 1.
for($i=0;$i<$find_colspan;$i++){
echo "</td>";
}
      echo "</tr></table>";
?>

[kratsg]

How are the links?

 

is it http://www.yoursite.com/HomeAndGarden?

[stackumhi]

Well, the links do not exist yet...they are next on my to-do list. I would like to have something like http://mysite.com/city/cat_id=123 and then have a page that displays all business listings in that category.

 

But someone suggested keeping my links in a database....?

 

I am open for suggestions.

 

Thanks.

[kratsg]

Well, let's say you retrieve the category based on its id.

 

Is your table structured with each row containing a category also containing some sort of unique row identifier?