[aprogrammer]

Can someone help me with this error

PHP Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING

the problem line of code is the following:

$sql="select * from Admin where AdminName='$_POST['username']' and AdminPassword='$_POST['password']'";


what is causing the error?

[dennispopel]

$sql="select * from Admin where AdminName='$_POST[username]' and AdminPassword='$_POST[password]' ";

[aprogrammer]

thanks..
can you help me out with another error (sorry i'm pretty new to php)

$result = @mysql_query($sql);
$num_rows=mysql_num_rows($result);

I get an error

PHP Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource

what am I doing wrong?

[wheezy360]

This means that your sql query probably has an error (or there was some other error that occurred when performing the query).

PHP Code:

// Removed the @ warning suppression.  

// If you're in development, you _want_ warnings.  Suppressing them will only cause confusion

$result = mysql_query($sql) or die(mysql_error());

$num_rows = mysql_num_rows($result); 

Get back to us when you know what the mysql_error() returns.

[FiRe]

eugh i hate that error!

PHP Code:

$sql = "SELECT * FROM Admin WHERE AdminName='{$_POST['username']}' AND AdminPassword='{$_POST['password']}'";

$result = mysql_query($sql);

$num_rows = mysql_num_rows($result); 

[aprogrammer]

this is strange

when I write out the sql (using echo $sql) it is:

select from Admin where AdminName='abc' and AdminPassword='box1234'


But the error shows: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'from Admin where AdminName='abc' and AdminPassword='box123

seems to be custting teh 4 and end string tag.

what do you think is causing this?

[FiRe]

have u tried my code?

[aprogrammer]

yes it returned the same error

[wheezy360]

This is because you haven't selected any fields in your SQL statement.

SELECT * FROM Admin .....

as opposed to

SELECT FROM Admin .....

[FiRe]

that shouldnt matter, i use select * every time for user authentication :|