fert Posted July 15, 2006 Share Posted July 15, 2006 [code]<?php setcookie("user","",0,"/","www.usnet1.net",0);?><html><head><title>Log-in</title></head><body bgcolor="default"><?php $cn=@mysql_connect("localhost","username","password") or die(mysql_error()); @mysql_select_db("database name",$cn); $sql="SELECT password FROM $_POST[username]"; $result=@mysql_query($sql,$cn) or die(mysql_error()); if($result!=$_POST[password]) { echo $result; die("Incorrect password!"); } else { $_COOKIE[user]=$_POST[username]; echo "Welcome"; echo "<a href=\"panel.php\">Control panel</a>"; }?></body></html>[/code]When i run this script it gives: Resource id #2Incorrect password!what's wrong? Quote Link to comment https://forums.phpfreaks.com/topic/14696-sql-query-not-working-in-php/ Share on other sites More sharing options...
akitchin Posted July 15, 2006 Share Posted July 15, 2006 as it says in the manual, mysql_query() returns a resource ID for the results of the query. in order to extract the results, you need to use a grabbing function such as mysql_fetch_row(), mysql_fetch_array(), or mysql_result(). Quote Link to comment https://forums.phpfreaks.com/topic/14696-sql-query-not-working-in-php/#findComment-58633 Share on other sites More sharing options...
fert Posted July 15, 2006 Author Share Posted July 15, 2006 Thanks Quote Link to comment https://forums.phpfreaks.com/topic/14696-sql-query-not-working-in-php/#findComment-58634 Share on other sites More sharing options...
Barand Posted July 15, 2006 Share Posted July 15, 2006 [quote]$sql="SELECT password FROM $_POST[username]";[/quote]Do you really have table for each user, each table having a record containing the password? Quote Link to comment https://forums.phpfreaks.com/topic/14696-sql-query-not-working-in-php/#findComment-58699 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.