Insert problem

webwonder

I am having a problem with an insert to my database, i have a property website that has featured properties on the home page, the featured property script is seperate from the page and called using an include statement, the insert is used to log the views for each property.
the code for inserting into the database is as follows:

$house = $row["id"];
$date = date("Y-m-d");
$sql = "INSERT INTO data VALUES ('null','31','$house','$username','$date')";
mysql_query($sql)or die("Your error statement here".mysql_error());

The problem i am having is it seems to be inserting data into the database even if i am not on the web page, could it be inserting it by using phpmyadmin via cpanel??
everytime i browse the table there is another row on the database, the data has the correct id number for me, the id ($username) comes from a cookie.??
I have tried moving the featured property script into a seperate folder but it is still occuring?
I am baffled
Help

buddy15

im no master at php lol because i have my own malfunction... but sounds like the server is running the script? i dont know though..

webwonder

How can i prevent this problem?

buddy15

I'm not 100% sure... i need to figure out how to do that problem lol im working on another script for a company that every 30 mins a user is logged in something has to update on their account...

unless the server was running the cookie vars every so often or something i have no idea? i dont even know if thats possible..

webwonder

I am pulling my hair out, have deleted the cookie and it still updates the site, have changed the table name because it was called data, thought that maybe a problem but it still did it. Removed the script off the server and it stopped doing it...
Must be the script!!!
I cannot see anything wrong with it.
can you help please:

<?php
if (!($connection = mysql_connect(localhost, ***, )))
die("could not connect");
if (!(mysql_select_db(**, $connection)))
showerror();
$result = mysql_query ("SELECT * from house where feature='Yes' ORDER BY RAND() limit 1");
$row = mysql_fetch_array($result);
$photo = $row["photo1"];

$house = $row["id"];
$date = date("Y-m-d");
mysql_query("INSERT INTO data(id, view, property, viewer, td) VALUES ('null','3','$house','$username','$date')");

echo "<table width=150 cellpadding=1 cellspacing=0 border=1 bordercolor=#000000>
<tr>
<td width=150 bgcolor=#99b7cc height=140 valign=top>
<table width=150 cellpadding=0 cellspacing=0 border=0>
<tr>
<td width=150 bgcolor=#c00000 height=16 align=center valign=top>
<font size=3 color=#ffffff face=arial black>
<b>
Featured House
</b>
</font>
</td>
</tr>
</table>
<br>
<center>
<img src=uploads\" . $row["photo1"] . " width=\"100\" height=\"75\" border=\"1\" bordercolor=#000000>";
echo "<br><br><b>£" . $row["price"] . "</b><br><br>" . $row["town"] . "<br>" . $row["count"] . "<br><br>         <a class=more href=show_property.php?house=" . $row["id"] . ">More info>></a><br><br>
<a href=add_featured_house.php class=more>My house here</a></center></td></tr></table>";
mysql_close($connection);
?>

Dont normally close the connection but added it in case it was the problem.
Spoke to hosting company and they said it was definately not a server problem?