Search the Community
Showing results for tags 'mysql_result'.
Found 2 results
-
I have created some custom functions like these: function folder_exists($folder){ global $connection; $sql_folder_exists = "SELECT COUNT(`album_id`) FROM `albums` WHERE `folder` = '{$folder}' LIMIT 1"; $folder_exists = mysql_query($sql_folder_exists, $connection) or die(mysql_error()); return (mysql_result($folder_exists, 0) == 1) ? true : false;} function total_users(){global $connection;$sql_total_users = "SELECT COUNT(`user_id`) FROM `users` ";$total_users = mysql_query($sql_total_users,$connection) or die(mysql_error());return mysql_result($total_users, 0);} , but I decided to use the mysqli_* functions instead. My question is which mysqli_ function is used instead if the mysql_result in these cases??? I've searched through the manual and gives these functions mysqli_data_seek() , mysqli_field_seek() and mysqli_fetch_field(), but when i tried them they did not gave me the expected result and obviously ther's no mysqli_result() function.
-
ok i ran into an error i can not figure out how to fix and this is the code where the error started function login_check($email, $password){ $email = mysql_real_escape_string($email); $login_query = mysql_query("SELECT COUNT(`users_id`) as `count`, `users_id` FROM `users` WHERE email='$email' AND password='".md5($password)."'"); // the error starts belowreturn (mysql_result($login_query, 0) === 1) ? mysql_result($login_query, 0, `user_id`) : false;} the error started below where i placed a commentim trying to use that return(); to say if a person login info is true or false
