Select records from mysql Table

[X9183]

I am tearing what is left of my hair out by their roots. What I can get to work in MySQL Command line the exact same thing I cannot get to work in a PHP/MySQL script.

Here is the command line MySQL query
SELECT accesscode FROM authorize_users WHERE (user_id = 'MagooW' AND user_password = 'qwerty' and account = '46815185'; (it works accesscode 86190185 is reurned).

Here is the PHP/MySQL script command (using the same info )

$query = "SELECT access_code INTO $access FROM authorised_users
WHERE (user_id =  $userid AND user_password = $password AND
account = $account)";
$result = $db->query($query);
$db->close();
echo ('$access after SELECT = '  . $access . "<BR><BR>"); ?>
 
$access = 0.
 

[ak1dnar]

Thread moved to the Php Forum from the Cafe.
With a new thread title instead of "Can anybody help??"

Please, post the technical questions, in the relevant forums.

Back to the question
well, where is the class and its methods?

[momogi]

I am tearing what is left of my hair out by their roots. What I can get to work in MySQL Command line the exact same thing I cannot get to work in a PHP/MySQL script.

Here is the command line MySQL query
SELECT accesscode FROM authorize_users WHERE (user_id = 'MagooW' AND user_password = 'qwerty' and account = '46815185'; (it works accesscode 86190185 is reurned).

Here is the PHP/MySQL script command (using the same info )

$query = "SELECT access_code INTO $access FROM authorised_users
WHERE (user_id =  $userid AND user_password = $password AND
account = $account)";
$result = $db->query($query);
$db->close();
echo ('$access after SELECT = '  . $access . "<BR><BR>"); ?>
 
$access = 0.
 

may be should be like this:

$queri="SELECT accesscode FROM authorize_users WHERE user_id = '$_POST(thenameofyourtextfield/radiobutton/etc whichcatch the value of user id)' AND user_password = '$_POST(thenameofyourtextfield/radiobutton/etc which catch the value of user's password)' and account = $_POST(thenameofyourtextfield/radiobutton/etc which catch the value of user's account)' ";
$result=mysql_query($queri);
 
 
 

we assumed that you use the POST method here..
hope that was clear