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