Codeigniter delete query not working

Question

I need to delete records from three tables at a time.Here is my query:-

$query =$this->db->query("DELETE ps_faq_categories FROM ps_faq_categories INNER JOIN ps_faqs ON('ps_faq_categories.faq_category_id = ps_faqs.faq_category_id') 
                     INNER JOIN ps_faq_comments ON('ps_faqs.faq_id = ps_faq_comments.faq_id') WHERE 'ps_faq_categories.faq_category_id' = $category_id");

I am getting error like , An expression of non-boolean type specified in a context where a condition is expected, near 'INNER'.

Man Programmer · Accepted Answer · 2015-09-28 10:00:16Z

0

remove single quote from the query

$query =$this->db->query("DELETE ps_faq_categories,ps_faqs,ps_faq_comments FROM ps_faq_categories INNER JOIN ps_faqs ON(ps_faq_categories.faq_category_id = ps_faqs.faq_category_id) 
                     INNER JOIN ps_faq_comments ON(ps_faqs.faq_id = ps_faq_comments.faq_id) WHERE ps_faq_categories.faq_category_id = $category_id");

edited Sep 28, 2015 at 10:00

answered Sep 28, 2015 at 6:46

Man Programmer

5,3662 gold badges24 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Youv Over a year ago

I have tried this , but havent solved am getting error, Incorrect syntax near '`'

Youv Over a year ago

The record deleted from ps_faq_categories but not deleting from ps_faqs and ps_faq_comments.Is their any problem in my query

Youv Over a year ago

Unfortunately it doesnt work , [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near ','.

Youv Over a year ago

the multi-part identifier "ps_faq_categories.faq_category_id" could not be bound.

Man Programmer Over a year ago

i updated the query and check this link stackoverflow.com/questions/2214433/… it will may be help you

Collectives™ on Stack Overflow

Codeigniter delete query not working

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related