PHP - Notice: Undefined Offset Error - No Idea Why Its Happening...

hello all, i am stuck with a problem and hoping someone can help me.
i have got the following code to sort of work.
the problem i am having is when i put e.g. index.php?page=test and there is no information with test under page in the sqlite db i get this message, Notice: Undefined offset: 0 in C:\xampp\htdocs\test\Frontend\left.php on line 8.
as soon as i type index.php?page=test2 and i have test2 in the database the error is gone and shows the content
heres the code
Code: [Select]

        if (isset($_GET['page']))
        {
$page = $_GET['page'];

// Display Page.
$query = "SELECT body FROM content WHERE page = '$page' AND location = 'left' AND disabled = 'no' ORDER BY id";
$results = $base->arrayQuery($query, SQLITE_ASSOC);
$arr = $results[0];

echo '<div id="left">';
                echo '<p>' . $arr['body'] . '</p>';
echo '</div>';

}
        else
        {
                //Show Home Page
$query = "SELECT body FROM content WHERE page = 'home' AND location = 'left' AND disabled = 'no' ORDER BY id";
$results = $base->arrayQuery($query, SQLITE_ASSOC);
$arr = $results[0];

echo '<div id="left">';
                echo '<p>' . $arr['body'] . '</p>';
echo '</div>';   
               
} hope you understand what i am trying to say, thanks very much all.
 

Here is an example of the beginning of a rating system script:

Code: [Select]
// RATING SYSTEM - START

