Re: Alter Table newbie help needed ...
| From: | revDAVE | Date: | Mon, 21 Apr 2008 21:46:44 +0000 |
| Subject: | Re: Alter Table newbie help needed ... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-273379@lists.php.net to get a copy of this message | ||
On 4/21/2008 2:04 PM, "revDAVE" <Cool@hosting4days.com> 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
ztest ADD newfield3 VARCHAR(50) NOT NULL;';
mysql_select_db($database_try1, $try1);
$result = mysql_query($sql) or die("no good dB $sql" . mysql_error());
?>
Old - no
<?php
$sql = 'ALTER TABLE ztest ADD newfield3 VARCHAR(50) NOT NULL;';
$result = mysql_query($sql) or die("no good dB $sql" . mysql_error());
?>
--
Thanks - RevDave
Cool @ hosting4days . com
[db-lists]