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

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 ... ?php $sql = 'ALTER TABLE

[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:04 -0700, revDAVE wrote: Jason

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' doesn't

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... I added :

[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'... ?php # FileName=Connection_php_mysql.htm # Type=MYSQL # HTTP=true $hostname_try1 =

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'... ?php #

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 -