[RESOLVED] some error in disaplying whether user is logging or admin is logging

[preet_harman83]

can anyone tell mewhere im wrong i wana get if user login it should display user logged in and if admin login it should disaply admin logged in ...but its displaying nothing who so ever logged in.need r suggestion
database is as follows
uid | username | password | name | type
--------+----------+----------+-------------------+-------
on | man | preet |t singh | user
onto | nio | gdic | onio | admin

<?php
$username = $POST["username"];
$password = $POST["password"];
$connection = pg_connect("dbname=test user=ev host=localhost ") or die("Cannot connect
to server");
$result = pg_query($connection, "select type from ontestusers where username='$username' and password='$password' ") or die("Cannot execute the query");
$no_rows = pg_num_rows( $result ); // if only one row correct username and pwd
if($no_rows == 1)
{ //testing purpose
//echo "In IF NO OF ROWS ".$result['type'];
//echo "In IF NO OF ROWS ".$no_rows;
if ($result['type'] == 'user' )
{
//echo $result['type'];
echo "User";
}
elseif($result['type'] == 'admin' )
{
// echo $result['type'];
echo "ADMIN";
}
}
else
{
echo "Username and pwd wrong...";
}
?>

[preet_harman83]

this is resolved thanks to jayant who helped me in removing the erroor..pasting the right code for ur help friends and can anyone tellme how to opt tht this thread is resolved

<?php

$username = $POST['username'];
$password = $POST['password'];

          $connection = pg_connect("dbname=harmantest user=damdev host=localhost") or die("Can't connect to database server.");
          //echo $connection;

          $query = pg_query("SELECT type FROM onlinetestusers WHERE username='$username' AND password='$password'") or die('Cannot execute the query.');

          $no_rows = pg_num_rows($query);
          //echo $no_rows;
            if ( $no_rows == 1 )
            {
                 $result = pg_fetch_assoc($query);// instead of returning it as $result[0], $result[1]
                 //,it does it as $result['type']

                    if ( $result['type'] == 'user' )
                    {
                       echo ( 'User' );
                    }
                    else if ( $result['type'] == 'admin' )
                    {
                       echo ( 'Admin' );
                    }
                    else
                    {
                        echo ( 'Invalid user type.' );
                    }
            }

         else
            {
                    echo ( 'Username or password was wrong.' );
            }
   ?>