Is there an automated way to do this? How about a good faq on the subject? I don't want to have to convert the whole darn thing by hand:
CREATE TABLE ".$table_prefix."links_cat (
id bigint(20) NOT NULL auto_increment,
name text NOT NULL,
hidden tinyint(2) NOT NULL default '1',
owner mediumint(10) NOT NULL default '0',
UNIQUE KEY id (id)
) TYPE=MyISAM
","
CREATE TABLE ".$table_prefix."links_url (
id bigint(20) NOT NULL auto_increment,
url text NOT NULL,
name text NOT NULL,
description text NOT NULL,
added int(11) default NULL,
owner mediumint(8) NOT NULL default '0',
clickcounter int(12) NOT NULL default '0',
lastclickid mediumint(8) NOT NULL default '0',
lastclicktime int(11) NOT NULL default '0',
bbcode_uid varchar(10) NOT NULL default '',
enable_bbcode tinyint(1) NOT NULL default '1',
UNIQUE KEY id (id)
) TYPE=MyISAM
","
CREATE TABLE ".$table_prefix."links_urlincat (
id bigint(20) NOT NULL auto_increment,
url_id bigint(20) NOT NULL default '0',
cat_id bigint(20) NOT NULL default '0',
pos mediumint(10) NOT NULL default '9999',
UNIQUE KEY id (id)
) TYPE=MyISAM
","
INSERT INTO ".$table_prefix."links_cat VALUES (1,'Default','','')
","
INSERT INTO ".$table_prefix."links_url VALUES (1,'www.handykoelsch.de','Handykoelsch','Kölns größtes Mobiltrunkforum. Definitely worth a visit ;)',1021659072,0,0,0,0,0,0)
","
INSERT INTO ".$table_prefix."links_urlincat VALUES (1,1,1,9999)
",
);
Converting mySQL query to MS Access query...
Moderator: General Moderators
Bad news: You won't be able to use your code directly in Access, because its in PHP for use on a MySQL database.
Good news: You can use MyODBC to connect Access to MySQL. So you will need to create the tables and entries with you code above using PHP, and insert into MySQL.
You can then link to the MySQL db with Access for viewing (updating is a bit akward), or importing for saving in Access.
MyODBC : http://www.mysql.com/downloads/api-myodbc-2.50.html
Good news: You can use MyODBC to connect Access to MySQL. So you will need to create the tables and entries with you code above using PHP, and insert into MySQL.
You can then link to the MySQL db with Access for viewing (updating is a bit akward), or importing for saving in Access.
MyODBC : http://www.mysql.com/downloads/api-myodbc-2.50.html