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? Quote Link to comment 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. Quote Link to comment 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 (*). Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.