Re: - Can't chain sql together with semi-colon

On Mon September 2 2002 5:33 am, Matt Friedman wrote: > How come I can do this: > > $sql = " UPDATE some update sql here"; > $result = $this->db->query($sql); > $sql = " UPDATE some more update sql here"; > $result = $this->db->query($sql); > > but if I try to do this: > > $sql = " UPDATE some update sql here; UPDATE some more update sql here > "; > $result = $this->db->query($sql); > > I get a syntax error? > > I've been trying to chain together sql statements using a semi-colon but > mysql always seems to give an error. > > What's going on? > Hi Matt, it's a security check against entering SQL code via forms, etc. -- Martin Tsachev http://martin.f2o.org