rudy,
I can't get on line at the moment, but the auto-increment has solved the
mysql part of the problem. Now it is just the php that won't do its part.
I have what is identical to this tiny table:
<?php
error_reporting(0);
include$_SERVER['DOCUMENT_ROOT'].'/www.poetryadmin.com/spw_layout.php';
myheader();
include$_SERVER['DOCUMENT_ROOT'].
'/www.poetryadmin.com/html/forms/spw_poemtype_insert_form.html';
$username="xxxxx";
$password='xxyyxx';
$database="spw";
$localhost="127.0.0.1";
mysql_pconnect(localhost,$username,$password);
mysql_select_db($database) or die('failed to select DB');
$sql = @mysql_query("INSERT INTO spw_type (spw_type_id ,
spw_type_description) VALUES ('', '$_POST[poemtype]')") or die ("Query
failed");
// run the query
mysql_query($sql);
if(!sql){
echo "Error inserting your info into mysql: ".mysq_error();
footer();
exit();
}
?>
So I'll check on spaces
Joseph
> > #1062 - Duplicata du champ '0' pour la clef 1
>
> mysql says it can't insert because of a duplicate key
>
>
>
> could you please do a SHOW TABLE for that table?
>
> and maybe SELECT * and copy the last few rows here...
>
>
> rudy
____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
Send Your Posts To: [EMAIL PROTECTED]
To set a personal password send an email to [EMAIL PROTECTED] with the words: "set
WDVLTALK pw=yourpassword" in the body of the email.
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
