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 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 <whatever>");
>
> Or do I need to do 'mysql_query' three times?
>
> (I know the temp table is not necessary for the example but the real
> query is more complex and does need it.)
>
> My problem is that I've got a query similar to the above that works
> correctly when I call it from the command line as
>
> 'mysql database < query.sql'
>
> but gives a wrong answer when I issue it from php. I've triple and
> quadruple checked that the queries are the same. The only difference
> I've been able to see is the single versus multiple calls.
>
> Any other ideas?
>
> BTW, it's only one row of the result set that's wrong.
>
> --
> "A little inaccuracy sometimes saves tons of explanation."
> -- H. H. Munro (Saki)
> Rick Pasotto [EMAIL PROTECTED] http://www.niof.net
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
--
"Any fool can criticize, condemn, and complain -- and most fools do."
-- Dale Carnegie
Rick Pasotto [EMAIL PROTECTED] http://www.niof.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
