Problem using wpdb
-
Hi,
I want to create a table using wpdb and dbDelta.
The code is as follows. But the table is not getting created and I’m also not getting any error message.$sql = “create table $table_name (
club_id int(11) NOT NULL auto_increment,
project_name varchar(500) NOT NULL,
first_name varchar(100) NOT NULL,
school_status varchar(50) NOT NULL,
school_name varchar(200) NOT NULL,
school_city varchar(50) NOT NULL,
school_state varchar(50) NOT NULL,
year_in_school varchar(50) NOT NULL,
age int(2) NOT NULL,
email varchar(200) NOT NULL,
mobile varchar(15) NOT NULL,
chat_id varchar(50) NOT NULL,
facebook_page_link varchar(200) NOT NULL,
mailing_address_street varchar(50) NOT NULL,
mailing_address_city varchar(50) NOT NULL,
mailing_address_state varchar(50) NOT NULL,
mailing_address_zip char(6) NOT NULL,
social_networking varchar(50) NOT NULL,
organization_involvement varchar(2000) NOT NULL,
club_heard varchar(50) NOT NULL,
volunteer_experience varchar(2000) NOT NULL,
volunteer_reason varchar(2000) NOT NULL,
skills varchar(2000) NOT NULL,
creative_ideas varchar(5000) NOT NULL,
other_information varchar(2000) NOT NULL,
face_photo_url varchar(200),
school_image_url varchar(200),
video_clip_url varchar(200),
PRIMARY KEY (club_id)
);”;require_once(ABSPATH . ‘wp-admin/includes/upgrade.php’);
dbDelta($sql);Can you guys please help?
Thanks a lot in advance.
- The topic ‘Problem using wpdb’ is closed to new replies.