Reading the problem and save the id of the database

[pavelvodnar]

Hello, i from Czech Republic, my language is bad.

So i have problem with: Reading the problem and save the id of the database

here is my code:

if ($submit)
{

$connect = mysql_connect ("$localhost","$user","$pass") or die("Nepodařilo se připojit k databázi");

mysql_select_db ("databaze");

$vysledekSql = mysql_query("SELECT id, uzivatelskejmeno, heslo FROM klienti WHERE uzivatelskejmeno = '".$name."' AND heslo = '".$password."' ;");
echo $vysledekSql;
if ($radek = mysql_fetch_assoc($vysledekSql))
{
$_SESSION["id"]=$radek['id'];

$id=$_SESSION["id"]=$radek['id'];

}
$queryreg = mysql_query("

INSERT INTO inzeraty VALUES ('$id','','','$nadpis','$text','$date')

");
}

?>

How to fix it to my database of "inzeraty" imposing an ID from the database "klienti"? "
Thank you

[DMonster]

i still no sence what are u trying to do ?
The "id" in the your table that u can set it at like this ( id INT AUTO_INCREMENT PRIMARY KEY, )
the id will auto increase the number when the rows added first row is 1, second is 2 ...3,4...
u dont have to add the id to your table.
however your code have alot of mistakes ( how can u add the id to database when there is no id value on the form.......)