Zapis dat do mysql – PHP – Fórum – Programujte.com

co mam na nasledujicim kodu spatne? ma zapsat data do databaze mysql ale nefeunguje to..

-----formular.html--------
<form action="obsluha.php" method="POST">
<input type="text" name="jmeno">
<input type="submit">
</form>

---------obsluha.php--------------
<?
if(isset($_POST['jmeno'])){
$dbuser="root";
$dbpass="root";
$dbname="rs";
$chandle = mysql_connect("localhost", $dbuser, $dbpass)
or die("Connection Failure to Database");
mysql_select_db($dbname, $chandle) or die ($dbname . " Database not found." . $dbuser);
mysql_query("INSERT INTO rs (text) VALUES '$jmeno' ");
}
?>

<?php
include ("mysql_spojit.php");
$query = "SELECT * FROM rs ORDER BY id";
$result = mysql_query($query, $link) or die ("SQL dotaz nešlo provést.");
while ($row=mysql_fetch_array($result))
echo "".$row["text"]."";
mysql_free_result($result);
mysql_close();
?>

zdravim,
prvni pohled, v podmince pouzivas $_POST['jmeno'], ale v dotazu potom uz jen $jmeno, pokud je register_globals na off($_POST['jmeno'] neni $jmeno), tak je v promenne $jmeno prazdna hodnota - NULL, zjistis jednoduse, kdyz si das

echo "INSERT INTO rs (text) VALUES '$jmeno' ";

echo mysql_error();