[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

[PHP] Alter Table newbie help needed ...

2008-04-19 Thread revDAVE
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'... The lines below don't error but also don't do anything I must be missing somet