Jump to content

Archived

This topic is now archived and is closed to further replies.

Carl-Cox-

mysql queries

Recommended Posts

ok i got this code so far i thought it was right but i keep getting the error cant do it. but the line seems ok. all the tables and rows are correct im baffled.

 


$mode = $HTTP_GET_VARS[\'mode\'];

if ($mode == "login"){

 $username = $HTTP_POST_VARS[\'username\'];

 $password = $HTTP_POST_VARS[\'password\'];

 $db=mysql_connect("localhost","","") or die ("cant connect"); 

 mysql_select_db("News",$db) or die ("cant change");

 $result=mysql_query("select * from users where name=\'$username\'",$db) or die ("cant do it");

 	while ($row=mysql_fetch_array($result)) {

   if ($row["password"]==$password) {

   	print("Successfully Logged In!<a href="default.php?"\'>Click Here</a>");

   	exit;

   }

 	}

}

Share this post


Link to post
Share on other sites

Try this

 

$mode = $HTTP_GET_VARS[\'mode\']; 

  if ($mode == "login")

{ 

     $username = $HTTP_POST_VARS[\'username\']; 

     $password = $HTTP_POST_VARS[\'password\']; 

     $db=mysql_connect("localhost","","") or die ("cant connect"); 

     mysql_select_db("News",$db) or die ("cant change"); 

     $result=mysql_query("select * from users where name=\'$username\' and password=\'$password\'",$db) or die ("cant do it"); 

    $numrows = mysql_num_rows($result);



   	if ( $numrows > \'0\')

 {

 print("Successfully Logged In!<a href="default.php?"\'>Click Here</a>"); 

               exit; 



}



  } 

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.