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

[revDAVE <Cool@xxxxxxxxxxxxxxxx>]

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