I don't know to post a query
Hi,
I have a problem to make a post with a query.
For example i have this query :
SELECT p.*, i.insurance_name
FROM m_package p, m_insurance I
WHERE P.ID_INSURANCE = I.ID_INSURANCE AND insurance_name like 'ACE' AND
((days_period_start <= 4 and days_period_end >= 4) or days_period_start = 0) and TYPE like 'INDIVIDU%' AND
(ID_COUNTRY = (SELECT C_ASEAN FROM M_COUNTRY WHERE ID_COUNTRY = 'SGP') or
ID_COUNTRY = (SELECT C_ASIA FROM M_COUNTRY WHERE ID_COUNTRY = 'SGP') or
ID_COUNTRY = (SELECT C_WORLD FROM M_COUNTRY WHERE ID_COUNTRY = 'SGP') or
ID_COUNTRY = (SELECT C_REGION1 FROM M_COUNTRY WHERE ID_COUNTRY = 'SGP') or
ID_COUNTRY = (SELECT C_REGION2 FROM M_COUNTRY WHERE ID_COUNTRY = 'SGP') )
That query is condition from user.
I don't know how to make that query to post in php.
Do you have a example code for make a post If i have a condition like that ?
Please help me. Thank you :)
I have a problem to make a post with a query.
For example i have this query :
SELECT p.*, i.insurance_name
FROM m_package p, m_insurance I
WHERE P.ID_INSURANCE = I.ID_INSURANCE AND insurance_name like 'ACE' AND
((days_period_start <= 4 and days_period_end >= 4) or days_period_start = 0) and TYPE like 'INDIVIDU%' AND
(ID_COUNTRY = (SELECT C_ASEAN FROM M_COUNTRY WHERE ID_COUNTRY = 'SGP') or
ID_COUNTRY = (SELECT C_ASIA FROM M_COUNTRY WHERE ID_COUNTRY = 'SGP') or
ID_COUNTRY = (SELECT C_WORLD FROM M_COUNTRY WHERE ID_COUNTRY = 'SGP') or
ID_COUNTRY = (SELECT C_REGION1 FROM M_COUNTRY WHERE ID_COUNTRY = 'SGP') or
ID_COUNTRY = (SELECT C_REGION2 FROM M_COUNTRY WHERE ID_COUNTRY = 'SGP') )
That query is condition from user.
I don't know how to make that query to post in php.
Do you have a example code for make a post If i have a condition like that ?
Please help me. Thank you :)
Thank you for your question regarding MySQL. I apologize but I am not following what you are trying to do. Are you wanting users to be able to click something and make this post or are you wanting this query to run based on what user is visiting a certain page? Regardless of either way we mainly only help with errors regarding stuff of this nature as we do not assist with custom coded solutions but I may be able to point you in the right direction.
Best Regards,
TJ Edens