possible Error in Querydefiniton
| From: | Ruprecht Helms | Date: | Sun, 06 Oct 2002 19:25:09 +0000 |
| Subject: | possible Error in Querydefiniton | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-22235@lists.php.net to get a copy of this message | ||
Hi,
I've some trouble with the following querydefinition
<?
mysql_connect("localhost","root");
mysql_db_query("finace","INSERT INTO buchung (Bezeichnung) VALUES
('b')")
or die ("Query ungültig");
?>
and this is the tablestructur
+-------------+--------------+------+-----+---------+----------------+----------
| Field | Type | Null | Key | Default | Extra |
Privileges |
+-------------+--------------+------+-----+---------+----------------+---------
| ID | int(11) | | PRI | | auto_increment |...
| Bezeichnung | varchar(30) | YES | | | |
| Art | char(1) | YES | | | |
| Brutto | char(1) | YES | | | |
| Betrag | decimal(8,2) | YES | | | |
| Steuer | int(11) | | | 0 | |
+-------------+--------------+------+-----+---------+----------------+----------
By execution the script says that the query die. I don't know why.
------------------------------------------------------------
Ruprecht Helms IT-Service und Softwareentwicklung
Tel/Fax: +49[0]7621 16 99 16
email: info@rheyn.de
Homepage: http://www.rheyn.de
-------------------------------------------------------------