[SOLVED] Login problem

[rnintulsa]

That's it! (I think)  No more fatal errors.

 

But now there are more problems.

 

Maybe all my code is meant for mysql-i since it is not working now.  Is

that possible?

 

Now I get this error.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /nfs/cust/4/45/65/556544/web/login_orion.php on line 21
You must be registered before you may log in. 

 

Just found out that the new host will not be upgrading our php and mysql as I thought.  They are only doing it for the Windows servers.

Crap.  I am going to have to make this work.

 

Any suggestions?

 

Many thanks to you for taking the time to help.

 

 

 

[MadTechie]

my bad

change

$num_rows = mysql_num_rows($result);

to

$num_rows = mysql_num_rows($results);

missed the s

 

EDIT: as a note, most people use MySQL instead of MySQLI, so any problems with after this one.. will be a useful leason (your need to learn it some time )

[MadTechie]

Also change this

	$username = $_POST['username'];
	$password = $_POST['password']; 

	//@ $db = new mysqli( 'mysql.kdesigns.net', 'username', 'password', 'dbname' );
	$link = mysql_connect('localhost', 'root', 'rn2846');

 

to

 

	//@ $db = new mysqli( 'mysql.kdesigns.net', 'username', 'password', 'dbname' );
	$link = mysql_connect('localhost', 'root', 'rn2846');

	$username = mysql_real_escape_string($_POST['username'], $link);
	$password = mysql_real_escape_string($_POST['password '], $link);

 

note: i moved the connection above the setting on username and password

using mysql_real_escape_string will protect you from SQL injections

[rnintulsa]

MadTechie... You are a God!  It works.

 

Thank you so much.

 

Thanks to all who contribute.

 

And thanks for the extra advice MadTechie. I am learning lots of useful lessons.

 

I need to learn the basics of php.  This is my first real language to learn, besides xhtml and css.

[MadTechie]

your welcome,

can you click topic solved, also did you get the PM i sent?