ERROR !!Warning: mysql_result()

[avo]

Hi all


as anyone any ideas on this one please i keep getting this error

Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 4

the code is

[code]<?
include_once('dbconfig.php');

    mysql_connect($dbhost, $dbuser, $dbpass) or die ( mysql_error() );
    mysql_select_db($dbname) or die ( mysql_error() );
$query = "SELECT image, image_type FROM left_panel_image WHERE pid = '". $pid ."'";
$result = mysql_query ($query) or die ( mysql_error() );

$data = mysql_result($result,0,"image") or die ( mysql_error() );
$type = mysql_result($result,0,"image_type") or die ( mysql_error() );


header('Content-type: ' . $type);
echo $data;



?>[/code]

thanks in advance.

[Randy]

Hmm... "Unable to jump to row 0" means that no data in the table fits this criteria: "WHERE pid = '$pid'", or just that there is nothing in the table