help stripping url

[gammaman]

I am trying to strip a url submitted via a form, down to the base address and then insert it into a database.

 

So assuming the url submitted reads www.abc.com/123/456/789/111

 

The url submitted to the database should be www.abc.com

 

 

I am trying to use the explode function to achieve this.  When I echo after doing the explode, the echo contains what I want.  However when I try to write to the database, nothing gets written.

 

 

<?php	
   include("connect.php");

   session_start();
   connect();
   // session_register('link');
   $_SESSION['link'] = explode("/", $_POST['link']);
  
   echo $_SESSION['link'][0];
   
   
   
   
   $insertQuery = "insert into sites(address)values(('".$_SESSION['link'][0]."'))";
   
   mysql_query($insertQuery);
?>

[Pikachu2000]

What does echo mysql_error show you?

[gammaman]

Never mind.  Got it working.  Turns out it was writing to the DB.  On my testing page where the links are displayed is where the problem lied.

[Pikachu2000]

OK. Mark it solved, if that's the case.