Re: multiple mysql statements in single php request

Never mind. I've solved my problem. My create statement had an unquoted date in the select part. It works correctly now. On Wed, Jul 09, 2003 at 03:29:11PM -0400, Rick Pasotto wrote: > Is it possible to issue multiple sql statements in a single php request? > (Probably not since I get a syntax err

multiple mysql statements in single php request

Is it possible to issue multiple sql statements in a single php request? (Probably not since I get a syntax error. mysql 4.0.13). For example: $result = mysql_query("drop table if exists tmptab; create temporary table tmptab select * from othertab; select * from tmptab where ");