Re: PHP or MySQL are putting extra records into my DB file

Lynne, 1. Where are you testing for the action of the form? 2. What triggers the insert? For more on this, have a look at the custom error tutorial put up by Julie Meloni at http://www.thickbook.com Right now it looks as if you are inserting a record every time the page loads. So you would get a record on the initial load, when $event_title and $event_desc are empty, on the submit, when they have values, and on the following reload, if you do one. Hope this helps - Miles Thompson At 07:28 AM 12/9/2001 -0500, Lynne wrote:

Using simple test scripts, I'm connecting to a MySQL DB through PHP after inputting info into a form and hitting submit. Something is putting three records instead of one into the mySQL DB. For instance: the two variables are: $event_title and $event_desc. These are gotten from the form submitting to the PHP doc. The PHP code is as follows: <?php $link = mysql_connect("localhost", "llupien", "dod2196"); if (! $link) die ("Couldn't connect to MySQL"); mysql_select_db("scco") or die ("Couldn't open database phptest"); $query = "INSERT INTO events (title,description) values ('$event_title','$event_desc')"; mysql_query($query, $link) or die ("Couldn't add data to table: ".mysql_error()); mysql_close($link); ?> It's simple and I know the syntax is right...but in my simple little table, I get three records - one correctly entered and two blanks. The two blanks force the autonumber ID field to increment, but are completely blank otherwise. Why would I get three records? I use MySQL and PHP with my hosting service...they have PHPMyAdmin installed...when you add a record from PHPMyAdmin, it works peachy. So something PHP is working just fine, just not *my* scripts. One of my theories is that it's something about the way I connect..."localhost" may be wrong or need a port?? I've asked them over and over what the connection requires but they don't seem to know what they're talkign about. They keep telling me the pathway "usr/local/mysql" etc, but can't tell me how to connect to the mySQL db's. Anyway, it might be hopeless, but I'm hoping someone can lead me in the right direction. Thanks! Lynne -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net