PHP error

Discussion in 'PHP' started by Buyer1seller, Jul 20, 2009.

  1. #1
    I am running site like watchmedia.net

    At comments area I facing this problem


    Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 50 in /home/quick/public_html/watchmedia.net/inc/mysql.class.php on line 33

    Please this there anyone to help me ?
     
    Buyer1seller, Jul 20, 2009 IP
  2. ractors

    ractors Well-Known Member

    Messages:
    1,979
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    140
    #2
    where u getting this error ?

    i fly around ur site and i didn't find any errors.

    Only lots of popup with clickser.
     
    ractors, Jul 21, 2009 IP
  3. Buyer1seller

    Buyer1seller Peon

    Messages:
    23
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    http://watchmedia.net/newcomments.html look at here its showing error
     
    Buyer1seller, Jul 21, 2009 IP
  4. ractors

    ractors Well-Known Member

    Messages:
    1,979
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    140
    #4
    check this line public_html/watchmedia.net/inc/mysql.class.php on line 33

    what is that line ?

    that is sql problem . Code not pulling data from sql.
     
    ractors, Jul 21, 2009 IP
  5. Buyer1seller

    Buyer1seller Peon

    Messages:
    23
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    I didn't know but I am having that problem :(
     
    Buyer1seller, Jul 21, 2009 IP
  6. Buyer1seller

    Buyer1seller Peon

    Messages:
    23
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    function result($query,$num = 0)
    {
    $query = mysql_result($query,$num);
    return $query;


    here is that code on line 33
     
    Buyer1seller, Jul 21, 2009 IP
  7. ractors

    ractors Well-Known Member

    Messages:
    1,979
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    140
    #7
    change

    to this

    function result($query,$num = 1)
    {
    $query = mysql_result($query,$num);
    return $query;

    if not solved then i need to check ur database

    thx
     
    ractors, Jul 21, 2009 IP
  8. mioot

    mioot Peon

    Messages:
    169
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #8
    you put @mysql_result($query,$num); it prevent from showing the warning.
     
    mioot, Jul 21, 2009 IP
  9. Martinoes

    Martinoes Peon

    Messages:
    110
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #9
    mysql_result() will throw E_WARNING if mysql_query returns 0 rows, you must check if your query returns any data:

    mysql_num_rows($result)==0
     
    Martinoes, Jul 21, 2009 IP
  10. Buyer1seller

    Buyer1seller Peon

    Messages:
    23
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #10
    :( no still showing error :(
     
    Buyer1seller, Jul 21, 2009 IP
  11. Martinoes

    Martinoes Peon

    Messages:
    110
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #11
    Write your SQL query and part of code that you are using when invoking result function.
     
    Martinoes, Jul 21, 2009 IP