DECLARE id_modela int(10) DEFAULT 0;
DECLARE id_usera int(11) DEFAULT 0;

BEGIN
SELECT id_model
INTO id_modela
FROM model
WHERE model_name=model1
LIMIT 1;

SELECT id_user
INTO id_usera
FROM users
WHERE username=username1 AND password=password1
LIMIT 1;


IF id_modela='' OR id_usera=null
then set poruka='Poglesan password ili nepostojeci model'
else set poruka='Postojeci model i user'
end if;


INSERT INTO `car` (`id_oglas`, `id_model`, `id_user`, `stanje`, `godiste`, `broj_vrata`, `broj_sedista`, `registrovan`, `gorivo`, `horse_power`, `boja`, `servo`, `klima`, `opis`, `price`) VALUES (NULL, id_modela, id_usera, stanje1, godiste1, broj_vrata1, broj_sedista, registrovan, gorivo1, horse_power1, boja1, servo1, klima1, opis1, price1);
select poruka;
END