0) { $SQL_SP_NEW = mysql_query("select * from danhmuc_sp"); $count = mysql_num_rows(mysql_query("select * from danhmuc_sp")); $count = $count + 1; $Masp = "SP_QL".$count; //------------------------- Tìm Mã Sản Phẩm Trùng ---------------------------- while ($row_Masp_x = mysql_fetch_row($SQL_SP_NEW)) //Chạy từ mẩu tin đầu đến mẩu tin cuối { $Mansp = $row_Masp_x[0]; if($Masp == $Mansp) { $count = $count + 1; $Masp = "SP_QL".$count; } } //------------------------ Tiền tố ------------------------------------------- $SQL_TIM_TT = mysql_query("select * from lic_file"); $row_tt = mysql_fetch_row($SQL_TIM_TT); $TenTT = $row_tt[3]; //---------------------- Xác định khóa chính --------------------------------- $SQL_TIM_PRI = mysql_query("select * from danhmuc_sp where MALOAI='$Masp' "); if(mysql_num_rows($SQL_TIM_PRI)<>0) { $count = $count + 1; $Masp = "SP_".$TenTT.$count; } if(mysql_num_rows($SQL_TIM_PRI)==0) { $Masp = "SP_".$TenTT.$count; } //---------------------------------------------------------------------------- ?>