DaniWeb Forum Index > Web Development > PHP

Hot to delete

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Feb 2008

Posts: 2

Reputation: bihartourism is an unknown quantity at this point

Solved Threads: 0

bihartourism bihartourism is offline

Offline

Newbie Poster

Hot to delete

Feb 23rd, 2008

Dear members how i can delete a record from a table in php?Give me the code plz...

Last edited by bihartourism; Feb 23rd, 2008 at 3:44 am.

Great Gautama Buddha || Buddha Statues || How To Become A Model

•

Join Date: Apr 2007

Posts: 18

Reputation: apsivam is an unknown quantity at this point

Solved Threads: 4

apsivam

Offline

Newbie Poster

Re: Hot to delete

Feb 23rd, 2008

there is nothing special or specific to PHP,
use your normal SQL statement with PHP for example with MySQL

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
mysql_query("DELETE FROM my_table WHERE id = 1");
mysql_query("DELETE FROM my_table WHERE id = 1");

Last edited by apsivam; Feb 23rd, 2008 at 4:01 am.

Cheers,
Sivanandhan, P. (a.k.a. apsivam)
www.apsivam.in

•

Join Date: Oct 2005

Posts: 36

Reputation: tirivamwe is an unknown quantity at this point

Solved Threads: 2

tirivamwe

Offline

Light Poster

Re: Hot to delete

Feb 23rd, 2008

try modify this code to suit what you want

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
 
$name= "record to delete"
 
$sql = "DELETE FROM Users WHERE Name= '$name'"or die ("ERROR: Cannot not find user!"); 
 
$result = mysql_query($sql) or die ("Error in query: $sql. ".mysql_error());
$name= "record to delete"

$sql = "DELETE FROM Users WHERE Name= '$name'"or die ("ERROR: Cannot not find user!"); 

$result = mysql_query($sql) or die ("Error in query: $sql. ".mysql_error());