WampServer

The problem is that qhen i do an sql querie like this "SELECT * FROM user WHERE name = $usrName and pwd = password('$password')" in phpmyadmin i get this message "MySQL returned an empty result set (i.e. zero rows)."

I don't know what's wrong.

Thanks in advance!

you have a php syntax error. You wrote:
"SELECT * FROM user WHERE name = $usrName and pwd = password('$password')"

Change to:
"SELECT * FROM user WHERE name = $usrName and pwd = $password('password')"



Post Edited (06-07-06 05:24)

CyberSpatium
----------------------
WAMP Forum Admin

Web Development for Newbie's Blog - Check out my new blog. It is for web developers, and especially tailored for the web development newbie. If you are not fluent in “geek speak”, then this incredible resource is just you. And even if you are a web development pro, this is a great resource to check out some of the latest web development tips, news, tutorials, codes and more.

That probably wont work either. I generally use:

mysql_query("SELECT * FROM user WHERE name='".$usrName."' AND pwd='".password('password')."'";



Post Edited (06-07-06 05:28)

just a note to somone who tries to use the above code, it too has a syntax error... change:
mysql_query("SELECT * FROM user WHERE name='".$usrName."' AND pwd='".password('password')."'";

to
mysql_query("SELECT * FROM user WHERE name='".$usrName."' AND pwd='".$password('password')."'";

That code has a syntax error too.

I've tried this code in php:

<?php
$sql = "SELECT * FROM user WHERE name = " .$userName. " and pwd = password('" .$userPwd. "')";
$result = mysql_query($sql);
?>

and i don't get a result.

everyone keeps using the same incorrect syntax. you all keep using:
password('password')

and I keep saying change it to:
$password('password')


Here is the correct syntax to use for your php code:

<?php

$sql = "SELECT * FROM user WHERE name = " . $userName . " AND pwd = " . $password('password') . "";

$result = mysql_query($sql);

?>



Post Edited (06-07-06 13:25)

CyberSpatium
----------------------
WAMP Forum Admin

Web Development for Newbie's Blog - Check out my new blog. It is for web developers, and especially tailored for the web development newbie. If you are not fluent in “geek speak”, then this incredible resource is just you. And even if you are a web development pro, this is a great resource to check out some of the latest web development tips, news, tutorials, codes and more.

When i use the code above i get this message: "Parse error: parse error, unexpected T_STRING"

I don't understand why you say that the rigt way is "$password".

password() is a function, not a varible hence hving a $ in front of it will cause troubles. Try this instead.

$usrPass = password("password";
mysql_query("SELECT * FROM user WHERE name='".$usrName."' AND pwd='".$usrPass."'";

php does not have a password() function.

But mysql does And he could have probably made his own function like:

function password($pass)
{
return md5($pass);
}

or something more complex.



Post Edited (06-09-06 01:21)