I used this: mysql_query("INSERT INTO `items` (`id`,`user_id`, `room_id`, `base_item`, `extra_data`) VALUES ('rand(1,1000)','" . $_SESSION['user']['id'] . "','0', '" . mysql_real_escape_string($badge['rares_id']) . "','')");
but it only inserted the id as 0