Using PHP to pull from table

[apw]

 

Hello I'm trying to pull just certin information from my km_switch

table such as ONLY the information in the default column that

has a Y in its column .. is this possible?

 

Also is it possible to use php to ADD new field to my km_switch

table ..

 

Adding it

ALTER TABLE `km_switch` ADD `test2` VARCHAR( 1 ) NOT NULL ;

 

Code the SQL gives me in php (which errors when place into a php

document.

$sql = 'ALTER TABLE `km_switch` ADD `test2` VARCHAR(1) NOT NULL;'; 

 

Thanks

[Bendude14]

could we see the PHP code?

 

also you dont need the semi colon at the end of your query when running through php

 

I also changed the outside quotes to doubles to avoid any confusion..

 

$sql = "ALTER TABLE `km_switch` ADD `test2` VARCHAR(1) NOT NULL";