PHP代码修改数据

来源:百度知道 编辑:UC知道 时间:2024/07/02 06:12:59
if($m_submit_type == "1") { //modify

$m_company_id = $_POST[txtCompanyID];
$m_company_name = $_POST[txtCompanyName];
$m_status = $_POST[txtStatus];
$db = new CDb;
$str_sql="Select count(*) cnt From CompanyInfo Where CompanyID<>'$m_company_id' And CompanyName='$m_company_name', Status='$m_status'";
$db->DbSelect( $str_sql );
while( 1 )
{
if(!$db->DbMoveNext()) break;
$cnt = $db->GetColValue( "cnt" );
}
if( $cnt == 0 ) {
$str_sql = "Update CompanyInfo Set CompanyName='$m_company_name', Status='$m_status '
Where CompanyID = '$m_company_id' ";

$ret = $db->DbExec( $str_sql );
if( $ret == 0 ) {
$ErrorMsg = "数据库操作失败!";
} else {
$ErrorMsg = "数据修改成功!";
}
} else {
$ErrorMsg = "该

$str_sql="Select count(*) cnt From CompanyInfo Where CompanyID<>'$m_company_id' And CompanyName='$m_company_name', Status='$m_status'";//这里的",status='$m_status'"语句对?应该把‘,’改成and吧,我再mysql里运行这个语句是有语法错误的

检查下你的post变量是否有值,你一步步echo下试试吧。
update语句测试没有错误。虽然Status='$m_status '这里多了个空格