Re: Temp table doesn't seem to work

2005-10-24 Thread SGreen
Brian Dunning <[EMAIL PROTECTED]> wrote on 10/24/2005 01:32:43 PM: > I got it to work - turns out it was a stupid typo on my part (hate it > when that happens - and hate wasting the list's time even more!). How > long does this temporary table persist for - just the execution of > the one page,

Re: Temp table doesn't seem to work

2005-10-24 Thread Brian Dunning
I got it to work - turns out it was a stupid typo on my part (hate it when that happens - and hate wasting the list's time even more!). How long does this temporary table persist for - just the execution of the one page, or will it live on the server (using resources) until I explicitly mak

Re: Temp table doesn't seem to work

2005-10-23 Thread SGreen
Brian Dunning <[EMAIL PROTECTED]> wrote on 10/23/2005 03:00:26 PM: > If I say this, I get all my data: > > $sql = "select * from myTable;"; > $result = mysql_query($sql); > ?> > > But if I say this, I get no results at all: > > $sql = "create temporary table xxx select * from myTable;"; > $re

Temp table doesn't seem to work

2005-10-23 Thread Brian Dunning
If I say this, I get all my data: But if I say this, I get no results at all: Seems pretty straightforward. What am I missing? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]