โดย oatgamess » 19/10/2012 8:49 pm
ลอง echo วันที่ดูแล้วก็มีวันที่ปกติครับ แต่พอ insert เข้าไปแล้วกลับเป็น 0000-00-00
โค้ด: เลือกทั้งหมด
$memberout = 'ออกจากโครงการ';
$wmoney = 'รอเงินคืน';
mysql_select_db($database_Dbconnect, $Dbconnect);
$query_meditok = "SELECT * FROM member WHERE member_id = '".$_GET['member_id']."' ";
$meditok = mysql_query($query_meditok, $Dbconnect) or die(mysql_error());
$row_meditok = mysql_fetch_assoc($meditok);
$totalRows_meditok = mysql_num_rows($meditok);
$member_id = $row_meditok['member_id'];
$user = $row_meditok['user'];
$pass = $row_meditok['pass'];
$sex = $row_meditok['sex'];
$fname = $row_meditok['fname'];
$lname = $row_meditok['lname'];
$nname = $row_meditok['nname'];
$idcnumber = $row_meditok['idcnumber'];
$address = $row_meditok['address'];
$district = $row_meditok['district'];
$amper = $row_meditok['amper'];
$province = $row_meditok['province'];
$pcode = $row_meditok['pcode'];
$bday = $row_meditok['bday']; // วัน เดือน ปี
$tel = $row_meditok['tel'];
$mstatus = $row_meditok['mstatus'];
$status = $row_meditok['status'];
$group = $row_meditok['group'];
$homenumber = $row_meditok['homenumber'];
if($mstatus == $memberout )
{
$insert_memberout = "INSERT INTO outmember (member_id, user, pass, sex, fname, lname, nname, idcnumber, address, district, amper, province, pcode, bday, tel, mstatus, status, `group`, homenumber, outdate) VALUES ('$member_id', '$user', '$pass', '$sex', '$fname', '$lname', '$nname', '$idcnumber', '$address', '$district', '$amper', '$province', $pcode, $bday, '$tel', '$mstatus', '$wmoney', '$group', '$homenumber', '$outday')";
$Result1 = mysql_query($insert_memberout, $Dbconnect) or die(mysql_error());
$sqldelete="Delete from member where mstatus='$memberout' ";
$objQuery = mysql_query($sqldelete) or die ("Error Query [".$sqldelete."]");[attachment=2]1.jpg[/attachment]
- 2.jpg (124.52 KiB) Viewed 5670 times
- 3.jpg (46.16 KiB) Viewed 5670 times
- แนบไฟล์
-
- 1.jpg (189.57 KiB) Viewed 5670 times
ลอง echo วันที่ดูแล้วก็มีวันที่ปกติครับ แต่พอ insert เข้าไปแล้วกลับเป็น 0000-00-00
[code]
$memberout = 'ออกจากโครงการ';
$wmoney = 'รอเงินคืน';
mysql_select_db($database_Dbconnect, $Dbconnect);
$query_meditok = "SELECT * FROM member WHERE member_id = '".$_GET['member_id']."' ";
$meditok = mysql_query($query_meditok, $Dbconnect) or die(mysql_error());
$row_meditok = mysql_fetch_assoc($meditok);
$totalRows_meditok = mysql_num_rows($meditok);
$member_id = $row_meditok['member_id'];
$user = $row_meditok['user'];
$pass = $row_meditok['pass'];
$sex = $row_meditok['sex'];
$fname = $row_meditok['fname'];
$lname = $row_meditok['lname'];
$nname = $row_meditok['nname'];
$idcnumber = $row_meditok['idcnumber'];
$address = $row_meditok['address'];
$district = $row_meditok['district'];
$amper = $row_meditok['amper'];
$province = $row_meditok['province'];
$pcode = $row_meditok['pcode'];
$bday = $row_meditok['bday']; // วัน เดือน ปี
$tel = $row_meditok['tel'];
$mstatus = $row_meditok['mstatus'];
$status = $row_meditok['status'];
$group = $row_meditok['group'];
$homenumber = $row_meditok['homenumber'];
if($mstatus == $memberout )
{
$insert_memberout = "INSERT INTO outmember (member_id, user, pass, sex, fname, lname, nname, idcnumber, address, district, amper, province, pcode, bday, tel, mstatus, status, `group`, homenumber, outdate) VALUES ('$member_id', '$user', '$pass', '$sex', '$fname', '$lname', '$nname', '$idcnumber', '$address', '$district', '$amper', '$province', $pcode, $bday, '$tel', '$mstatus', '$wmoney', '$group', '$homenumber', '$outday')";
$Result1 = mysql_query($insert_memberout, $Dbconnect) or die(mysql_error());
$sqldelete="Delete from member where mstatus='$memberout' ";
$objQuery = mysql_query($sqldelete) or die ("Error Query [".$sqldelete."]");[attachment=2]1.jpg[/attachment]
[/code]
[attachment=1]2.jpg[/attachment]
[attachment=0]3.jpg[/attachment]