simple SELECT FROM query

[gilbertsavier]

Could someone help with a simple MySQL request. I seem to be having trouble selecting from more than one field in the same table.

TABLE: User Data
|-----------------------|
username | password
|-----------------------|

Code:

$result = mysql_query ("SELECT `username` FROM `User Data`")
or die(mysql_error());

$row = mysql_fetch_row($result); // converts the result into an array

mysql_close($link);

echo $row[0] ;

This snip of code works fine to return one value but I want to select the 'username' and 'password' columns FROM 'user data' WHERE 'username' = '$username' AND 'password' = '$password'

... in one query.

the $username $password variables are delivered via query string.

[sanky12ka4]

You can try out this:

$result = mysql_query ("SELECT `username`,`password` FROM `User Data`")
or die(mysql_error()); 

$arr = mysql_fetch_array($result); into an array

mysql_close($link);

echo $arr[`username`] ;
echo $arr[`password`] ;