Undefined offset: 0

[yosra]

when i try to execute this code i always have a problem . and i can't  get the element i m searching for in the database 

 

//select the CODE from nxcp_code

 

     $sql= "select value from nxcp_code where name = '$name'" ;

     $res=mysql_query($sql); 

      if( !$res ) {throw new Exception(mysql_error(),mysql_errno());}

      $codeArray = mysql_fetch_assoc($res); //This fetch the first row of the result to an array with numeric indexes.

 

 

        if( !$codeArray ){ throw new Exception('Code not found');} //somevhere you should catch it          

     

        $code =$codeArray[0];

 

 

any help please thanks in advance 

[gizmola]

You are using mysql_fetch_assoc.

 

$codeArray = mysql_fetch_assoc($res); 

This returns you an array where the elements are the column names. In your case, it would be 'value'.

 

Try:

 

$code = $codeArray['value'];

[yosra]

thank u very much  that worked