Problème date de mon formulaire

Bonjour et mercio pour ta réponse,

J'ai effectivement dans le champ "Null" null
et dans le champ"Défaut" NULL

Et toujours mes champs dans mon formulaire qui doivent rester vide et cette "foutue" date qui ressort à chaque fois "01/01/1970"
Merci de votre aidse

Là, sans le code PHP je ne peu plus rien faire !
Pour continuer, il faudra que tu fasse parvenir le code incriminé ... car, maintenant, je suppose qu'il s'agit d'un problème de code.

Merci pour ta réponse,
Je t'envoi le code de mon formulaire si toute fois tu peux me dépanner;
Merci

<table class="ds_box" cellpadding="0" cellspacing="0" id="ds_conclass" style="display: none;">
<tr>
<td id="ds_calclass"></td>
</tr>
</table>
<script type="text/javascript">
var ds_i_date = new Date();
ds_c_month = ds_i_date.getMonth() + 1;
ds_c_year = ds_i_date.getFullYear();

// Get Element By Id
function ds_getel(id) {
return document.getElementById(id);
}

// Get the left and the top of the element.
function ds_getleft(el) {
var tmp = el.offsetLeft;
el = el.offsetParent
while(el) {
tmp += el.offsetLeft;
el = el.offsetParent;
}
return tmp;
}
function ds_gettop(el) {
var tmp = el.offsetTop;
el = el.offsetParent
while(el) {
tmp += el.offsetTop;
el = el.offsetParent;
}
return tmp;
}

// Output Element
var ds_oe = ds_getel('ds_calclass');
// Container
var ds_ce = ds_getel('ds_conclass');

// Output Buffering
var ds_ob = '';
function ds_ob_clean() {
ds_ob = '';
}
function ds_ob_flush() {
ds_oe.innerHTML = ds_ob;
ds_ob_clean();
}
function ds_echo(t) {
ds_ob += t;
}

var ds_element; // Text Element...

var ds_monthnames = [
'Janvier', 'Février', 'Mars', 'Avril', 'Mai', 'Juin',
'Juillet', 'Aout', 'Septembre', 'Octobre', 'Novembre', 'Décembre'
]; // You can translate it for your language.

var ds_daynames = [
'Dim', 'Lun', 'Mar', 'Me', 'Jeu', 'Ven', 'Sam'
]; // You can translate it for your language.

// Calendar template
function ds_template_main_above(t) {
return '<table cellpadding="3" cellspacing="1" class="ds_tbl">'
+ '<tr>'
+ '<td class="ds_head" style="cursor: pointer" onclick="ds_py();"><<</td>'
+ '<td class="ds_head" style="cursor: pointer" onclick="ds_pm();"><</td>'
+ '<td class="ds_head" style="cursor: pointer" onclick="ds_hi();" colspan="3">[Fermer]</td>'
+ '<td class="ds_head" style="cursor: pointer" onclick="ds_nm();">></td>'
+ '<td class="ds_head" style="cursor: pointer" onclick="ds_ny();">>></td>'
+ '</tr>'
+ '<tr>'
+ '<td colspan="7" class="ds_head">' + t + '</td>'
+ '</tr>'
+ '<tr>';
}

function ds_template_day_row(t) {
return '<td class="ds_subhead">' + t + '</td>';
// Define width in CSS, XHTML 1.0 Strict doesn't have width property for it.
}

function ds_template_new_week() {
return '</tr><tr>';
}

function ds_template_blank_cell(colspan) {
return '<td colspan="' + colspan + '"></td>'
}

function ds_template_day(d, m, y) {
return '<td class="ds_cell" onclick="ds_onclick(' + d + ',' + m + ',' + y + ')">' + d + '</td>';
// Define width the day row.
}

function ds_template_main_below() {
return '</tr>'
+ '</table>';
}

// This one draws calendar...
function ds_draw_calendar(m, y) {
// First clean the output buffer.
ds_ob_clean();
// Here we go, do the header
ds_echo (ds_template_main_above(ds_monthnames[m - 1] + ' ' + y));
for (i = 0; i < 7; i ++) {
ds_echo (ds_template_day_row(ds_daynames[i]));
}
// Make a date object.
var ds_dc_date = new Date();
ds_dc_date.setMonth(m - 1);
ds_dc_date.setFullYear(y);
ds_dc_date.setDate(1);
if (m == 1 || m == 3 || m == 5 || m == 7 || m == 8 || m == 10 || m == 12) {
days = 31;
} else if (m == 4 || m == 6 || m == 9 || m == 11) {
days = 30;
} else {
days = (y % 4 == 0) ? 29 : 28;
}
var first_day = ds_dc_date.getDay();
var first_loop = 1;
// Start the first week
ds_echo (ds_template_new_week());
// If sunday is not the first day of the month, make a blank cell...
if (first_day != 0) {
ds_echo (ds_template_blank_cell(first_day));
}
var j = first_day;
for (i = 0; i < days; i ++) {
// Today is sunday, make a new week.
// If this sunday is the first day of the month,
// we've made a new row for you already.
if (j == 0 && !first_loop) {
// New week!!
ds_echo (ds_template_new_week());
}
// Make a row of that day!
ds_echo (ds_template_day(i + 1, m, y));
// This is not first loop anymore...
first_loop = 0;
// What is the next day?
j ++;
j %= 7;
}
// Do the footer
ds_echo (ds_template_main_below());
// And let's display..
ds_ob_flush();
// Scroll it into view.
ds_ce.scrollIntoView();
}

