RE: [PHP-DB] DELETE FROM.... Question

Try: mysql_db_query ("DELETE FROM events WHERE event_id = " . $event_id); I have had better luck with "mysql_db_query". Sean -----Original Message----- From: kenjansons@colinux.net [mailto:kenjansons@colinux.net] Sent: Monday, January 15, 2001 3:50 PM To: php-db@lists.php.net Subject: [PHP-DB] DELETE FROM.... Question Hello, I am new to the list, so please bear with me! I am creating a database system that will use PHP4 and MySQL 3.22. I've got things working excellent now... I can add, list, and modify records from the PHP scripts I have created, but I can't delete them. I can do them manually by going into MySQL and issuing the appropriate commands, but not through the PHP script.. Here is the main part of the PHP script: mysql_query ("DELETE FROM events WHERE event_id = '$event_id'"); and I have the $variables pre, defined, and the mysql_include and use_databse, and all that jazz in an include.inc, which I have set to use at the top of the script. I have also tried mysql_db_query, and nothing seems to work. The database is called domains, and the table is called events, and the ID is the event_id field. If anyone knows of any good places relevant to this problem, I would greatly appreciate it if they could e-mail me links to them, or maybe some sample code on how to delete records. Here is some more info, if it helps: When I delete it manually, it deletes, but through the script it does not. Any help would be greatly appreciated! ----- ./mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 44 to server version: 3.22.32 Type 'help' for help. mysql> use domains; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> describe events; +-----------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+--------------+------+-----+---------+----------------+ | event_id | int(11) | | PRI | 0 | auto_increment | | domain_id | varchar(25) | YES | | NULL | | | date | varchar(20) | YES | | NULL | | | time | varchar(10) | YES | | NULL | | | logger | varchar(10) | YES | | NULL | | | event | varchar(255) | YES | | NULL | | +-----------+--------------+------+-----+---------+----------------+ 6 rows in set (0.06 sec) mysql> SELECT * FROM events WHERE (event_id = '9'); +----------+-----------+---------------+---------+--------+----------------+ | event_id | domain_id | date | time | logger | event | +----------+-----------+---------------+---------+--------+----------------+ | 9 | 1 | Jan. 14, 2001 | 5:53 PM | kj | NEW TEST!!!!!! | +----------+-----------+---------------+---------+--------+----------------+ 1 row in set (0.00 sec) mysql> DELETE FROM events WHERE (event_id = '9'); Query OK, 1 row affected (0.04 sec) and poof, the record is gone.... -- 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