Zikula Community

• techbetas
  
  

  • Rank: Freshman
  • Registered: 15.06.04
  • last visit: 30.07.04
  • Posts: 9

  Posted: 15.06.2004, 22:26

  I have installed a redirect script "goredirect" that changes outboud urls like
  
  www.amazon.com
  to
  www.techrebate.com/go.php?id=34
  
  It installed fine, but once I click on my newly made links in postnuke, it has an error like this:
  
  

  Code

  Warning: mysql_free_result(): supplied argument is not a valid mysql result resource in /home/techreba/public_html/go.php on line 77
  
  Warning: mysql_close(): supplied argument is not a valid MySQL-link resource in /home/techreba/public_html/go.php on line 78

  
  
  So... naturally I went back into the script go.php, which looks like this:
  
  

  Code

  /********************************************
  data capture section - server variables
  *********************************************/
  $linkid=$_GET['id'];
  $visitorip= $_SERVER['REMOTE_ADDR'];
  $visitorurl= $_SERVER['HTTP_REFERER'];
  $visitorbrowser= $_SERVER['HTTP_USER_AGENT'];
  $visitorpage=$_SERVER['REQUEST_URI'];
  
  /********************************************
  upload the data into the database
  *********************************************/
  $insertquery="INSERT INTO stats (ip,url,browser,date,page,linkid,sitecode) VALUES ('$visitorip','$visitorurl','$visitorbrowser',NOW(),'$visitorpage',$linkid,'$sitecode')";
  // echo $insertquery;
  $result=mysql_query($insertquery) or die(mysql_error());
  
  /********************************************
  redirect the user
  *********************************************/
  $sqlredir="SELECT * FROM redirs WHERE id=$linkid";
  $rdresult=mysql_query($sqlredir) or die(mysql_error());
  $row=mysql_fetch_assoc($rdresult) or die(mysql_error());
  $rdurl="Location: ".$row['redirect'];
  header($rdurl);
  
  /********************************************
  shut down the SQL connection and flush
  *********************************************/
  mysql_free_result($rdresult);
  mysql_free_result($result);
  $goodbye=mysql_close($conn);

  
  
  The lines 77 and 78 are the last 2 lines of the code
  
  

  Code

  mysql_free_result($result);
  $goodbye=mysql_close($conn);

  
  
  Any body have any ideas? Thanks for your time
  Glen

  • 
  •  
• St.Ego
  
  

  • Rank: Softmore
  • Registered: 31.12.69
  • last visit: 27.06.09
  • Posts: 64

  Posted: 16.06.2004, 07:32

  I would say that those two mysql functions are not working because you are missing "a valid MySQL result resource"...
  
  Your connection is failing, check your logon/pass/dbname/etc.

  • 
  •  
• techbetas
  
  

  • Rank: Freshman
  • Registered: 15.06.04
  • last visit: 30.07.04
  • Posts: 9

  Posted: 16.06.2004, 08:29

  St.Ego

  I would say that those two mysql functions are not working because you are missing "a valid MySQL result resource"...
  
  Your connection is failing, check your logon/pass/dbname/etc.

  I already checked the connections and everything.... it's not that. I am a psuedo-noob with scripts, and I don't really know much. Thanks for the help Sgt. Ego. Any more suggestions would still be great :)

  • 
  •  
•  
•  

Users online

• Simon,
• jmvedrine,
• shyra

This list is based on the users active over the last 60 minutes.