guys!

[youtube]

how can create table on SQL about email.

 

like this

CREATE TABLE IF NOT EXISTS `E-Inquiry` (
`ID` bigint(20) unsigned NOT NULL auto_increment,
`Sender_ID` int(11) unsigned NOT NULL default '0',
`Sender_Name` varchar(30) NOT NULL default '',
`Title` text,
`Message` text,
`Status` tinyint(2) NOT NULL default '0',
`Inquiry_Time` datetime NOT NULL default '0000-00-00 00:00:00',
`Reply` text,
`Reply_Time` datetime NOT NULL default '0000-00-00 00:00:00',
`Reply_Name` varchar(30) NOT NULL default '',
PRIMARY KEY  (`ID`)
) ENGINE=MyISAM;

 

i dunno how to create a table for 

E-Inquiry

 

 

Edited July 4, 2013 by youtube

[Archetype Saber]

are you familiar with SQL Query ? 

[Patskie]

What framework are you using? Just execute the command

[youtube]

OOP how?

@OOP .. can you help me? 

What framework are you using? Just execute the command

Patskie see the control panel

are you familiar with SQL Query ? 

suyothegreat

10% familiar master

[Archetype Saber]

it's patskie not OOP Hahaha, anyway, delete the existing table "E-Inquiry" then Paste the SQL to the query then execute it.

[youtube]

can you post the SS of SQL 

[Patskie]

E-inquiry table i guess is made only by Emistry. so if E-inquiry table is already there then i conclude that there should be no problem on emistry script.

[youtube]

suyothegreat i change the"E-Inquiry" to "SQL" there no happen

suyothegreat i change the"E-Inquiry" to "SQL"  same error

my SQL table is correct or have wrong?

[Archetype Saber]

suyothegreat i change the"E-Inquiry" to "SQL" there no happen

suyothegreat i change the"E-Inquiry" to "SQL"  same error

 

my SQL table is correct or have wrong?

No No No No .. delete the Existing "E-Inquiry" table then Execute this SQL Code

CREATE TABLE IF NOT EXISTS `E-Inquiry` (

`ID` bigint(20) unsigned NOT NULL auto_increment,

`Sender_ID` int(11) unsigned NOT NULL default '0',

`Sender_Name` varchar(30) NOT NULL default '',

`Title` text,

`Message` text,

`Status` tinyint(2) NOT NULL default '0',

`Inquiry_Time` datetime NOT NULL default '0000-00-00 00:00:00',

`Reply` text,

`Reply_Time` datetime NOT NULL default '0000-00-00 00:00:00',

`Reply_Name` varchar(30) NOT NULL default '',

PRIMARY KEY  (`ID`)

) ENGINE=MyISAM;

[youtube]

 

mmmmm