mysql php error message

[cyberfruits]

Help

 

Hopefully someone can help

 

I am not sure whether this is a PHP or MySQL error

 

We recently had to change paypal accounts and changed the relevant data like paypal email and security token in our script. The script was written by a third party no longer with us and we are very inexperienced with this sort of thing, but we did not change anything but the email address and security token as by paypals instructions in our php pages. We were very careful not to change anything else even by accident and kept back up copies. We are not sure whether we had to change anything in Mysql but did not think so. So hopefully someone may be able to shed light on what could have gone wrong so that we can look in the right place, e.g. did we need to have to change something in mysql? This is the error message that we get.

 

Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 5 in /home/comp/public_html/paypal/functions.php on line 222

Server Error - please try later

 

Thank you very much in anticipation for your help.

 

[rhodesa]

Can you paste some of the code from that file?

[cyberfruits]

this copy of the code from that area

 

Get user details from mysql

//*************************************************

function GetUserInfo($username,$column)

{

        global $conn;

 

        $sql_full = "SELECT $column FROM `members` WHERE `username` = '$username'";

        $sql_full_res = mysql_query($sql_full,$conn) or die(mysql_error());

 

line222 $result = mysql_result($sql_full_res,0,$column);

        return($result);

[rhodesa]

That just means it's not finding the username in the members table. Is this not what is supposed to happen? To hide that error, put an @ symbol in front of the function call:

 

$result = @mysql_result($sql_full_res,0,$column);

 

But if the username being passed IS in the members table, then we have other problems.

[cyberfruits]

hi

 

what is suposed to happen is that onother website gets a notification of credits and that part is not happening after we changed paypal email address.this is all to do with that we have got our own members who then use a cam site steanming server for cam conection pay as you go.so sombody registers with us and then can as and when buy time which then gets credited to the cam site with there user name which is the same as on our site.

thanks hope this will help more