Deleting specific records from MySQL tables
| From: | Matthew Tyler | Date: | Sun, 20 May 2001 18:50:44 +0000 |
| Subject: | Deleting specific records from MySQL tables | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-9479@lists.php.net to get a copy of this message | ||
I'm having difficulty getting certain records in MySQL tables to delete. I
have this bit of code:
mysql_db_query("phpads", "DELETE FROM adviews WHERE
bannerID=$banresult[bannerID]");
What I'm doing here is trying to get the records from table adviews with a
bannerID entry of "$banresult[bannerID]" to delete. When I run this nothing
happens, I don't get an error, just nothing happens. I know that
$banresult[bannerID] is defined and everything because it is used in a key
query two lines before, which works fine. Can anyone help me with this?
- Matthew Tyler