- Can't chain sql together with semi-colon
| From: | Matt Friedman | Date: | Mon, 02 Sep 2002 02:33:22 +0000 |
| Subject: | - Can't chain sql together with semi-colon | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-2227@lists.php.net to get a copy of this message | ||
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?
Thanks.
Matt Friedman