select * ... fejl!...
Hejsa!Hvorfor giver den sql-query fejl:
$sql = \"SELECT
companies.Name,
companies.Address,
companies.Postcode,
companies.Phone,
companies.Fax,
companies.WWW,
companies.Shop,
companies.CompanyKey,
companies.Email,
companies.CompanyDesc,
postcodes.PostCode,
postcodes.City,
html.Info
FROM companies
LEFT JOIN companies ON categorycompanylinks.CategoryKey = \'$D1\'
LEFT JOIN html ON html.CompanyKey = companies.CompanyKey
LEFT JOIN postcodes ON companies.PostCode = postcodes.Postcode
WHERE MATCH(Name) AGAINST (\'$firmanavn\') LIMIT 0, 30\";
----
fejl:
Not unique table/alias: \'companies\'
----
Lidt af vores DB Opbygning:
# Struktur dump for tabellen `categories`
#
CREATE TABLE categories (
CategoryKey int(30) NOT NULL default \'0\',
Name varchar(80) NOT NULL default \'\',
NameUK varchar(80) NOT NULL default \'\',
PRIMARY KEY (CategoryKey)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Struktur dump for tabellen `categorycompanylinks`
#
CREATE TABLE categorycompanylinks (
CategoryCompanyLinkKey int(11) NOT NULL auto_increment,
CategoryKey int(11) default NULL,
CompanyKey int(11) default NULL,
LinkExpire datetime default NULL,
PRIMARY KEY (CategoryCompanyLinkKey)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Struktur dump for tabellen `companies`
#
CREATE TABLE companies (
CompanyKey int(25) NOT NULL default \'0\',
RegionKey int(25) NOT NULL default \'0\',
Name varchar(160) NOT NULL default \'\',
Occupation varchar(80) NOT NULL default \'\',
Address varchar(80) NOT NULL default \'Ej Oplyst\',
Postcode int(25) NOT NULL default \'0\',
CounsilKey int(25) NOT NULL default \'0\',
Phone varchar(50) NOT NULL default \'\',
Fax varchar(50) NOT NULL default \'\',
Mobile varchar(50) NOT NULL default \'\',
Owner varchar(50) NOT NULL default \'\',
Email varchar(80) NOT NULL default \'\',
WWW varchar(80) NOT NULL default \'\',
Shop varchar(80) NOT NULL default \'\',
KeyWords varchar(255) NOT NULL default \'\',
KeyProducts varchar(255) NOT NULL default \'\',
Graphics varchar(255) NOT NULL default \'\',
GraphicsOnly varchar(255) NOT NULL default \'\',
GraphicsExpire varchar(255) NOT NULL default \'\',
EmailExpire varchar(255) NOT NULL default \'\',
WWExpire varchar(255) NOT NULL default \'\',
ShopExpire varchar(255) NOT NULL default \'\',
KeywordsExpire varchar(255) NOT NULL default \'\',
KeyProductsExpire varchar(255) NOT NULL default \'\',
ContactPerson varchar(80) NOT NULL default \'\',
ContactPhone tinyint(50) NOT NULL default \'0\',
CompanyDesc varchar(255) NOT NULL default \'\',
ModifiedByUser varchar(255) NOT NULL default \'\',
ModifiedByUserDate varchar(255) NOT NULL default \'\',
Modified varchar(255) NOT NULL default \'\',
Newlink varchar(255) NOT NULL default \'\',
CategoryKey int(25) NOT NULL default \'0\',
PRIMARY KEY (CompanyKey)
) TYPE=MyISAM;
# --------------------------------------------------------
#
# Struktur dump for tabellen `html`
#
CREATE TABLE html (
CompanyKey int(25) NOT NULL default \'0\',
Info text NOT NULL,
id int(25) NOT NULL auto_increment,
PRIMARY KEY (id)
) TYPE=MyISAM;
# --------------------------------------------------------
