 |
|
Code (PHP)
<?
if(isset($_GET['verify_code']))
{
$objConnect = mysql_connect("localhost","soapkub_soapkub","soaptaii") or die("Error Connect to Database");
$objDB = mysql_select_db("soapkub_bag");
$sql = mysql_query("select * from customer where verify_code = '".$_GET['verify_code']."'");
$objQuery = mysql_query($sql);
$num=mysql_num_rows($objQuery);
if($num>0)
{
$result = mysql_fetch_array($sql);
$strSQL = "INSERT INTO customer VALUES ('$dates')";
$strSQL = "";
$strSQL = "INSERT INTO customer ";
$strSQL .="(email,webcam,sex,name,age,country2,province2) ";
$strSQL .="VALUES ";
$strSQL .="('".$_POST["email"]."','".$_POST["webcam"]."','".$_POST["sex"]."' ,'".$_POST["name"]."' ";
$strSQL .=",'".$_POST["age"]."','".$_POST["country2"]."','".$_POST["province2"]."') ";
$sql2 = ("UPDATE from customer where verify_status = '1' ");
$result2 = mysql_db_query($objDB,$sql2);
mysql_query($sql2);
$objQuery = mysql_query($strSQL);
if($objQuery)
{
echo "<script>alert('ดำเนินการเรียบร้อยแล้วครับ');window.location='index.php';</script>";
exit();
}
else
{
echo "Error Save [".$strSQL."]";
}
}
}
?>
มันบอกผิดบรรทัดที่7อ่ะค่ะ
Tag : PHP, MySQL
|
|
|
 |
 |
 |
 |
| Date :
2011-01-22 17:57:46 |
By :
taiisoap |
View :
884 |
Reply :
3 |
|
 |
 |
 |
 |
|
|
|
|
 |
