CREATE TABLE `tabulka` (
`id` int(11) NOT NULL auto_increment,
`odkaz` text NOT NULL,
`navod` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
tu je komplet kod
<?
$db = mysql_connect("server", "meno", "heslo") or die("Pripojenie k databaze zlyhalo.");
if(!$db)
die("Databaza zlyhala.");
if(!mysql_select_db("databaza",$db))
die("Ziadna databaza nebola vybrata.");
?>
<script>
function zobrazSkryj(idecko){
el=document.getElementById(idecko).style;
el.display=(el.display == 'block')?'none':'block';
}
</script>
<style>
h3 {cursor: pointer; cursor: hand; text-decoration: underline}
.skryvany {display: none}
</style>
<?
$navody="SELECT * from tabulka order by ID ASC";
$navody2=mysql_query($navody) or die("Chybny SQL dotaz na databazu.");
while($navody3=mysql_fetch_array($navody2))
{
echo "<h3 onclick=\"zobrazSkryj('$navody3[ID]')\">$navody3[odkaz]</h3><div id=\"$navody3[ID]\" class=\"skryvany\">$navody3[navod]</div>";
}
?>