// A function to show the calendar.
// When user click on the date, it will set the content of t.
function ds_sh(t) {
// Set the element to set...
ds_element = t;
// Make a new date, and set the current month and year.
var ds_sh_date = new Date();
ds_c_month = ds_sh_date.getMonth() + 1;
ds_c_year = ds_sh_date.getFullYear();
// Draw the calendar
ds_draw_calendar(ds_c_month, ds_c_year);
// To change the position properly, we must show it first.
ds_ce.style.display = '';
// Move the calendar container!
the_left = ds_getleft(t);
the_top = ds_gettop(t) + t.offsetHeight;
ds_ce.style.left = the_left + 'px';
ds_ce.style.top = the_top + 'px';
// Scroll it into view.
ds_ce.scrollIntoView();
}

// Hide the calendar.
function ds_hi() {
ds_ce.style.display = 'none';
}

// Moves to the next month...
function ds_nm() {
// Increase the current month.
ds_c_month ++;
// We have passed December, let's go to the next year.
// Increase the current year, and set the current month to January.
if (ds_c_month > 12) {
ds_c_month = 1;
ds_c_year++;
}
// Redraw the calendar.
ds_draw_calendar(ds_c_month, ds_c_year);
}

// Moves to the previous month...
function ds_pm() {
ds_c_month = ds_c_month - 1; // Can't use dash-dash here, it will make the page invalid.
// We have passed January, let's go back to the previous year.
// Decrease the current year, and set the current month to December.
if (ds_c_month < 1) {
ds_c_month = 12;
ds_c_year = ds_c_year - 1; // Can't use dash-dash here, it will make the page invalid.
}
// Redraw the calendar.
ds_draw_calendar(ds_c_month, ds_c_year);
}

// Moves to the next year...
function ds_ny() {
// Increase the current year.
ds_c_year++;
// Redraw the calendar.
ds_draw_calendar(ds_c_month, ds_c_year);
}

// Moves to the previous year...
function ds_py() {
// Decrease the current year.
ds_c_year = ds_c_year - 1; // Can't use dash-dash here, it will make the page invalid.
// Redraw the calendar.
ds_draw_calendar(ds_c_month, ds_c_year);
}

// Format the date to output.
function ds_format_date(d, m, y) {
// 2 digits month.
m2 = '00' + m;
m2 = m2.substr(m2.length - 2);
// 2 digits day.
d2 = '00' + d;
d2 = d2.substr(d2.length - 2);
// YYYY-MM-DD
// return y + '-' + m2 + '-' + d2;
return d2 + '/' + m2 + '/' + y;
}

// When the user clicks the day.
function ds_onclick(d, m, y) {
// Hide the calendar.
ds_hi();
// Set the value of it, if we can.
if (typeof(ds_element.value) != 'undefined') {
ds_element.value = ds_format_date(d, m, y);
// Maybe we want to set the HTML in it.
} else if (typeof(ds_element.innerHTML) != 'undefined') {
ds_element.innerHTML = ds_format_date(d, m, y);
// I don't know how should we display it, just alert it to user.
} else {
alert (ds_format_date(d, m, y));
}
}
</script>


<style type="text/css">
.ds_box {
background-color: #FFF;
border: 2px solid red;
position: absolute;
z-index: 32767;
}
.ds_tbl {
background-color: #FFF;
}
.ds_head {
background-color: #333;
color: #FFF;
font-family: Arial, Helvetica, sans-serif;
font-size: 13px;
font-weight: bold;
text-align: center;
letter-spacing: 2px;
}
.ds_subhead {
background-color: #CCC;
color: #000;
font-size: 12px;
font-weight: bold;
text-align: center;
font-family: Arial, Helvetica, sans-serif;
width: 32px;
}
.ds_cell {
background-color: #EEE;
color: #000;
font-size: 13px;
text-align: center;
font-family: Arial, Helvetica, sans-serif;
padding: 5px;
cursor: pointer;
}
.ds_cell:hover {
background-color: #F3F3F3;
}
</style>

Je t'envoi aussi le formulaire qui correspond............AJOUTER UN MEMBRE"
Tu verras c'est les trois champs "admission" " d'émission" "né le" qui me'affichent cette datte "01/01/1970" il faudrait au moin que les champs non rempli au départ restent vide lorsque je fait modifier.

