Jump to content

Archived

This topic is now archived and is closed to further replies.

avo

ERROR !!Warning: mysql_result()

Recommended Posts

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.

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.