SitePoint Sponsor |
|
User Tag List
Results 1 to 5 of 5
-
May 17, 2001, 03:37 #1
- Join Date
- Mar 2001
- Location
- the Netherlands
- Posts
- 519
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
I'm wondering what I should do with the delete function...
According to the book I have the syntax should be something like this:
PHP Code:DELETE datapoint FROM table WHERE condition
Can I add 'cascade on delete' queries into the database?
Please advise
-
May 17, 2001, 08:15 #2
- Join Date
- Aug 1999
- Location
- Pittsburgh, PA, USA
- Posts
- 3,910
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
I don't understand what you mean -- can you explain specifically what you're trying to do?
This, however, WILL delete the entire entry, all columns in the record:
DELETE FROM table_name WHERE id=5
-
May 17, 2001, 23:32 #3
- Join Date
- Jun 2000
- Location
- Sydney, Australia
- Posts
- 3,798
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
I don't know what datapoint is ?!?
-
May 18, 2001, 01:01 #4
- Join Date
- Mar 2001
- Location
- the Netherlands
- Posts
- 519
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
So,
DELETE FROM table WHERE id=$id
should be sufficient?
-
May 18, 2001, 01:33 #5
- Join Date
- Jun 2000
- Location
- Sydney, Australia
- Posts
- 3,798
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
looks beautiful
Bookmarks