PDA

View Full Version : باز هم خطای ویرایش



sedaghat23
شنبه 09 اردیبهشت 1385, 23:46 عصر
با سلام وخسته نباشید
ادیتم رو گذاشتم اما درست نشد
پیغام می ده که ویرایش انجام شد اما نشده!
کد اینه:


if (!strlen(trim($T1))==0 && !strlen($T2)==0){
$T1=trim($T1);
//$query1="UPDATE `books` SET `BookName`='$T2' WHERE `Bookid` ='$Bookid' AND `BookName` ='$T1' AND `Subject` = '$Subject' AND `Auther` = '$Auther' AND `Entesharat` = '$Entesharat' AND `EnterDate` = '$EnterDate' AND `URL` = '$URL' ";
$query1="UPDATE `books` SET `BookName`=('$T2') WHERE `Bookid` ='$Bookid' AND `BookName` =trim('$T1') AND `Subject` = '$Subject' AND `Auther` = '$Auther' AND `Entesharat` = '$Entesharat' AND `EnterDate` = '$EnterDate' AND `URL` = '$URL' ";
$result=mysql_query($query1) or die("couldnot edit ".mysql_error());
echo"
<p align='center'>&nbsp;</p>
<table border='0' width='100%' bgcolor='#649B98'>
<tr>
<td align='center'><b><font face='Tahoma' size='2' color='#000080'>
&aelig;&iacute;&Ntilde;&Ccedil;&iacute;&Ocirc; &Ccedil;&auml;&Igrave;&Ccedil;&atilde; &Ocirc;&Iuml; .</font></b></td>
</tr>
</table>
";
}
else
print "
<p align='center'>&nbsp;</p>
<table border='0' width='100%' bgcolor='#649B98'>
<tr>
<td align='center'><b><font face='Tahoma' size='2' color='#000080'>
&auml;&Ccedil;&atilde; ˜&Ecirc;&Ccedil;&Egrave; &Ntilde;&Ccedil;&Iuml;&Ntilde;&Oacute;&Ecirc; &aelig;&Ccedil;&Ntilde;&Iuml; ˜&auml;&iacute;&Iuml; .</font></b></td>
</tr>
</table>
";

ممنون

nematia
سه شنبه 12 اردیبهشت 1385, 13:50 عصر
$query1="UPDATE `books` SET `BookName`=('$T2') WHERE `Bookid` ='$Bookid' AND `BookName` =trim('$T1') AND `Subject` = '$Subject' AND `Auther` = '$Auther' AND `Entesharat` = '$Entesharat' AND `EnterDate` = '$EnterDate' AND `URL` = '$URL' ";حدس میزنم منظورتون این بوده:


$query1="UPDATE `books` SET `BookName`=('$T2') , `BookName` =trim('$T1') , `Subject` = '$Subject' , `Auther` = '$Auther' , `Entesharat` = '$Entesharat' , `EnterDate` = '$EnterDate' , `URL` = '$URL' WHERE `Bookid` ='$Bookid' ";