php query crashes when retrieving results

Question

When I execute this query the code crashes at line ' $row2 = mysql_fetch_array($result2) ' Can someone please help me tell what is wrong in this.

$query2 = " SELECT time, MAX(id) FROM i_friend WHERE (user_id=$uid AND friend_id=$fid) OR (user_id=$fid AND friend_id=$uid) ";

                    $result2 = mysql_query($query2);

                    if($result2)
                    {
                             if (mysql_num_rows($result2) > 0) {
                                $row2 = mysql_fetch_array($result2) 
                                 detail["last_chat_time"] = $row2[$id];
                             } else {
                                 $detail["last_chat_time"] = "";
                             }
                    }

maybe a typo? `$row2 = mysql_fetch_array($result2) `, missing `;` `detail["last_chat_time"] = $row2[$id];` missing `$` — Kevin, Sep 14 '14 at 12:36
Please read this question: http://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php your code is obsolete. — AntoineB, Dec 27 '16 at 08:52

score 0 · Answer 1 · answered Dec 27 '16 at 09:03

0

Correct this 2 lines

 $row2 = mysql_fetch_array($result2);
 $detail["last_chat_time"] = $row2[$id];

answered Dec 27 '16 at 09:03

Amruth

5,466
2
23
39

php query crashes when retrieving results

1 Answers1