Re: Alter Table newbie help needed ...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 4/19/2008 2:37 PM, "Jason Norwood-Young" <jason@xxxxxxxxxxxxxxxxxxx>
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 exist

- so I guess it was not knowing to use the 'try1' connection ( try1.ztest) -
(connect2 was some other one I set up for something else)

I'm using Dreamweaver cs3 - maybe it's confused?

Q: Is there a way to insure that it uses the right connection ( try1 - not
connect2 )?


BTW: I tried `try1.ztest` but it didn't like that:

$sql = 'ALTER TABLE `try1.ztest` ADD `myfield2` VARCHAR(10) NOT NULL;';


--
Thanks - RevDave
Cool @ hosting4days . com
[db-lists]




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux