Dear all,
Can any body guide me how to insert into date field
mysql_query("CREATE TABLE ft02tbl (
ft02 int(11) NOT NULL auto_increment,
a0 varchar(255) NOT NULL default '',
a1 varchar(2) NOT NULL default '',
a2 varchar(255) NOT NULL default '',
a3 varchar(255) NOT NULL default '',
a4 varchar(50) NOT NULL default '',
a5 varchar(255) NOT NULL default '',
a6 varchar(255) NOT NULL default '',
a7 varchar(255) NOT NULL default '',
a8 varchar(255) NOT NULL default '',
a9 varchar(255) NOT NULL default '',
a10 varchar(255) NOT NULL default '',
a11 date NOT NULL default '00/00/0000' ,
a12 varchar(255) NOT NULL default '',
a13 varchar(5) NOT NULL default '00:00',
a14 date NOT NULL default '00/00/0000' ,
a15 varchar(5) NOT NULL default '00:00',
a16 varchar(2) NOT NULL default 'o',
a17 text,
a18 text,
a19 varchar(255) NOT NULL default '',
a20 varchar(255) NOT NULL default '',
a21 varchar(255) NOT NULL default '',
a22 varchar(255) NOT NULL default '',
a23 varchar(255) NOT NULL default '',
a24 varchar(255) NOT NULL default '',
a25 varchar(5) NOT NULL default '00:00',
a26 varchar(2) NOT NULL default 'Y',
a27 varchar(2) NOT NULL default 'N',
a28 varchar(55) NOT NULL default 'N',
a29 text,
PRIMARY KEY (ft02)
) TYPE=MyISAM") or die("update error due to :" . mysql_error());
mysql_query("insert into ft02tbl
(a0,a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,a11,a12,a13,a14,a15,a16,a17,a18,a19,a20,a
21,a22,a23,a24,a25,a26,a27,a28) values
('name','n','1','1418','24','Email','url','pone','sdf','jhkj','kj',2005-24-0
1,'lkjlkjlkjl;kjhkjhkj;kjhkjkj;kjhkjk','17:16',2005-29-10,'4:13','y','a17','
a18','a19','a20','a21','a22','a23','a24',9999,'Y','N','admin') ") or
die("update error due to :" . mysql_error());
ft02 a0 a1 a2 a3 a4 a5 a6 a7 a8 a9 a10 a11 a12 a13 a14 a15 a16 a17 a18
a19 a20 a21 a22 a23 a24 a25 a26 a27 a28 a29
1 name n 1 1418 24 Email url pone sdf jhkj kj 0000-00-00
lkjlkjlkjl;kjhkjhkj;kjhkjkj;kjhkjk 17:16 0000-00-00 4:13 y a17 a18 a19 a20
a21 a22 a23 a24 9999 Y N admin
in field a11 and a14
is not working properly.
regards,
Mukesh
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/HKFolB/TM
--------------------------------------------------------------------~->
Community email addresses:
Post message: [email protected]
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-list/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
