God knows what is the problem

• 0Niko još nije pohvalio poruku.
  Registruj se da bi pohvalio/la poruku!

I will give you the book if you want to see. I need to check but i still think that this function exist.

• 0Niko još nije pohvalio poruku.
  Registruj se da bi pohvalio/la poruku!

No, it doesn't exist. I checked. If function Password() exists, shouldn't be some kind of manual for it on http://www.php.net/manual/en/function.password.php ?

Try replacing Password() with md5() and everything should be ok

• 0Niko još nije pohvalio poruku.
  Registruj se da bi pohvalio/la poruku!

here is the query and it's not working
$query="SELECT username,password FROM 'table' WHERE username='".$_POST['username']."' and password = md5('".$_POST['password']."') ";
why?

• 0Niko još nije pohvalio poruku.
  Registruj se da bi pohvalio/la poruku!

$query="SELECT `username`,`password` FROM `table` WHERE `username`='".$_POST['username']."' and `password` = '".md5($_POST['password'])."'";

What is the point of taking the username and password from the database when you already have them?

• 0Niko još nije pohvalio poruku.
  Registruj se da bi pohvalio/la poruku!

i forgot to mansion that this is for checking the password.

Dopuna: 07 Maj 2007 19:49

with this query it give me "Query was empty".

• 0Niko još nije pohvalio poruku.
  Registruj se da bi pohvalio/la poruku!

Try reading this http://www.php.net/function.md5 and then do modification on your code

• 0Niko još nije pohvalio poruku.
  Registruj se da bi pohvalio/la poruku!

I read the hole page but when i type in mysql console this code

select * from 'table' where username = 'user' and password = md5('pass');

it gives me empty row

here is the insert query
insert into 'table' values (null, 'user' , md5('pass') );

and the password is stored in the table in encryption form.

• 0Niko još nije pohvalio poruku.
  Registruj se da bi pohvalio/la poruku!

try instead 'table' to use `table`

• 0Niko još nije pohvalio poruku.
  Registruj se da bi pohvalio/la poruku!

man that it's not the problem.

if i want to write
insert into table values (null, 'user' , md5('pass') );

it will be ok with the query, but the problem is in the md5 function.

and for the gay who said that Password function doesnt exist, he should see the "PHP and MySQL 3dbuzz" video or this book "Wrox - Beginning PHP, Apache, MySQL Web Development - 2004 - (By Laxxuss).pdf" to see that there is a function password() and also md5 function.

btw can you give me and short example for login script (insert for inserting a user and select for checking the usernam password)

• 0Niko još nije pohvalio poruku.
  Registruj se da bi pohvalio/la poruku!

You should have ; after md5()