Double inputting

Anon

I have a page which inputs links into a links page. It all runs using php and mysql.

However, recently the page which adds the links (which is linked a template) adds each link twice (with two different ids). When the template is removed then the problem goes away.

Can anyone help?

Thanks in advance,
Gareth

[deleted]

You need to give us more than this...
"I have a database and when I use something it enters data twice"
that's not a lot to go by....

Anon

sorry - what do you want to know?

Thanks - Gareth

[deleted]

Well, codesamples are usually helpfull.

Could it be that the template calls the database insert routines too?

Anon

this is insertlink.php

<?
// set up some variables

// server name
$server = "localhost";

// username
$user = "gareth";

// password
$pass = "";

// database to query
$db = "caravanol";

// open a connection to the database
$connection = mysql_connect($server, $user, $pass) or die("Invalid server or user");

// formulate the SQL query - same as above
$query = "replace into links(url,title,blurb,id) values ('$url','$title','$blurb','$id');";
print $query ."<br>\n";
// run the query on the database
$result = mysql_db_query($db,$query) or die("Error in query");
mysql_close($connection);
unset($query);
$output = "Great!";

include("template.php");
?>

and this is template.php

<head>
<title><?=$page_title; ?></title>
<style type="text/css">
<!--
H2
{
font-size: 10pt;
font-family: verdana,arial,helvetica,sans-serif;
font-weight: bold;
}

BODY
{

font-size: 10pt;
font-family: verdana,arial,helvetica,sans-serif;
background: #CCCC99
}

IMG
{
border-color: #336699;
}

TD
{
font-size: 10pt;
font-family: verdana,arial,helvetica,sans-serif;
}
INPUT, SELECT, TEXTAREA
{
font-size: 8.5pt;
font-family: arial,helvetica,sans-serif;
}
A {text-decoration: none; color:#336699; font-size:10pt; font-family:verdana}
A:hover {text-decoration: underline;}
HR {color:"#336699"; size:1}
-->
</style>

</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" text="#336699">

<tr>
<td valign="top"><a href="index.php"><IMG SRC="logo.gif" border="0"></a></td>
<td valign="middle" halign="right">Banner Area</td>
</tr>

</table>

</td></tr>

  <h2>Welcome to the new site:</h2>
  We now have many new features and a great new look!


  </font></td>

</tr>

</table>

<center><br>&copy LinksManager, 2001<p></center>

</body>

template.php also links to sidemenu.php but this code contains no php.

Thanks for your help,

Gareth

Anon

Hi,

I'm having the same problem here. I've developed a time system using PHP4.06 and mySQL-3.23.41. Everything was running smoothly untill now. Sometimes, not all the time, when users update there time, it gets inserted twice in the db. It is a simple insert query i'm using.

please let me know if you find the problem.

thanx
chris