Link Table

[PF2G]

Hi, DaniWeb

 

I'm doing a website for a music school and i have a table with all the instruments:

 

 

And i want to click in one image and it goes to other page where's the instrument program. I mean, each image has 1 page with its own program.

 

I have this code:

 

<?php

include "db_connect.php";

$sql_imagem = "SELECT cod_curso, imagem_curso, nome_curso FROM curso ORDER BY nome_curso ASC";

$i=0;

echo "<table width = 90%  height = 45% align = center>";
$executa=mysql_query($sql_imagem,$connect);

while($dados=mysql_fetch_array($executa))
{
   $i+=1;
   if ($i == 1) 
   {
    echo "<tr> <td align = center>";
   }
  else
   {
    echo "<td align = center>";
   }
  
  
  echo "<img src=\"".$dados['imagem_curso']."\"/></a> <br /> ".$dados['nome_curso'];
  
  if ($i == 4)
   {
    echo "</td> </tr>";
$i=0;
   }
  else
   {
    echo "</td>";
   } 
}
echo "</table>";
?>

 

And i was thinking about using Arrays, but i don't know how to work with it.

 

Can someone help me, please?

 

Thank you,

PF2G

[trq]

We really don't need the image.

 

This thread should get you started.