adding new columns only through php

Fking

i created a colums in a table through php using this code

$query="CREATE TABLE movies (
title varchar(255) NOT NULL,
titlebg varchar(255) NOT NULL,
description text NOT NULL,
artists text NOT NULL,
artists2 text,
artists3 text,
artists4 text,
genre varchar(30) NOT NULL,
genre2 varchar(30),
genre3 varchar(30),
subs varchar(20) NOT NULL,
url varchar(255) NOT NULL,
pic varchar(255) NOT NULL,
size varchar(255) NOT NULL,
date varchar(255) NOT NULL
) TYPE=MyISAM;
";
mysql_query($query) or die (mysql_error());

now i need to add few new columns
how to add them at the end, and what if i need to add them at specific positons. (i do not have access to php admin or something like that, i can create columns only through php)

yelvington

http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html

Fking

thanks

i tried with this code

$query="ALTER TABLE movies (
dir varchar(255) NOT NULL AFTER subs,
url varchar(255) NOT NULL AFTER dir,
url2 varchar(255)AFTER url,
url3 varchar(255)AFTER url2

)";
mysql_query($query) or die (mysql_error());

and i'm getting this
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '( dir varchar(255) NOT NULL AFTER subs, url varchar(255) NOT NU

i know my syntax is not correct, but don't know what exactly to fix

tsinka

Hi,

try

ALTER TABLE movies ADD dir varchar(255) NOT NULL AFTER subs, 
ADD url varchar(255) NOT NULL AFTER dir, 
ADD url2 varchar(255) AFTER url, 
ADD url3 varchar(255) AFTER url2

Thomas