Displaying Results

[raouleduke]

I think I know this but am very tired, I am creating a directory, how do I display the results in an ordered fashion, like instead of going straight down I want to display the results in a two column table with as many rows as it need. the results will be displayed like this
12
34
56
78
etc.

Thanks in advance for any help.

[bad76]

Hi,
you can do it using a nested while/for

for($i=0; $i<$nrows; $i++) 
{
   for($j=0; $j<$ncols; $j++) 
   {
       // if exist row in db do output
   }
   // do change row (<br> or <tr>)
}

[raouleduke]

Can you show me alittle more.
Here is my code:

  <?php
				mysql_connect("","",""); 
				mysql_select_db("");  

                $query = "SELECT * FROM table WHERE CATEGORY LIKE '$category' OR CATEGORY1 LIKE '$category' OR CATEGORY2 LIKE '$category' OR CATEGORY3 LIKE '$category' ";
				$result = mysql_query($query);
				while ($row = mysql_fetch_array($result)){
				for($i=0; $i<$nrows; $i++)  

				{ 
   				for($j=0; $j<$ncols; $j++)  

   				{ 
				printf("<table width='225' border='0' cellspacing='0' cellpadding='0'>
                    <tr>
                      <td><div align='center'><font size='2' face='Verdana, Arial, Helvetica, sans-serif'><strong>%s</strong></font></div></td>
                    </tr>
                    <tr>
                      <td><div align='center'><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>%s</font></div></td>
                    </tr>
                    <tr>
                      <td><table width='225' border='0' cellspacing='0' cellpadding='0'>
                          <tr>
                            <td width='89'><div align='right'><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>%s</font></div></td>
                            <td width='41'><div align='center'><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>%s</font></div></td>
                      		<td width='95'><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>%s</font></td>
                          </tr>
                        </table></td>
                    </tr>
                    <tr>
                      <td><div align='center'><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>%s</font></div></td>
                    </tr>
                    <tr>
                      <td><div align='center'><a href='subsite/". '%s' . "/index.php'><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>Business Profile</font></a></div></td>
                    </tr>
                    <tr>
                      <td><div align='center'><a href='%s'><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>Website</font></a></div></td>
                    </tr>
                  </table>\n",

			  $row["name"],
			  $row["address"], 
			  $row["city"], 
			  $row["state"], 
			  $row["zip"],
			  $row["phone"],
			  $row["subsite"], 
			  $row["website"] 
			  );
			 }
			 }
			 }
			 ?>

Thanks in advance for any help.

[bad76]

It's ok,
just a little thing:

1) align=left for outer table
2) after each inner for

...
printf("<table width='225' border='0' cellspacing='0' cellpadding='0' align='left'> 
...           

         "); 
} echo "<br>";

Other thing: if num of row is not $nrows*$ncols you get an error.
You put anything like if(!empty($row))...

see you

[raouleduke]

I got it figured out it works just the way I want it to but, on the website and subsite of the code, I want to not display that if there is nothing in the record, NULL don't display anything for that row.
Here is the code that works.

  <?php   

				print "<table width='450'>"; 
				$i=0; 
				if(($i%2)==1) print "<tr>"; 
				mysql_connect(""); 
				mysql_select_db("");  

                $result = mysql_query( "SELECT * FROM fmmedia WHERE CATEGORY LIKE '$category' OR CATEGORY1 LIKE '$category' OR CATEGORY2 LIKE '$category' OR CATEGORY3 LIKE '$category' ");
				while ($a_row = mysql_fetch_array ($result) )   

				{   

				$subsite = $a_row["subsite"];
				print "<td>
					<table width='225' border='0' cellspacing='0' cellpadding='0'>
                    <tr>
                      <td><div align='center'><font size='2' face='Verdana, Arial, Helvetica, sans-serif'><strong>{$a_row["name"]}</strong></font></div></td>
                    </tr>
                    <tr>
                      <td><div align='center'><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>{$a_row["address"]}</font></div></td>
                    </tr>
                    <tr>
                      <td><table width='225' border='0' cellspacing='0' cellpadding='0'>
                          <tr>
                            <td width='89'><div align='right'><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>{$a_row["city"]}</font></div></td>
                            <td width='41'><div align='center'><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>{$a_row["state"]}</font></div></td>
                      		<td width='95'><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>{$a_row["zip"]}</font></td>
                          </tr>
                        </table></td>
                    </tr>
                    <tr>
                      <td><div align='center'><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>{$a_row["phone"]}</font></div></td>
                    </tr>
                    <tr>
                      <td><div align='center'><a href='subsite/". $subsite . "/index.php'><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>Business Profile</font></a></div></td>
                    </tr>
                    <tr>
                      <td><div align='center'><a href='{$a_row["website"]}'><font size='2' face='Verdana, Arial, Helvetica, sans-serif'>Website</font></a></div></td>
                    </tr>
					<tr>
                      <td height='18'></td>
                    </tr>
                  </table></td>";  

				if(!(++$i%2)) print "</tr>"; 

			} 
			if(($i%2)==1) print "<td></td></tr>";  
			elseif(($i%2)==2) print "</tr>";  
			print "</table>"; 
			?>

Thanks in advance.

[bad76]

Try with
any if(!empty($subsites) || !empty($websites))
before print.

Be care because this will put any empty cell in table.
You have to do also some like $i--...