NYCPHP Meetup

[Jerry Wing]

Jeremy, here are the column types...Please check to see if I messed up
something in my script based on variable type....my principal function
in life is business and I would appreciate it if you would catch my
errors....or anyone else....let me start with your suggestion Jeremy.... 

Here are the column types for the database UPDATE problem in my earlier
post:

keyword1 varchar(15) null
keyword2 varchar(15) null
keyword3 varchar(15) null
keyword4 varchar(15) null
keyword5 varchar(15) null
comp_id mediumint(6) unsigned null
job_id mediumint(6) unsigned primary key autoincrement
recv_date timestamp(14) null
show_date date null
job_cat tinyint(3) unsigned null
job_loc char(3) null
job_title varchar(80) null
job_desc text null
job_salary varchar(11) null
ad_expire date null
first_name varchar(40) null
last_name varchar(40) null
ad_email varchar(40) null
cntct_email varchar(40) null
usr_name varchar(15) null
p_word varchar(15) null
ad_phone varchar(12) null
cntct_phone varchar(12) null
ad_faxphone varchar(12) null
web_site varchar(50) null
visible enum('n','N','y','Y') null
ccname varchar(70) null
ccnumber varchar(30) null
monthexp char(2) null
yearexp char(2) null
cctype char(1) null
street1A varchar(80) null
street2A varchar(80) null
street3A varchar(80) null
cc_city varchar(40) null
cc_state char(2) null
cc_zip varchar(10) null
trblfone varchar(12) null