After more frustration I discovered that the form that calls the function was submiting twice.
After more frustration I discovered that the problem was indeed only happening in Explorer and not Netscape.
After more frustration I discovered that the privacy features of my firewall (which...
I removed the Unique index from the "Company" field.
Now the query is creating 2 rows!
That explains the errors since it was trying to make 2 rows with the same company name.
But why is it making 2 rows????
The function is saying that only 1 row is being made:
rows...
The table has an autoincrement type: int(11) named CompanyID as the PK.
I see that CompanyID is also indexed. Since the field is assigned as the PK is it implicitly indexed or am I correct in also indexing the field.
Also Company is Unique.
thanks for the quick replies.
I also connect to this database via Access and ODBC.
I confirm that the records are in fact created by opening the table in Access.
I'm having problems with the following function:
Function Commit_Company ($uid, $company, $description, $address, $city,
$province, $postalcode, $country, $web, $print, $online, $radio, $venue)
{
global $hostname, $password, $user;
mysql_connect($hostname,$user,$password)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.