php mysql

<h3><?echo"$title"?></h3>



<?

include("strankovani.php");



$q=MySQL_Query("SELECT * FROM menu_organizace WHERE name2 LIKE '$section'")

or Die ("Not able to select data from database, table section");

$sekce=MySQL_Fetch_Array($q);

$pocet=$sekce["counter"];



include("strany.php");



$sql="SELECT * FROM clanky_organizace WHERE section LIKE

'".$sekce["id"]."' OR section2 LIKE '".$sekce["id"]."' OR section3

LIKE '".$sekce["id"]."' OR section4 LIKE '".$sekce["id"]."' ORDER BY

id DESC LIMIT $limit";

$q=MySQL_Query($sql) or Die("Not able to select data from database, table

games");

while($echo=MySQL_Fetch_Array($q)):

$q2=MySQL_Query("SELECT name FROM menu_organizace WHERE id LIKE

'".$echo["section"]."'") or Die ("Chyba při výběru z databáze");

$echo2=MySQL_Fetch_Row($q2);



$echo2["0"]=StrToLower($echo2["0"]);

$co=array("/á/","/č/","/ď/","/é/","/ě/","/í/","/ĺ/","/ľ/","/ň/

","/ó/","/ř/","/ŕ/","/š/","/ť/","/ú/","/ů/","/ý/","/ž/","/ä/

","/ë/","/ö/","/ô/","/ü/","/Á/","/Č/","/Ď/","/É/","/Ě/","/Í/

","/Ĺ/","/Ľ/","/Ň/","/Ó/","/Ř/","/Ŕ/","/Š/","/Ť/",

"/Ú/","/Ů/","/Ý/","/Ž/","/Ä/","/Ë/","/Ö/","/Ü/","/-/","/

/",);

$cim=array("a","c","d","e","e","i","l","l","n","o","r","r

","s","t","u","u","y","z","a","e","o","o","u","A","C"

,"D","E","E","I","L","L","N","O","R","R","S","T",

"U","U","Y","Z","A","E","O","U","","-");

$prehod=preg_replace($co, $cim, $echo["name"]);

$echo2["0"]=preg_replace($co, $cim, $echo2["0"]);





echo '<h2><a class="h2"

href="'.$echo["id"].'/'.$echo2["0"].'/'.$pr

ehod.'';

echo '" >'.$echo["name"].'</a></h2>';

echo '<dfn>'.$echo["controls"].'</dfn>';



endwhile;



echo $str;



?>