Re: Alter Table newbie help needed ...
| From: | revDAVE | Date: | Sun, 20 Apr 2008 17:54:54 +0000 |
| Subject: | Re: Alter Table newbie help needed ... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-273325@lists.php.net to get a copy of this message | ||
On 4/19/2008 2:37 PM, "Jason Norwood-Young" <jason@freespeechpub.co.za>
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]