Queries …

function count ($sqllink,$dealer,$region,$marke)
	SELECT count(*) AS count FROM haendler,regionen WHERE 1=1 AND regionen.haendler=haendler.id AND regionen.region='$region'  AND firma LIKE '%$dealer%' ORDER BY firma
 
function load2($sqllink,$first,$count,$page,$buchstaben_count, $order="id",$dealer,$region,$marke)
	SELECT * FROM  haendler,regionen  AND regionen.haendler=haendler.id AND regionen.region='".$region." AND $order LIKE '%$dealer%' ORDER BY $order