[ CiM0beTa @ 22.03.2013. 07:33 ] @
Code (php):


// uzimanje user_id
function user_id_from_username($username) {
     
     return mysql_result(mysql_query("SELECT `user_id` FROM `users` WHERE `username` = '$username'"), 0, 'user_id');
}

 


Kada u formi unesem nepoznato korisnicko ime, vraca mi gresku:

Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 8 in D:\wamp\www\web\novo\functions\log_reg.php on line 115

kako da je otklonim? hvala unapred.
[ MoDcHe @ 22.03.2013. 08:54 ] @
Code:

function user_id_from_username($username) {
     $q = mysql_fetch_array(mysql_query("SELECT `user_id` FROM `users` WHERE `username` = '$username'"));
     return ($q) ? $q['user_id'] : 'Nepostojece korisnicko ime';
}
echo user_id_from_username($username);
[ Predrag Supurovic @ 22.03.2013. 10:30 ] @
Ovo isto je pitano pre par dana...