if ((isset($array[0]) || isset($array[1])) && isset($_SESSION['user_id'])) {

// check to see if user has already voted on given contribution
$query = "SELECT * FROM votes WHERE con_id = '$array[2]' AND user_id = '$array[3]'";
$query_run = mysqli_query ($dbc, $query) or die (mysqli_error($dbc));
$num_rows = mysqli_num_rows ($query_run);
$assoc = mysqli_fetch_assoc ($query_run);
$rating = $assoc['rating'];


// check to see if it's user's own contribution
$query = "SELECT * FROM con WHERE con_id = '$array[2]'";
$query_run = mysqli_query ($dbc, $query) or die (mysqli_error ($dbc));
$assoc = mysqli_fetch_assoc ($query_run);
$con_user_id = $assoc['user_id'];

For every array variable I am getting the error message "Undefined Offset".

Any ideas how to solve this one, I do not fully know yet what is common practice in these cases. The warnings also do not always happen, they usually happen, they happen in a specific moment when I use a drop down menu, to show table content.

i get the error for this code:

 <?php
                $news = fopen("test.txt", "rb");

                while (!feof($news) ) {

                        $line = fgets($news);
                        $parts = explode('=', $line);

                print $parts[0] . $parts[1]. "<BR>";//line 60!!!
               
        }

        fclose($news);

           ?>

i know that this means that the array gets one argument instead of two but i do'nt know how to solve it...
this code works fine in my localhost but not on the server

the array is getting the values as he should get and from there i send them to $temp (string),but when i'm trying to print them i can't.

the array and the string at the end of code saved the values that the code gave them,but i can print the values one by one, but i need the values in string and the array at the end and print $temp(string) in a row without white space. print_r is working but she's not build to this job 

can someone look at the code and the result of the code and tell me what seem to be the problem and how to fix that?
the problem start with $txt when the array is getting the values.
the output of this code:http://pastebin.com/0QkzjviW
the code page is attach to this message as php file.

hi,
I need help really badly for my PHP-Postcard Script. Basically it sends the card out but the URL does not work, I get the following error message:

The URL is not valid and cannot be loaded

It also states that
Notice: Undefined index: www.voluntary.awardspace.co.uk in /home/www/voluntary.awardspace.co.uk/Postcard.php on line 25
Notice: Undefined index: Postcard.php in /home/www/voluntary.awardspace.co.uk/Postcard.php on line 25

See Code below:

<?php

session_start();
//check error log
ini_set('display_errors', 1);
ini_set('log_errors', 1);
ini_set('error_log', dirname(__FILE__) . '/error_log.txt');
error_reporting(E_ALL);

// CHANGE PARAMETERS HERE BEGIN
$senderName  = " Holidays From Home "; // Eg.: John's Postcards
$senderEmail = "chris01@voluntary.awardspace.co.uk";  // Eg.: john@postcard.com
// Change only if you have problems with urls
$postcardURL = "http://".$_SERVER["www.voluntary.awardspace.co.uk"].$_SERVER["Postcard.php"];
// CHANGE PARAMETERS HERE END
$result = 0;
$msg = "";
$msg1 = "";
$pic = "";
function displayPhotos()
{
 global $pic;
 $columns = 5;
 $act = 0;
 $act1 = 0;
 // Open the actual directory
 if($handle = opendir("thumbs"))
 {
  // Read all file from the actual directory
  while($file = readdir($handle))
  {
   if(!is_dir($file))
   {
    if(isset($pic[1]))
    {
     if($pic[1] == $act1){$sel = "checked";}
     else{$sel = "unchecked";}
     }
    if($act == 0){echo "<tr>";}
    echo "<td align='center'><img src='thumbs/$file' alt='postcard'/><br/><input type='radio' name='selimg' value='$file,$act1' $sel/></td>";
    $act++;
    $act1++;
    if($act == $columns){$act = 0;echo "</tr>";}

       }
    }
  echo "</tr>";
  }    
 }
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "DTD/xhtml1-transitional.dtd">
<html>
<head>
 <title>Micro Postcard</title>
 <link href= "style/style.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="main">
<div class="style1" id="caption">
<div align="left" class="style1"></div>
</div>
   <?php //makes sure form is correctly filled in 
 if(!empty($_POST["submit"]))
 {
  if(empty($_POST["selimg"])){$msg = "Please select an image from above!";$result = 3;}
  else{$pic = explode(",",$_POST["selimg"]);}
  if(empty($_POST["email"]) && empty($result)){$msg1 = "You must enter an email address!";$result = 3;}
  $secCode = empty($_POST["secCode"]) ? "" : strtolower($_POST["secCode"]);
  if($secCode == $_SESSION["securityCode"] && $result != 3)
  {
   $filename = date("YmdGis");
   $f = fopen("messages/".$filename.".txt","w+");
   fwrite($f,$pic[0]."\n");
   fwrite($f,$_POST['email']."\n");
   fwrite($f,stripslashes($_POST["message"])."\n");
   fclose($f);
   // Compose the mail
   $from = "From: $senderName <$senderEmail>\r\n";
   $replay = "Reply-To: $senderEmail\r\n";    
   $params = "MIME-Version: 1.0\r\n";
   $params .= "Content-type: text/plain; charset=iso-8859-1\r\n";
   $mailtext = "You have just received a Virtual Postcard!\r\n\r\n
                You can pick up your postcard at the following web address:\r\n
                $postcardURL?show=$filename\r\n\r\n
                We hope you enjoy your postcard, and if you do, please take a moment to send a few yourself!\r\n\r\n
                Regards,\r\n
                Holidays From Home\r\n
                $postcardURL";
   // Send email
   @mail($_POST["email"],"You've received a postcard",$mailtext,$from.$replay.$params);
   echo "<center>
          Your postcard was sent successfully!<br /><br />
          <img src='images/$pic[0]' alt='postcard' /><br /><br /><br />".stripslashes($_POST["message"]).
        "</center>";
   $result = 1;
   }
  else{if($result != 3){$result = 2;}}
  }
 if(!empty($_GET["show"]))
 {
  $file = $_GET["show"];
  $content = file("messages/$file.txt");
  $pic = $content[0];
  unset($content[0]);
  unset($content[1]);
  foreach($content as $value){$main .= $value;}
  echo "<center>
         Your postcard!<br /><br />
         <img src='images/$pic' alt='postcard' /><br /><br /><br />$main
        </center>";
  }
 if((empty($result) || $result == 2 || $result == 3) && empty($_GET["show"]))
 {
  echo "<form action='#' method='post'>
         <table align='center'>";
         displayPhotos();
  echo  "</table>
         <div style='color:#f00;font-size:16px;'>$msg</div>        
         <h2>Fill in the Form and then click on Send Card!!</h2>
         <table width='100%'>
          <tr><td>Send to (email address):</td><td><div style='color:#f00;font-size:16px;'>$msg1</div><input type='text' name='email' size='30' value='".$_POST["email"]."' /></td></tr>
          <tr><td>Message:</td><td><textarea name='message' rows='10' cols='40'>".stripslashes($_POST["message"])."</textarea></td></tr>
          <tr><td colspan='2'>".($result == 2 ? "<p style='color:#f00;font-size:16px;'>Sorry the security code is invalid! Please try it again!</span></p>" : "&nbsp;")."</tr>
          <tr>
           <td>Security code: <input class='text' name='secCode' type='text' size='10' />
           </td><td><img src='securityCode.php' alt='security code' border='1' /></td>
          </tr>
          <tr><td colspan='2'>&nbsp;</tr>
          <tr><td colspan='2' align='left'><input type='submit' value='Send card!' name='submit'/></td></tr>
         </table>
        </form>";
  }
?>

Absolutely any help would be much appreciated. I want ot know is there a way round this problem?

Here is the http://voluntary.awardspace.co.uk/Postcard.php

I am absolutely desperate to solve this burning issue 

Hi everyone... please help me with this. I have a gallery that I am working on. Part of that are two files upload.php and preupload.php which upload pics. And it does its job successfully BUT it shows an error 'Notice: Undefined offset: 9 in C:\wamp\www\upload.php on line 34' My line 34 is  Code: [Select]
if($photos_uploaded['size'][$counter] > 0). My whole code for the upload.php is

<?php
    include("config.inc.php");
 
    // initialization
    $result_final = "";
    $counter = 0;

// List of our known photo types
    $known_photo_types = array(
                        'image/pjpeg' => 'jpg',
                        'image/jpeg' => 'jpg',
                        'image/gif' => 'gif',
                        'image/bmp' => 'bmp',
                        'image/x-png' => 'png'
                    );
   
// GD Function List
    $gd_function_suffix = array(
                        'image/pjpeg' => 'JPEG',
                        'image/jpeg' => 'JPEG',
                        'image/gif' => 'GIF',
                        'image/bmp' => 'WBMP',
                        'image/x-png' => 'PNG'
                    );
 
// Fetch the photo array sent by preupload.php
    $photos_uploaded = $_FILES['photo_filename'];
 
// Fetch the photo caption array
    $photo_caption = $_POST['photo_caption'];

    while( $counter <= count($_FILES['photo_filename']['tmp_name']) ) 
{
        if($photos_uploaded['size'][$counter] > 0)
        {
            if(!array_key_exists($photos_uploaded['type'][$counter], $known_photo_types))
            {
                $result_final .= "File ".($counter+1)." is not a photo<br />";
            }
            else
            {
                mysql_query(
                    "INSERT INTO
                        gallery_photos(
                    `photo_filename`,
                    `photo_caption`,
                    `photo_category`
                    ) VALUES(
                        '0',
                        '".addslashes($photo_caption[$counter])."',
                        '".addslashes($_POST['category'])."')"
                    ) or die(mysql_error() . 'Photo not uploaded');
                   
                $new_id = mysql_insert_id();
                $filetype = $photos_uploaded['type'][$counter];
                $extention = $known_photo_types[$filetype];
                $filename = $new_id.".".$extention;
 
                mysql_query( "UPDATE gallery_photos SET photo_filename='".addslashes($filename)."' WHERE photo_id='".addslashes($new_id)."'" );
 
                // Store the orignal file
                copy($photos_uploaded['tmp_name'][$counter], $images_dir."/".$filename);
 
                // Let's get the Thumbnail size
                $size = GetImageSize( $images_dir."/".$filename );
                if($size[0] > $size[1])
                {
                    $thumbnail_width = 200;
                    $thumbnail_height = (int)(200 * $size[1] / $size[0]);
                }
                else
                {
                    $thumbnail_width = (int)(200 * $size[0] / $size[1]);
                    $thumbnail_height = 200;
                }
           
                // Build Thumbnail with GD 1.x.x, you can use the other described methods too
                $function_suffix = $gd_function_suffix[$filetype];
                $function_to_read = "ImageCreateFrom".$function_suffix;
                $function_to_write = "Image".$function_suffix;
 
                // Read the source file
                $source_handle = $function_to_read ( $images_dir."/".$filename );
               
                if($source_handle)
                {
                    // Let's create an blank image for the thumbnail
                        $destination_handle = ImageCreateTrueColor ( $thumbnail_width, $thumbnail_height );
               
                    // Now we resize it
                    ImageCopyResized( $destination_handle, $source_handle, 0, 0, 0, 0, $thumbnail_width, $thumbnail_height, $size[0], $size[1] );
                }
 
                // Let's save the thumbnail
                $function_to_write( $destination_handle, $images_dir."/tb_".$filename, 99 );
                ImageDestroy($destination_handle );
                //
 
                $result_final .= "<img src='".$images_dir. "/tb_".$filename."' /> File ".($counter+1)." Added<br />";
            }
        }
    $counter++;
    }
 
    // Print Result
echo <<<__HTML_END
 
<html>
<head>
    <title>Photos uploaded</title>
</head>
<body>
    $result_final
</body>
</html>
 
__HTML_END;
?>

I get an undefined offset error when i try and call the array i made i know very little so I'm stuck and i don't know what to do
Code: [Select]
<?php
$file = fopen("playerstats.csv","r");

$data = array();
while (($csv_line = fgetcsv($file, 0, ";")) !== FALSE) {
  echo $csv_line;
    $number = $csv_line[0];
$name = $csv_line[1];
    $half = $csv_line[2];
$goals = $csv_line[3];
$assists = $csv_line[4];
$SOG = $csv_line[5];
$shots = $csv_line[6];
$fouls = $csv_line[7];
$yellow = $csv_line[8];
$yellowred = $csv_line[9];
$red = $csv_line[10];
$CK = $csv_line[11];
$saves = $csv_line[12];
    $data[] = array(
        'name' => $name,
        'half' => $half,
'goals' => $goals,
'assists' => $assists,
'sog' => $SOG, 
'shots' => $shots,
'fouls' => $fouls,
'yellow' => $yellow,
'yellowred' => $yellowred,
'red' => $red,
'ck' => $CK,
'saves' => $saves
    );
}

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<table><tr><td>Number: </td><td><?php echo $data[0];?></td></tr></table>
</body>
</html>

im getting Undefined offset: 0 in many line what can be the issue?

Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><!-- <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> -->
<title>Untitled Document</title>
</head>
<body>
<?php
if(isset($_POST['submit']))
{
$userquery = $_POST['userquery'];
$xml = simplexml_load_file("http://www.google.com/ig/api?weather='".$userquery."'");
$information = $xml->xpath("/xml_api_reply/weather/forecast_information");
$current = $xml->xpath("/xml_api_reply/weather/current_conditions");
$forecast_list = $xml->xpath("/xml_api_reply/weather/forecast_conditions");
        echo "<h1>".$information[0]->city['data'].", ".$information[0]->forecast_date['data']."</h1>";
        echo "<h2>Current Contition</h2>";
        echo "<div class=\"weather\">";
echo "<table width='250' border='1'>";
        echo "<tr>";
        echo "<td><img src='http://www.google.com".$current[0]->icon['data']."' width='70' height='70' alt='weather'></td>";
        echo "<td>";
    echo $current[0]->condition['data'];
        echo "<br/>Min ";
        echo $current[0]->temp_c['data']."&deg; C, <br/>";
        echo $current[0]->temp_f['data']."&deg; F, <br/>";
        echo $current[0]->humidity['data'].", <br/>";
        echo $current[0]->wind_condition['data']."."; 
    echo "</td>";
        echo "</tr>";
        echo "</table>";
echo "</span>";
        echo "</div>";

        echo "<h2>Forecast</h2>";
        foreach ($forecast_list as $forecast) :
        echo "<div class=\"weather\">";
echo "<table width='250' border='1'>";
        echo "<tr>";
echo "<td>";
echo "<img src='http://www.google.com".$forecast->icon['data']."' width='50' height='50'alt='weather'>";
echo "</td>";
echo "<td>";
echo "<div>".$forecast->day_of_week['data']."</div>";
        echo "<span class=\"condition\">";
        echo $forecast->low['data']."&deg; F - ".$forecast->high['data']."&deg; F,<br/>";
        echo $forecast->condition['data'].".";
echo "</td>";
echo "</tr>";
echo "</table>";
        echo "</span>";
        echo "</div>";
endforeach;
}
?>       
<form action="test.php" method="post">
<input name="userquery" type="text" value=""/>
<input type="submit" name='submit' value="get"/>
</form>
</body>
</html>

here all errors and there are few more

Notice: Undefined offset: 0 in C:\wamp\www\fiunc\test.php on line 16

Notice: Trying to get property of non-object in C:\wamp\www\fiunc\test.php on line 16

Notice: Undefined offset: 0 in C:\wamp\www\fiunc\test.php on line 16

Notice: Trying to get property of non-object in C:\wamp\www\fiunc\test.php on line 16
,

it happens when i add

if(isset($_POST['submit']))
{
$userquery = $_POST['userquery'];

and this in '".$userquery."'

$xml = simplexml_load_file("http://www.google.com/ig/api?weather='".$userquery."'");

What I am trying to do is to associate a user (id) to a page they create, so if joe blogs is user 4, then the data base will show the page details, and add the id (from a user page).  However, when I try the code  to save data I get the following error messages:

Notice: Undefined offset: 4 in C:\xampp\htdocs\MyCMS\admin\index.php on line 98
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 'Thom\'s page', 'testing Tom', 'Tom')' at line 1

I include the code to insert the page:

<!-- Insert Page -->
				<?php  
					if(isset($_POST['submitted']) == 1) {
										
					$header = stripslashes($_REQUEST['header']);
					
					$header = mysqli_real_escape_string($dbc, $header);

					$title = stripslashes($_REQUEST['title']); 
										
					$title = mysqli_real_escape_string($dbc, $title);  
					
					$body = stripslashes($_REQUEST['body']);
					
					$body = mysqli_real_escape_string($dbc, $body);
					
					$userid = stripslashes($_REQUEST['userid']);
					
					$userid = mysqli_real_escape_string($dbc, $userid);
					
					
					$q = "INSERT INTO `pages` (`userid`, `header`, `title`, `body`) VALUES ($_POST[$userid], '$header', '$title', '$body')";
					
					$r = mysqli_query($dbc, $q) or die(mysqli_error($dbc));
					
						if($r) {
						
						$message = '<p>Page was added.</p>';
						
						} else {
						
							$message = '<p>Page could not be added due to: </p>'.mysqli_error($dbc);						
							$message .= '<p>'.$q.'</p>';
							} // end if inner
					
					} // end if outer
					
				?>

The form has - Page Header, Page Title, User, and boys.  There is a working list of current users.  It is these users (and new users) that I want to add to a 'Pages' database, which has the following fields:  id, userid, header, title, body; and a 'User' database with the following fields: id, firstname, lastname, username, password, status.

Any help to solve the issues will be appreciated.

Thanks.

 

 

Help me solve in error

Notice: Undefined index: ch1 in C:\wamp\www\latest\library\bookdb.php on line 3

It comes when i uncheck any checkbox

Thank U in advance

Hello i am new to this forum and coding. I am trying to fix a auto torrent downloading script which is php and curl.

I have been stucked with Undefined offset error. Your help will be very appretiated, thanks.


Starting download: Mp3-data1
Notice: Undefined variable: temp in /var/www/html/torrents/bgrahul2.php on line 338
Array ( => HTTP/1.1 200 OK Server: Transmission Content-Type: application/json; charset=UTF-8 Date: Wed, 21 Sep 2011 19:58:44 GMT Content-Length: 49 {"arguments":{"torrents":[]},"result":"success"} [1] => ) Marked those lines to bold

Quote

$result = callTransmission(array("filename" => "/var/www/html/donofwarez/xxx/torrents/$torrentfile", "download-dir" => "/home/Downloads/$title/"), "torrent-add", $arr[1]);
                callTransmission(array("seedRatioLimit" => 50, "seedRatioMode" => 1), "torrent-set", $arr[1]);
/*
echo "<pre>";
print_r($result);
echo "</pre>";
*/
                if (preg_match('/"percentDone":[0-9.]+/i', $result[0], $matches))
                $temp = str_replace('"id":', "", $matches[0]);
                //      $temp="hlDr1wqu2ONtM3McVGHoVzfrkp2UgUcGwDt66IuxAe0LBkru";
                $id[0] = $temp;
//***OMG! We need the ids as integers! ***
                foreach ($id as $key => $value) {
                    $id[$key] = (int) $value;
                }

Notice: Undefined index: username in C:\wamp\www\LogInSystem\login.php on line 2
Notice: Undefined index: password in C:\wamp\www\LogInSystem\login.php on line 3

Help me to change this error

Code: [Select]
<?php
$username = $_POST['username'];     ERROR IS IN THIS LINE
$password = $_POST['password'];      ERROR IS IN THIS LINE

if ($username&&$password){

$connect = mysql_connect ("localhost", "root","") or die ("could not connect");

mysql_select_db ("login") or die ("could not find db");

} else { die ("Please enter username and password!");}
?>

I'm getting an error: Undefined offset: 1 in… I'm trying to display a 2D array after filling it. It displays fine if I echo it while it's being made, but after it is not working.   I'm making a pyramid solitaire game and am trying to set up the pyramid of cards. There are 7 arrays, each with a set amount of cards in them. The first array only gets one cards while the last array gets seven. This makes it like a pyramid. All the indexes that don't get a card are set to 0. So it looks like this where the 1's are cards:   1 0 0 0 0 0 0 0 ​1 1 0 0 0 0 0 0 ​1 1 1 0 0 0 0 0 1 1 1 1 0 0 0 0 1 1 1 1 1 0 0 0 1 1 1 1 1 1 0 0 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1   The display2Darray function is what is causing the error. Specifically this line:

if($array[$i][$j] == 0) 

Heres my main code:

<?php
    include_once "pyramidCard.php";
    include_once "pyramidDeck.php";
    
    $theDeck = new Deck();
    $pyramid = array(array(), array(), array(), array(), array(), array(), array());
    $size = 7;

    $theDeck->shuffleCards();
    
    makePyramid($pyramid, $size, $theDeck);
    display2Darray($pyramid, $size);
    
    
    //************************
    //      FRUNCTIONS       *
    //************************
    
    function makePyramid($array, $size, $deck)
    {
        $row = 0;
        for($i = 0; $i < $size; $i++)
        {
            for($j = 0; $j < $size; $j++)
            {
                if($j > $row)
                {
                    $array[$i][$j] = 0;
                    //echo ". <br>";
                }                    
                else
                {
                    $array[$i][$j] = $deck->dealCards();
                    //echo "this card is ".$array[$i][$j]->getFace()." of ".$array[$i][$j]->getSuit()."<br>";
                }
            }
            $row++;
        }
    }
    
    
    function display2Darray($array, $size)
    {
       for($i = 0; $i < $size; $i++)
    {
        for($j = 0; $j < $size; $j++)
        {
            if($array[$i][$j] == 0)
                echo "  ";
            else
                echo $array[$i][$j]->getFace()." of ".$array[$i][$j]->getSuit();
        }
        echo "<br>";
    } 
    }
?>

     

Hi   I'm having a strange error with this code and i get it working properly

 function CheckLoginInDB($username,$password)
    {
        if(!$this->DBLogin())
        {
            $this->HandleError("Erro na ligação à Base de Dados!");
            return false;
        }
		
        $username = $this->SanitizeForSQL($username);
		$nresult = mysql_query("SELECT * FROM utilizador WHERE utilizador = '$username'", $this->connection) or die(mysql_error());
        // check for result 
        $no_of_rows = mysql_num_rows($nresult);
        if ($no_of_rows > 0) {
            $nresult = mysql_fetch_array($nresult);
            $salt = $nresult['salt'];
			echo $salt;
            $encrypted_password = $nresult['password'];
			$hash = $this->checkhashSSHA($salt, $password);
			echo $hash;
        }
        $qry = "Select idutilizador, nome, email from utilizador where utilizador='$username' and password='$hash'";
        $result = mysql_query($qry,$this->connection);
        if(!$result || mysql_num_rows($result) <= 0)
        {
            $this->HandleError("Erro: Utilizador ou password errados");
            return false;
        }    
        $row = mysql_fetch_assoc($result);
		$_SESSION['idutilizador']  = $row['idutilizador'];
        $_SESSION['name_of_user']  = $row['nome'];
        $_SESSION['email_of_user'] = $row['email'];
		
        return true;
    }

This is my table   Field                                          Type         Collation          Null    Key     Default  Extra           Privileges                       Comment