Table with Connection MySQL DataBase

[PF2G]

Hello, PHPFreaks

 

I'm creating a website about a Music School and i want to create a table with the instruments one row with image and a row bellow with their name.

 

<table width="200" height="134">
<?PHP

//connect database
$dbhost = "";
$db = "";
$dbuser = "";
$dbpass = "";
$connect = mysql_connect($dbhost,$dbuser,$dbpass) or die ("Falha ao ligar à Base de Bados: " . mysql_error());

//3 columns limit
i == 3;
while {
i == i + 1;
if i == 1 {
?>
<tr>
<td>

<?PHP  
}  else  
{
?>
<td>

<?    
}
$sql = "SELECT nome_curso, imagem_curso FROM cursos ORDER BY nome_curso";
}
if i == 3 {
?>
</td>
</tr>

<? 
}else
{
?>
</td>

<?PHP
}?>
</table> ()

 

 

 

The name and the image are in a MySQL DB.

 

Please help me.

 

Thank You

[Nodral]

NEVER EVER EVER EVER give out your DB username and Password on an open forum.  You are practically inviting hackers and other malicious types to destroy your site!!!

[PF2G]

Any Help Please

[PF2G]

People, Com'n

 

I need this ASAP. PLEASE

 

Thank you

[voip03]

<?php

$s = "SELECT nome_curso, imagem_curso FROM cursos ORDER BY nome_curso";
$r =  mysql_query($s);
$n =  mysql_num_rows($r);

if($n !=0)
{
	echo"<table width='750' border='1' cellspacing='0' cellpadding='1'><tr>";
	while($row = mysql_fetch_assoc($r))
	{

    		echo "<td>". $row['nome_curso']."</td>";
    		echo "<td><img src='imagepath/images/". $row['imagem_curso'] ." ></td>";
	}
		echo "</tr></table>";

}
?>