Count(*) :P
Jeg vil gerne finde antallet af fundne firmaer ved brug af count(*):$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 categorycompanylinks ON companies.CompanyKey = categorycompanylinks.CompanyKey
LEFT JOIN categories ON categories.CategoryKey = categorycompanylinks.CategoryKey
LEFT JOIN html ON html.CompanyKey = companies.CompanyKey
LEFT JOIN postcodes ON companies.PostCode = postcodes.Postcode
WHERE MATCH(companies.Name, companies.CompanyDesc, companies.Address, companies.Occupation, companies.KeyProducts) AGAINST ('$keyword1') order by categories.Name ASC order by companies.Name";
$result1 = mysql_query($sql) or die(mysql_error());
Men det funker bare ik :'(
