$id_ppt = $num_type[$i];
$sql_delete = "DELETE FROM accom_property WHERE id = '$id_ppt' ";
$db->setQuery($sql_delete);
$db->query();
งงตรง where id=$id_ppt
ผมไปต่อไม่ถูกครับ คือ ผมเขียนมาไกด์แบบนี้ งงๆครับ
$id_ppt = $num_type[$i];
ตรงนี้ครับ งงแนวทาง
Code (PHP)
$sql_delete = "DELETE accom_property FROM accom_property LEFT JOIN accom_property_file
WHERE id = '$id_ppt' ";
$db->setQuery($sql_delete);
$db->query();
$sql_delete = "DELETE accom_property FROM accom_property LEFT JOIN accom_property_file
WHERE id = '$id_ppt' ";
$db->setQuery($sql_delete);
$db->query();
delete table1, table2, table3, table4
from table1
left join table2 on blabla....
left join table3 on blabla....
left join table4 on blabla....
where compare_variable