[PHP] Alter Table newbie help needed ...

[revDAVE <Cool@xxxxxxxxxxxxxxxx>]

Newbie - MAC - MAMP on port 8889

I have this connection to Mysql database called 'test'


Other Php stuff works ok but now I'm trying to alter the table (never did
that before...)



Connection called 'try1'...

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_try1 = "127.0.0.1:8889";
$database_try1 = "test";
$username_try1 = "test";
$password_try1 = "test";
$try1 = mysql_pconnect($hostname_try1, $username_try1, $password_try1) or
trigger_error(mysql_error(),E_USER_ERROR);
?>

The lines below don't error  but also don't do anything....

I must be missing something here.... Right? Maybe it doesn't know to use
try1 connection? How do I add that?

<?php
$sql = 'ALTER TABLE `ztest` ADD `myfield2` VARCHAR(10) NOT NULL;';
---or---
$sql = 'ALTER TABLE `ztest` RENAME TO `ztest2`;';

 ?>





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




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