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 )

Expand|Select|Wrap|Line Numbers

 
$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

Quote:

Originally Posted by 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 )

Expand|Select|Wrap|Line Numbers

 
$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:

Expand|Select|Wrap|Line Numbers

 
$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

Select records from mysql Table

re: Select records from mysql Table

re: Select records from mysql Table

Similar PHP bytes

/bytes/development

/bytes/it

/bytes/about