[Fwd: Re: [PHP] Alter Table newbie help needed ...]

2008-04-21 Thread Jason Norwood-Young
Darn forgot to hit "reply to all" Forwarded Message From: Jason Norwood-Young <[EMAIL PROTECTED]> To: revDAVE <[EMAIL PROTECTED]> Subject: Re: [PHP] Alter Table newbie help needed ... Date: Mon, 21 Apr 2008 23:52:30 +0200 On Mon, 2008-04-21 at 14:0

Re: [PHP] Alter Table newbie help needed ...

2008-04-21 Thread revDAVE
On 4/21/2008 2:04 PM, "revDAVE" <[EMAIL PROTECTED]> wrote: > : Is there a way to insure that it uses the right connection ( try1 - not > connect2 )? - seems to be ok now with this new db selector line... mysql_select_db($database_try1, $try1); // this new line New ... Old - no -- Thank

Re: [PHP] Alter Table newbie help needed ...

2008-04-21 Thread revDAVE
Jason & David, Thanks so much for your help BTW: to reiterate the problem: I guess it was not knowing to use the 'try1' connection ( try1.ztest) - and used 'connect2' connection instead... Error said : Table 'connect2.ztest' doesn't exist (connect2 was some other one I set up for something e

Re: [PHP] Alter Table newbie help needed ...

2008-04-20 Thread David Giragosian
On 4/20/08, revDAVE <[EMAIL PROTECTED]> wrote: > > On 4/19/2008 2:37 PM, "Jason Norwood-Young" <[EMAIL PROTECTED]> > wrote: > > > Might be obvious but you are doing "mysql_query($sql);", right? > > Hello Jason, > > Thanks - Your idea worked well - for a while - but then I ran into > trouble... > >

Re: [PHP] Alter Table newbie help needed ...

2008-04-20 Thread revDAVE
On 4/19/2008 2:37 PM, "Jason Norwood-Young" <[EMAIL PROTECTED]> wrote: > Might be obvious but you are doing "mysql_query($sql);", right? Hello Jason, Thanks - Your idea worked well - for a while - but then I ran into trouble... I added : mysql_error() and it said: Table 'connect2.ztest' doe

Re: [PHP] Alter Table newbie help needed ...

2008-04-19 Thread revDAVE
On 4/19/2008 2:37 PM, "Jason Norwood-Young" <[EMAIL PROTECTED]> wrote: > Might be obvious but you are doing "mysql_query($sql);", right? Not so obvious to THIS newbie - now it works fine! Thanks AGAIN! > > Also add a try catch around your mysql_query to check what's happening. -- Thanks

Re: [PHP] Alter Table newbie help needed ...

2008-04-19 Thread Jason Norwood-Young
On Sat, 2008-04-19 at 14:23 -0700, revDAVE wrote: > Newbie - MAC - MAMP on port 8889 > > I have this connection to Mysql database called 'test' > > > Other Php stuff works ok but now I'm trying to alter the table (never did > that before...) > > > > Connection called 'try1'... > > # FileNa