[RESOLVED] Table 'ediblecity.partners_admin' doesn't exist

[ediblecity]

I'm a total newbie with most likely a very easy question. I am receiving the following message -

Table 'ediblecity.partners_admin' doesn't exist
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/e/d/i/ediblecity/html/temp/affiliate/admin/admin_login_validate.php on line 29

Does this mean that the table doesn't exist in the MYSQL Database or is it referring to one of the PHP files which I may need to upload to my server?

Scott

[laserlight]

It is referring to a missing table in your database.

[ediblecity]

How do I create that database? Does my Host need to do it? Thanks,

Scott

[laserlight]

The database may have been created by your host. You probably need to create the tables yourself, or use an installation script if it is provided by the script you are using.

[ediblecity]

I have an SQL file that refers to the table. Does MYSQL use the SQL file that I uploaded to the server to create the table. Here is the code -

DROP TABLE IF EXISTS partners_admin;
CREATE TABLE partners_admin (
admin_login varchar(100) NOT NULL default '',
admin_email varchar(100) NOT NULL default '',
admin_password varchar(100) NOT NULL default '',
admin_mailamnt double NOT NULL default '0',
admin_mailheader varchar(250) NOT NULL default '',
admin_mailfooter varchar(250) NOT NULL default '',
admin_ip varchar(16) default NULL,
admin_lastLogin datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (admin_login),
KEY admin_ip (admin_ip)
) ;

--

-- Dumping data for table partners_admin

Then there is a line with "Insert Into" after the dumping data line.

Scott

[laserlight]

Does MYSQL use the SQL file that I uploaded to the server to create the table.

It can use it, but only if you tell it to.

[ediblecity]

I found how to upload it to my server. Thanks,

Scott

[laserlight]

Remember to mark this thread as resolved (if it is) using the thread tools.