Delete data from database table in php

Code:

<?php
   mysql_connect("server","user","password");
   mysql_select_db("dbname");

   $rowID = "001";
   $query = "DELETE FROM Employee WHERE ID='$rowID'";
   $result = mysql_query($query);

   if ((mysql_affected_rows() == 0) || mysql_affected_rows() == -1) {
        echo "<p>There was a problem deleting some of the selected items.</p>";
        exit;
   }
?>

_________________
M. S. Rakha, Ph.D.
Queen's University
Canada

Author: DrRakha
Mastermind

Posts: 2715
Have thanks: 74 time

Page 1 of 1

[ 1 post ]

Related Posts to : Delete data from database table in php
Delete data from database by ID in php -
need help building table in my database! -
List Database, Table, and Field in php -
Displaying images from database instead of the url from data -
How to fill a ComboBox with data from a database in jsp -
NULL Data in table -
database contents display in table format in swing -
Display data from database as Tree Structure in JSP -
Loading table data from a CSV file -
show table data by clicking button -

Topic Tags

PHP Database

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com