I'm sorry for bugging everyone, I just created a new PHP script, and used
the following code:
mysql_query ("DELETE FROM events
WHERE event_id = $event_id");
And it worked!
I must've have something wrong in the original script.
-Ken
----- Original Message -----
From: "Ken Jansons" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 15, 2001 5:17 PM
Subject: Re: [PHP-DB] DELETE FROM.... Question
> I tried that code, but now it gives me the following error:
> Warning: Wrong parameter count for mysql_db_query() in
> /usr/bus/events/delete.php on line 29
>
> when I send delete.php?event_id=5
> (Which is a valid value for the event_id field)..... Any more ideas
anyone?
> and line 29 is that code that I put in, and it doesn't delete it
still.....
>
> Thanks for the help so far, I appreciate it!
>
> -Ken
>
> ----- Original Message -----
> From: "Alarion" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Monday, January 15, 2001 4:57 PM
> Subject: 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, January 15, 2001 3:50 PM
> > To: [EMAIL PROTECTED]
> > 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: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
> >
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
