I have the following lines in my php code:
[php:1:46b06602e6]<?php
$Query1 = \"insert into table values (NULL, \'$user\', PASSWORD(\'$pass\'))\";
$Result1 = mysql_query($Query1, $DB);
$Query2 = \"select * from table where user=\'$user\' and pass=PASSWORD(\'$pass\')\";
$Result2 = mysql_query($Query2, $DB);
echo mysql_num_rows($Result2);
?>[/php:1:46b06602e6]
(column names are correct)
What is echoed is the number of rows returned. The number echoed is zero (0). How is that possible? Am I doing something wrong?
The same thing happens when I use an MD5 function. Also, I tried inserting new row with phpMyAdmin, and then reading it in php, but still it returned nothing. I also tried adding a new row in a console window, then reading it (with select) in a console window, and mysql returned an empty set.
However, when I try doing it without using mysql functions, then it works. For example, this works perfectly:
[php:1:46b06602e6]<?php
$Query1 = \"insert into table values (NULL, \'$user\', \'$pass\')\";
$Result1 = mysql_query($Query1, $DB);
$Query2 = \"select * from table where user=\'$user\' and pass=\'$pass\'\";
$Result2 = mysql_query($Query2, $DB);
echo mysql_num_rows($Result2);
?>[/php:1:46b06602e6]
What\'s wrong with the functions?
S0urce