Hey everyone,
I keep getting multiple blank records entered along with my data everytime
I submit my form.
On the first page is the form itself without any code. On the 2nd page that
it goes to after I hit submit is this:
<?
$select = "SELECT * FROM company,contact WHERE
contact.company_id=company.company_id ORDER BY contact.company_id DESC
LIMIT 10;";
$result = mysql_query($select)or die("Invalid query: " . mysql_error());
while ($row = mysql_fetch_assoc($result)) {
print '<b>'.$row['Subject'].'</b>'.'<br>';
print $row['category'].'<br><br>';
print $row['name'].' - ';
print $row['email'].'<br><br>';
print $row['location'].'<br><br>';
}
?>
Now everytime I hit submit on that page I get three other entries entered
in at the same time. Also when I go to this page straight the data is
displayed in an order I can't figure out.
Any help is appreciated, thanks!