E' questo il codice:
Codice PHP:
<?php if(empty($_GET['category'])){
$uno = mysql_query("SELECT nome_categoria FROM scripts WHERE tipo = 'html_javascript'");
$due = mysql_query("SELECT nome_categoria FROM scripts WHERE tipo = 'php'"); ?>
<table style="width: 100%">
<tr>
<td style="width:297px"><div class="centrale"><span class="rosso">JavaScript (JS)</span></div></td>
<td style="width:297px"><div class="centrale"><span class="rosso">PHP</span></div></td>
</tr>
<?php
$n1 = mysql_num_rows ($uno);
$n2 = mysql_num_rows ($due);
for ($i = 0; $i < min ($n1, $n2); $i++){
$temp = mysql_fetch_array($uno);
$temp2 = mysql_fetch_array($due);
$html = $temp[nome_categoria];
$php = $temp2[nome_categoria];
echo "<tr>
<td style=\"width:297px\"><img src=\"immagini/directory.png\" alt=\"Directory Categoria $html\" /> <a href=\"script.php?category=$html\">$html</a></td>
<td style=\"width:297px\"><img src=\"immagini/directory.png\" alt=\"Directory Categoria $php\" /> <a href=\"script.php?category=$php\">$php</a></td>
</tr>";
}
while ($temp = mysql_fetch_array($uno)) {
$html = $temp[nome_categoria];
echo "<tr>
<td style=\"width:297px\"><img src=\"immagini/directory.png\" alt=\"Directory Categoria $html\" /> <a href=\"script.php?category=$html\">$html</a></td>
<td style=\"width:297px\"> </td>
</tr>";
}
while ($temp2 = mysql_fetch_array($due)) {
$php = $temp2[nome_categoria];
echo "<tr>
<td style=\"width:297px\"> </td>
<td style=\"width:297px\"><img src=\"immagini/directory.png\" alt=\"Directory Categoria $php\" /> <a href=\"script.php?category=$php\">$php</a></td>
</tr>";
} ?>
</table>