davishs Posted November 27, 2011 Share Posted November 27, 2011 I get this error. Warning: mysql_result() expects parameter 1 to be resource, boolean given in D:\++----LIETOTAAJI----++\Davis\Tikai MAN\Programmas\INSTALLED\wamp\www\New2\wpadmin\index.php on line 10 And I got this php code. I'm guessing I have some problems with quotes or smth. <?php #iekļauj konfigurāciju include("../config.php"); if(isset($_POST['username']) and isset($_POST['password'])) { $username = quote_smart($_POST['username']); $password = quote_smart(md5($_POST['password'])); $result = mysql_query("SELECT COUNT (*) FROM `users` WHERE nickname = $username AND password = $password"); if(mysql_result($result,0,'COUNT(*)') > 0) { echo "SELECT COUNT (*) FROM `users` WHERE nickname = $username AND password = $password"; } } ?> What is the problem, could you tell me, please? Link to comment https://forums.phpfreaks.com/topic/251864-warning-mysql_result-expects-parameter-1/ Share on other sites More sharing options...
Pikachu2000 Posted November 27, 2011 Share Posted November 27, 2011 The query is failing and mysql_query is returning boolean FALSE. mysql_error should help give you an idea as to why that's happening. Link to comment https://forums.phpfreaks.com/topic/251864-warning-mysql_result-expects-parameter-1/#findComment-1291433 Share on other sites More sharing options...
fenway Posted November 27, 2011 Share Posted November 27, 2011 It's happening because of the space between COUNT and (*). Link to comment https://forums.phpfreaks.com/topic/251864-warning-mysql_result-expects-parameter-1/#findComment-1291472 Share on other sites More sharing options...
davishs Posted November 27, 2011 Author Share Posted November 27, 2011 Now I feel a little stupid. Thanks mate. It helped. Link to comment https://forums.phpfreaks.com/topic/251864-warning-mysql_result-expects-parameter-1/#findComment-1291521 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.