عدم ارسال اطلاعات به دیتابیس

[groupp30]

سلام این کد رو ببینین . خودتون جریان کار دستتون میاد . فقط اطلاعات رو به دیتابیس ارسال نمیکنه



<?php
$conn=mysql_connect("localhost","root","");
mysql_select_db("bors",$conn);
$sql="select *
from
(
SELECT P.`post_id`,
min(
CASE
WHEN P.`meta_key`='انتخاب_نوع_مشاوره'
THEN meta_value
ELSE NULL
END
) AS 'نتخاب_نوع_مشاوره',
min(
CASE
WHEN P.`meta_key`='نوع_معامله'
THEN meta_value
ELSE NULL
END
) AS 'نوع_معامله',
min(
CASE
WHEN P.`meta_key`='نام_شرکت'
THEN meta_value
ELSE NULL
END
) AS 'نام_شرکت',
min(
CASE
WHEN P.`meta_key`='مقدار'
THEN meta_value
ELSE NULL
END
) AS 'مقدار',
min(
CASE
WHEN P.`meta_key`='شروع_قيمت'
THEN P.`meta_value`
ELSE NULL
END
) AS 'شروع_قيمت',
min(
CASE
WHEN P.`meta_key`='تاريخ'
THEN meta_value
ELSE NULL
END
) AS 'تاريخ',
min(
CASE
WHEN P.`meta_key`='حد_سود'
THEN meta_value
ELSE NULL
END
) AS 'حد_سود',
min(
CASE
WHEN P.`meta_key`='حد_ضرر'
THEN meta_value
ELSE NULL
END
) AS 'حد_ضرر'
FROM wp_postmeta P
GROUP BY P.`post_id`) AS t1 INNER JOIN
t_namaiebazar on t1.`نام_شرکت` =t_namaiebazar.`name` INNER JOIN wp_posts on wp_posts.id=t1.post_id";
$result=mysql_query($sql,$conn);
while($newarray= mysql_fetch_array($result))
{

$newdata=$newarray[nowdate]-1;
if($newarray[تاریخ]==$newdata)
{
$newarray[engheza]=1;
}
elseif($newarray[engheza]==0)
{
if($newarray[تاریخ]==$newarray[nowdate])
{
if($newarray[نوع_معامله]=="خرید"||$newarray[نوع_معامله]=="خرید معلق")
{
if($newarray[حد_سود]>=$newarray[taghaza])
{
$sql5 = "Update wp_posts\n"
. "Set emtiaz_post = emtiaz_post+1\n"
. "Where emtiaz_post = $newarray[emtiaz_post] \n";
}
elseif($newarray[حد_ضرر]<=$newarray[taghaza])
{
$sql5 = "Update wp_posts\n"
. "Set emtiaz_post = emtiaz_post-1\n"
. "Where emtiaz_post = $newarray[emtiaz_post] \n";
}
}

elseif($newarray[نوع_معامله]=="فروش"||$newarray[نوع_معامله]=="فروش معلق")
{
if($newarray[حد_سود]>=$newarray[arze])
{
$sql5 = "Update wp_posts\n"
. "Set emtiaz_post = emtiaz_post+1\n"
. "Where emtiaz_post = $newarray[emtiaz_post] \n";
}
elseif($newarray[حد_ضرر]<=$newarray[arze])
{
$sql5 = "Update wp_posts\n"
. "Set emtiaz_post = emtiaz_post-1\n"
. "Where emtiaz_post = $newarray[emtiaz_post] \n";
}
}
}
elseif($newarray[حد_سود]>=$newarray[taghaza]||$newarray[حد_سود]>=$newarray[arze]||$newarray[حد_ضرر]<=$newarray[taghaza]
||$newarray[حد_ضرر]<=$newarray[arze])
{
if($newarray[نوع_معامله]=="خرید"||$newarray[نوع_معامله]=="خرید معلق")
{
if($newarray[حد_سود]>=$newarray[taghaza])
{
$sql5 = "Update wp_posts\n"
. "Set emtiaz_post = emtiaz_post+1\n"
. "Where emtiaz_post = $newarray[emtiaz_post] \n";
}
elseif($newarray[حد_ضرر]<=$newarray[taghaza])
{
$sql5 = "Update wp_posts\n"
. "Set emtiaz_post = emtiaz_post-1\n"
. "Where emtiaz_post = $newarray[emtiaz_post] \n";
}
}

elseif($newarray[نوع_معامله]=="فروش"||$newarray[نوع_معامله]=="فروش معلق")
{
if($newarray[حد_سود]>=$newarray[arze])
{
$sql5 = "Update wp_posts\n"
. "Set emtiaz_post = emtiaz_post+1\n"
. "Where emtiaz_post = $newarray[emtiaz_post] \n";
}
elseif($newarray[حد_ضرر]<=$newarray[arze])
{
$sql5 = "Update wp_posts\n"
. "Set emtiaz_post = emtiaz_post-1\n"
. "Where emtiaz_post = $newarray[emtiaz_post] \n";
}
}
}
}

}

?>