Jump to content


Photo

ERROR !!Warning: mysql_result()


  • Please log in to reply
1 reply to this topic

#1 avo

avo
  • Members
  • PipPipPip
  • Advanced Member
  • 148 posts
  • Locationstaffordshire uk

Posted 01 June 2006 - 08:09 PM

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

<?
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;



?>

thanks in advance.
Im loving it ........

#2 Randy

Randy
  • Members
  • PipPip
  • Member
  • 25 posts
  • LocationNewcastle, UK

Posted 01 June 2006 - 10:08 PM

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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users