Code: Select all
<?php
$sqlCommand = "INSERT INTO Locations (CompanyID, Country, Address, City, State, Zip, Phone, Fax) VALUES ('$companyID', '$country', '$address', '$city', '$state', '$zip', '$phone', '$fax')";
?>looked at the database and saw that someone hadn't set the LocationID field to autonumber....it was just set to number. i guess i
have to create a function that makes non-duplicates for an ID (primary key) field. does anyone already have a function like this that they'd
be willing to pass along? or does anyone know a quick way to do this? any help is appreciated.
phil