Databases
StackOverflow2013
Postsdbo
POPHP error . How to fix it?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPHP error . How to fix it?
    text
    copied!<blockquote> <p>Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/a2121694/public_html/cbox/fb_lib/connect.php on line 12</p> <p>Invalid session ID</p> </blockquote> <p>anyone knows hot to fix my error ive been trying this but i cant solve it. lack of knowledge huhu</p> <pre><code>&lt;?php require './fb_connect.php'; include('../config.php'); $fb = new fbConnect(); if(!$fb-&gt;output) { header("Location:".$fb-&gt;getLoginUrl()); } else { $userInfo = $fb-&gt;getUserInfo(); $_SESSION['ses_id'] = md5(microtime()); $user = mysql_query("SELECT * FROM `".DB_PREFIX."user_accounts` WHERE `fbid`='".$userInfo['id']."'"); $buid = $userInfo['id']; if(mysql_num_rows($user)&gt;0) { $userdata = mysql_fetch_assoc($user); if($userdata['last_request_time']&lt;=(time()-10800)) { mysql_query("INSERT INTO `".DB_PREFIX."chats` VALUES('','Hello ! Welcome back to ".GLOBAL_NAME.", &lt;b&gt; ".$userdata['fbname']." &lt;/b&gt;&lt;img src=\'http://l.yimg.com/us.yimg.com/i/mesg/emoticons7/6.gif\'&gt; You\'re Back! :)&lt;br/&gt;&lt;a href=\'http://www.barkadafm.net/view.php?link=http://www.txtmyt.com\' target=\'_blank\'&gt;&lt;img src=\'http://bfm.chatmode.info/images/txtmyt.png\' width=\'480px\' alt=\'Free Unlimited Text to All Networks @ TXTMYT.COM\'/&gt;&lt;/a&gt;','164790013558517','normal','".time()."')"); } mysql_query("UPDATE `".DB_PREFIX."user_accounts` SET `gender` = '".$userInfo['gender']."', `ses_id` = '".$_SESSION['ses_id']."', `active` = '1', `sign_time` = CURRENT_TIMESTAMP, `last_request_time` = '".time()."', `ip_address` = '".$_SERVER['REMOTE_ADDR']."' WHERE `fbid`='".$userInfo['id']."'"); } else { mysql_query("INSERT INTO `".DB_PREFIX."user_accounts` VALUES('', '".$userInfo['id']."', '".$userInfo['name']."', '".$userInfo['gender']."', '0', '".$_SESSION['ses_id']."', '1', CURRENT_TIMESTAMP, '".time()."', '".$_SERVER['REMOTE_ADDR']."','0','0')"); mysql_query("INSERT INTO `".DB_PREFIX."chats` VALUES('','Lets all Welcome,&lt;b&gt; ".$userInfo['name']." &lt;/b&gt;:) Welcome sa BarkadaFM! &lt;img src=\'http://l.yimg.com/us.yimg.com/i/mesg/emoticons7/6.gif\'&gt;&lt;br/&gt;&lt;a href=\'http://www.barkadafm.net/view.php?link=http://www.txtmyt.com\' target=\'_blank\'&gt;&lt;img src=\'http://bfm.chatmode.info/images/txtmyt.png\' width=\'480px\' alt=\'Free Unlimited Text to All Networks @ TXTMYT.COM\'/&gt;&lt;/a&gt;','164790013558517','normal','".time()."')"); } if(isset($_SESSION['ses_id'])) { $getUserInfo = mysql_query("SELECT * FROM `".DB_PREFIX."user_accounts` WHERE `ses_id`='".$_SESSION['ses_id']."'"); if(mysql_num_rows($getUserInfo)&gt;0) { while($data=mysql_fetch_assoc($getUserInfo)) { $_SESSION['fbid'] = $data['fbid']; $_SESSION['name'] = $data['fbname']; $_SESSION['gender'] = $data['gender']; $_SESSION['acctype'] = $data['acctype']; } } else { die("Invalid Session ID"); } ?&gt; &lt;script&gt; window.opener.location.href="../index.php"; self.close(); &lt;/script&gt; &lt;?php } } ?&gt; </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload