Notice: Undefined index: login in C:\phpweb\CR\login.php on line 57

[gilmourt]

Hi Guys,

Im trying to get a login screen to appear for my application and I keep getting this message,

Notice: Undefined index: login in C:\phpweb\CR\login.php on line 57

Line 57 onwards is ...
if ($GET["login"])
{
$sql_user_info_query=mysql_query("SELECT users.*, teams.title AS team, company.title AS company, company.url AS company_url, item_types.type AS default_item_type_text,
DAYOFMONTH(users.last_login) AS last_login_day, MONTH(users.last_login) AS last_login_month, YEAR(users.last_login) AS last_login_year, HOUR(users.last_login) AS last_login_hour, MINUTE(users.last_login) AS last_login_minute, SECOND(users.last_login) AS last_login_second
FROM users
LEFT JOIN teams ON users.team_ID=teams.ID
LEFT JOIN company ON users.company_ID=company.ID
LEFT JOIN item_types ON users.default_item_type_ID=item_types.ID
WHERE username='".$POST["username"]."'");

Any ideas?

[bad76]

$GET["login"])
...
$POST["username"]

Hi,
look for existence of username and login variable.
May be one of this don't exist.

see you

[gilmourt]

Hey excuse my total ignorance, but where should i be looking for the first instance of username and login? Ive only just started using php yesterday.
Attached is the whole php file

Help, anyone?

[bad76]

The "Undefined index" error
tell us that we have tried to access any array at an unexisting index.

An example:

$myarr[0]="hi";
$myarr[1]="this";
$myarr[2]="me";

echo $myarr[3];

this will give you "Undefined index" error

In your code at line you submit there are only two array:
$GET and $POST. May be youìre trying to acces at unexisting variable...