MySQL and MySQL SELECT

does anybody know why this works in MySQL monitor and not with PHP& MySQL??

mysql> use test_db;

Database changed

mysql> select * from authorised_users;
+--------------+------------------+--------------+---------------+----------+-------------+
| user_name | company | user_id | user_password | account | access_code |
+--------------+------------------+--------------+---------------+----------+-------------+
| | | Nancy | qwerty | 48572998 | 11966552 |
+--------------+------------------+--------------+---------------+----------+-------------+

mysql> use test_db;
Database changed
mysql> desc authorised_users;
+---------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| user_name | varchar(35) | YES | | NULL | |
| company | varchar(50) | YES | | NULL | |
| user_id | varchar(16) | NO | PRI | | |
| user_password | varchar(16) | NO | PRI | |
| account | varchar(8) | NO | PRI | | |
| access_code | varchar(8) | YES | | NULL | |
+---------------+-------------+------+-----+---------+-------+
6 rows in set (0.58 sec)

mysql> select access_code from authorised_users where user_id = 'Nancy' and user_password = 'qwerty' and account = '48572998';
+-------------+
| access_code |
+-------------+
| 11966552 |
+-------------+
1 row in set (0.19 sec)

mysql>
===============================================
and this (using PHP & MySQL) does not work

/* EXECUTE DATABASE SEARCH */
$sql = "SELECT access_code into $access_code
FROM authorised_users
WHERE user_id = '$userid'
AND user_password = '$password'
AND account = '$account'";
/* TESTING CHECKPOINT */
echo ("conn = " . $conn . "
");
echo ("sql = " . $sql . "
");
echo ("access = " . $access_code . "
");

#execute the query
$rs = mysql_query( $sql, $conn )
or die( "Could not execute query" );
#get number of rows that match username and password
$num = mysql_numrows( $rs );

#if there is a match the log-in is authenticated

if( $num != 0 )
{
echo ( "Welcome - your log-in succeeded!" . "
");
//$access_code = access_code;
echo ("testcheckpoint - accesscode = " . access_code . "
");

echo ('testcheckpoint - $accesscode = ' . $access_code . "
");
}
else
{
/* INVALID USER - RETURN TO OUTERGUARD */

echo (" test checkpoint statement 55 " . "
");
header( "Location:$referer" ); exit();
}
========================================
This is what was returned ..............

user id = Nancy
password = qwerty
account = 48572998
self = /tp_orth.php
conn = Resource id #2
sql = SELECT access_code FROM authorised_users WHERE user_id = 'Nancy' AND user_password = 'qwerty' AND account = '48572998'

access = 0
Could not execute query