Welcome Guest, Not a member yet? Register   Sign In
Want a Codeigniter Query
#3

I got this error:
-----------------
A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as t5' at line 6

insert into t_category (category, parent_category)
(select CSV.t_category, PCAT.parent_id from t_csv CSV
left join t_category CAT on CSV.category = CAT.category
left join t_pcategory PCAT on CSV.parent_category = PCAT.parent_category
where CAT.id is null and PCAT.parent_category is not null) as t5

Filename: models/Super_admin_model.php

Line Number: 1030
Reply


Messages In This Thread
Want a Codeigniter Query - by apysan - 03-22-2017, 12:45 AM
RE: Want a Codeigniter Query - by neuron - 03-22-2017, 01:33 AM
RE: Want a Codeigniter Query - by apysan - 03-23-2017, 12:12 AM
RE: Want a Codeigniter Query - by php_rocs - 03-28-2017, 08:04 PM



Theme © iAndrew 2016 - Forum software by © MyBB