> 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]
