Enregistrement dans la bd et affichage dans un tableau

Bonjour,



j n'arrive pas a afficher les données de ma base de données mm qu'elles y aille
j sui debutante voila l code
appeler la base de données:
<?php

define('DB_SERVER','localhost');
define('DB_SERVER_USERNAME','root');
define('DB_SERVER_PASSWORD','');
define('DB_DATABASE','gestion');
// connection au serveur mysql
$connect=mysql_connect('localhost','root','') or die('impossible de se connecter :'.mysql_error());
mysql_select_db('gestion',$connect);

?>

mettre dans la bd

o<?php
include ('../gestions/mysqlconnec.php')

$numplanf=$_POST['numplanf'];
$theme=$_POST['theme'];
$cabinet=$_POST['cabinet'];
$lieu=$_POST['lieu'];
$nombrepart=$_POST['nombrepart'];
$prixunitaire=$_POST['prixunitaire'];
$coutmission=$_POST['coutmission'];
$resto=$_POST['resto'];
$date=$_POST['date'];


//if ($numplanf!='0'&& $theme!=''&& $cabinet!=''&& $lieu!='' && $nombrepart!='' && $prixunitaire!='' && $coutmission!='' && $resto!='' && $date!='')
//{
$sql="INSERT INTO formation VALUES ('','".$numplanf."','".$theme."','".$cabinet."','".$lieu."','".$nombrepart."','".$prixunitaire."','".$coutmission."',
'".$resto."','".$date."')";
mysql_query($sql,$connect);
header("Location:enregistrement formation.php");
//}
?>

pour enregistrer voila le formulaire
<p>ENREGISTREMENT D'UNE FORMATION </p>
<form name="form1" method="post" action="saveformation.php">
<p> </p>
<p> </p>
<table width="319" border="1" align="center">

<td width="156">numero formation </td>
<td width="147"><label>
<input type="text" name="numplanf" />
</label></td>
</tr>
<tr>
<td>theme</td>
<td><label>
<input type="text" name="theme" />
</label></td>
</tr>
<tr>
<td>cabinet</td>
<td><label>
<input type="text" name="cabinet" />
</label></td>
</tr>
<tr>
<td>lieu</td>
<td><label>
<input type="text" name="lieu" />
</label></td>
</tr>
<tr>
<td>nombre de participants </td>
<td><label>
<input type="integer" name="nombrepart" />
</label></td>
</tr>
<tr>
<td>cout de la mission </td>
<td><label>
<input type="integer" name="coutmission" />
</label></td>
</tr>
<tr>
<td>prix unitaire </td>
<td><label>
<input type="integer" name="prixunitaire" />
</label></td>
</tr>
<tr>
<td>restauration</td>
<td><label>
<input type="integer" name="resto" />
</label></td>
</tr>
<tr>
<td>date</td>
<td><label>
<input type="date" name="date" />
</label></td>
</tr>
<tr>
<td>type formation</td>
<td><label>
<input type="text" name="lybelle_typeform" />
</label></td>


</table>
<p> </p>
<p> </p>
<table width="200" border="1" align="center">
<tr>
<td><label>

<input type="submit" name="Submit" value="Enregistrer" />
</label></td>
<td><label>
<div align="center">
<input type="submit" name="Submit2" value="Supprimer" />
</label> </td>
</tr>
</table>
<p> </p>
<p>  </p>
<p align="right">
<label></label>
</p>
<p> </p>
</form>
<form id="form2" name="form2" method="post" action="testformation.php">
<label>
<input type="submit" name="Submit3" value="visualiser" />
</label>
</form>
pour afficher
<?php
/*define('DB_SERVER','localhost');
define('DB_SERVER_USERNAME','root');
define('DB_SERVER_PASSWORD','');
define('DB_DATABASE','gestion');
$db=mysql_connect('localhost','root','');
mysql_select_db('gestion',$db);*/
include('../gestions/mysqlconnec.php');

$sql='SELECT * FROM formation';
$req=mysql_query($sql)or die('Erreur SQL!<br>' .sql.'<br>'.mysql_error());
while($data=mysql_fetch_assoc($req))
{
echo'<br>'.$data['numplanf'].'='.$data['theme'].'='.$data['cabinet'].'='.$data['lieu'].'='.$data['nombrepart'].'='.$data['prixunitaire'].'='.$data['coutmission'].'='.$data['resto'].'='.$data['date'];
}
mysql_close();
?>