RE: [PHP] "Unable to Jump Row" ?!?

[Jason Murray]

> > Here is the code on line 39
> > 
> > $d = mysql_result($result, $c, "id");
> > 
> > the field "id" is an auto_increment column.
> > $c is an exsisting row in the query, $result.
> >
> > Any help? 
> 
> Yes, it looks like $result doesn't contain anything, so maybe
> your SQL is messed up. 

Oh yes, additionally (this is more for others who may have the
same question, since you seem to have solved yours) the variable
$c may not contain the value you're expecting it to contain.

Jason

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

RE: [PHP] "Unable to Jump Row" ?!?

[Jason Murray]

> Here is the error...
> 
> Warning: Unable to jump to row 1 on MySQL result index 2 in
> /blahblahblah/patient/display_search_results.php on line 39

This means that the query you executed didn't return enough
rows to count up to ... 1.

> Here is the code on line 39
> 
> $d = mysql_result($result, $c, "id");
> 
> the field "id" is an auto_increment column.
> $c is an exsisting row in the query, $result.
>
> Any help? 

Yes, it looks like $result doesn't contain anything, so maybe
your SQL is messed up. When you execute queries, you should
do:

  if ($result = mysql_query($sql, $mysql_connection))
  {
// It worked, proceed
  }
  else
  {
// It didn't work, die.
echo "MySQL failed: ".mysql_error();
  }

... that will tell you what went wrong.

> Is there a way to tell MySQL to shut the hell up on certain
> pages?

Yes, if you put a @ in front of any function call it will 
supress error messages. However, it's a better idea to fix
the cause of the error messages :)

Jason

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP] "Unable to Jump Row" ?!? <-- NEVERMIND

[Phil Schwarzmann]

..I figured it out.

[PHP] "Unable to Jump Row" ?!?

[Phil Schwarzmann]

I keep getting this damn error message from MySQL even though it
displays the correct results.

Here is the error...

Warning: Unable to jump to row 1 on MySQL result index 2 in
/blahblahblah/patient/display_search_results.php on line 39

Here is the code on line 39

$d = mysql_result($result, $c, "id");

the field "id" is an auto_increment column.
$c is an exsisting row in the query, $result.

Any help?  Is there a way to tell MySQL to shut the hell up on certain
pages?

THanks!