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/>";
} 

?>

stackumhi

Got a suggestion to use the following code, it does pull all categories from DB but it puts them in a single long row. I need 3 columns of 8 if possible.

Any ideas please?

<?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;}
   } 

$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>";
?>

View Source code:

<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>

Arryn

Seems like you'd want

if(!$i%3){echo "</tr><tr>";$i=0;}

to be

if($i = 3){echo "</tr><tr>";$i=0;}

stackumhi

Hi Arryn,
That does look better but now they are all in a single column. How can I split them into 3 even(ish) columns?

Thanks for your help.

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

jamesjohnson88

Add a LIMIT to your query. 24 should give you an even table (8 rows of 3), then you just need to make sure your code has a counter in to add the the <tr> tags after every three items.

Arryn

head smack

make that $i == 0

Here's something I used recently that is similar:

foreach ($DYS_array as $label => $value_array) {
			echo "<td align=\"right\" class=\"".$panel[$j]."\"><label for=\"".$label."\">".$markernames[$i]." </label>
				<select name=\"".$label."\">";
				echo "<option selected value=\"\"></option>";

			foreach ($value_array as $value) {
				echo "<option value=\"".$value."\">".$value."</option>";
			}
		echo "</select></td>";
		$n++;

		if ($n == 6) {
			$n = 0;
			echo "</tr><tr>";
		}
}

stackumhi

Perfect! Thank you!

Now, can you direct 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.

Arryn

Assuming the links are stored in your database something like this in your while loop:

echo "<td><a href=\"".$array['link']."\">".$array['category']."</a></td>";

where 'link' is whatever the link column name is.

stackumhi

Thanks Arryn.

This is my first real php project. Would it be best to store the urls in the DB? Or create them dynamically?

Example..when home and garden is chosen a new page is built listing all the H & G businesses on the page and the url would just be http://mysite/city/home&garden

Open for suggestions.

Thanks for all your help.