Hi there,

Here is a problem, while using the MySql. I am using a third party ecommerce software for my application. This about storing the credit card details in to the 'transaction' table. It was working fine earlier untill I added two new row in to the table one is teh 'start_date' and the other is the 'issue_number' properties are set fine. But, I am unable to insert/update those values in to the table.

If I log through my 'PhpMyAdmin', I can view the row filled with the "NULL" inthe value field. How can I update the table? any solution???

this is the table,
--------------------------
CREATE TABLE `transaction` (
`orderid` int(10) unsigned NOT NULL auto_increment,
`name_on_card` varchar(150) default NULL,
`card_no` varchar(50) default NULL,
`card_type` varchar(50) default NULL,
`start_date` varchar(25) default NULL,
`expir_date` varchar(20) default NULL,
`issue_number` char(2) default NULL,
`***2` varchar(10) default NULL,
`ccstatus` varchar(30) default NULL,
`status` varchar(200) default NULL,
PRIMARY KEY (`orderid`)
) TYPE=MyISAM AUTO_INCREMENT=234603 ;

--------------------------
Thanks & Regards,

JD in UK

hi,
this should have been possible. Can I know how you tried to insert/update values into those fields?

The following queries should work.

For insert:
insert into transaction set issue_number='cv' , start_date='2000-10-10'

For update

update transaction set issue_number='cv' , start_date='2000-10-10'
where orderid='2'

or

update transaction set issue_number='cv' where issue_number is null


Regards,
Selin.

Hi Selin,

THank you, It is working fine.

Thanks & Reagrds

JD in UK