SQL virker i PHPmyAdmin, men ikke i min egen kode
Følgende SQL virker fint i PHPmyAdmin, men ikke i min egen kode:-----
SELECT CONCAT("SELECT ", "CONCAT(\"INSERT INTO bpd VALUES \\\"", se.id, "\\\", \\\"", bp1.Value, "\\\", \\\"\\\",\",", "\"\\\"\",", idn3.name, ",\"\\\"\"",",\", \",", "\"\\\"\",", idn1.name, ",\"\\\"\"",") AS SQL_gen_res", " FROM ", idn2.name, " WHERE ", idn1.name, se.Dc) AS SQL_gen
FROM (
(
(
(
bp AS bp0
INNER JOIN bp AS bp1 ON bp0.BP_id = bp1.O1_id
)
INNER JOIN idn AS idn1 ON bp1.Value = idn1.id
)
INNER JOIN (
bp AS bp2
INNER JOIN idn AS idn2 ON bp2.O1_id = idn2.id
) ON bp1.Value = bp2.Value
)
INNER JOIN se ON bp0.Value = se.R
)
INNER JOIN (
bp AS bp3
INNER JOIN idn AS idn3 ON idn2.id = bp3.O1_id
) ON bp3.Value = idn3.id
WHERE (
(
bp3.C2_id = "2140"
)
AND (
bp2.O1_id <> bp1.O1_id
)
AND (
bp1.C1_id <> "1020"
)
AND (
bp0.Value = se.R
)
AND (
se.id = "1"
)
AND (
se.Dc <> ":NULL"
)
);
-----
For mig er fejlen åbenlys, altså det er \\\"\" osv den ikke kan finde ud af. Hvad skal jeg gøre for at mit PHP æder det hele og ikke tror der er et stop på "halvvejen"?
