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? 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(). 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 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? 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
Archived
This topic is now archived and is closed to further replies.