Merci





<div id="box">
<form action="index.php5?cat=sorties&page=membres" method="post" >
<fieldset>
<legend>Ajouter un membre</legend>
<p>
<label for="add-nom">Nom :</label>
<input type="text" name="nom" id="add-nom" />
</p>
<p>
<label for="add-adress">Adresse :</label>
<textarea id="add-adress" name="adress"></textarea>
</p>
<p>
<label for="add-tel1">Téléphone 1 :</label>
<input type="text" name="tel1" id="add-tel1" />
</p>
<p>
<label for="add-tel2">Téléphone 2 :</label>
<input type="text" name="tel2" id="add-tel2" />
</p>
<p>
<label for="add-mail">Courriel :</label>
<input type="text" name="mail" id="add-mail" />
</p>
<p>
<label for="add-pupitres">Pupitre :</label>
<?php
//menu déroulant pour le type de pupitres
//requête
$sql="show columns from users like 'user_pupitres'";
$result = DbConnection::select( $sql );
if( DbConnection::hasError() )
{
$error = DbConnection::getError();
}
if( $result )
{
//on récupère la colonne 'Type' dans le résultat $result de la requete $sql
$type=mysql_result($result,0,'Type');
//ce qui donne un string du type : set('blabla','blabla',...)
//il faut donc enlever le début et la fin puis utiliser split pour récupérer chaque champ
$type=substr($type,5,strlen($type)-5-2);
$resp=split("','",$type);
//creation du select avec toutes les options correspondant à chaque champ du tableau $resp
echo "<select name='pupitres' id='add-pupitres'>";
echo "<option value='-1'>--liste pupitres--</option>";
foreach( $resp as $row )
{
echo "<option value=$row>$row</option>";
}
echo "</select>";
}
?>
</p>
<p>
<label for="add-membres">Membre :</label>
<?php
//menu déroulant pour le type de membres
$sql="show columns from users like 'user_membres'";
$result = DbConnection::select( $sql );
if( DbConnection::hasError() )
{
$error = DbConnection::getError();
}
if( $result )
{
$type=mysql_result($result,0,'Type');
$type=substr($type,5,strlen($type)-5-2);
$resp=split("','",$type);
echo "<select name='membres' id='add-membres'>";
echo "<option value='-1'>--liste membres--</option>";
foreach( $resp as $row )
{
echo "<option value=$row>$row</option>";
}
echo "</select>";
}
?>
</p>
<p>
<label for="add-admission">Admission :</label>
<input onclick="ds_sh(this);" type="text" name="admission" id="add-admission" />
</p>
<p>
<label for="add-demission">Démission :</label>
<input onclick="ds_sh(this);" type="text" name="demission" id="add-demission" />
</p>
<p>
<label for="add-naissance">Né(e) le :</label>
<input onclick="ds_sh(this);" type="text" name="naissance" id="add-naissance" />
</p>
<p>
<label for="add-bureau">Bureau :</label>
<?php
$sql="show columns from users like 'user_bureau'";
$result = DbConnection::select( $sql );
if( DbConnection::hasError() )
{
$error = DbConnection::getError();
}
if( $result )
{
$type=mysql_result($result,0,'Type');
$type=substr($type,5,strlen($type)-5-2);
$resp=split("','",$type);
echo "<select name='bureau' id='add-bureau'>";
echo "<option value='-1'>--liste du bureau--</option>";
foreach( $resp as $row )
{
echo "<option value=$row>$row</option>";
}
echo "</select>";
}
?>
</p>
<p>
<label for="add-responsable">Responsable :</label>
<?php
//Menu déroulant pour la liste des responsabilités
$sql="show columns from users like 'user_responsable'";
$result = DbConnection::select( $sql );

if( DbConnection::hasError() )
{
$error = DbConnection::getError();
}
if( $result )
{
$type=mysql_result($result,0,'Type');
$type=substr($type,5,strlen($type)-5-2);
$resp=split("','",$type);

//TODO multiple
echo "<select multiple name='responsable' id='add-responsable'>";
echo "<option value='-1'>--liste des responsabilites--</option>";

/*echo "<option value = $resp[0]> $resp[0] </option>";
echo "<option value = $resp[1]> $resp[1] </option>";
echo "<option value = $resp[count($resp)-1]> $resp[count($resp)-1] </option>";*/

foreach( $resp as $row )
{
echo "<option value=$row>$row</option>";
}


/*for ($i=0; $i<count($resp); $i++) {
echo "<option value = $resp[i]> '$resp[i]' </option>";
}*/

/*while($row = mysql_fetch_array($resp))
{
echo "<option value=$data[0]>$data[0]</option>";
}
*/ echo "</select>";
}
?>
</p>
<p>
<input type="hidden" name="do" value="add" />
<input type="reset" value="Effacer" />
<input type="submit" value="Soumettre" />
</p>
</fieldset>
</form>
</div>
<?php //return $box;