Wrox Programmer Forums
Go Back   Wrox Programmer Forums > PHP/MySQL > PHP Databases
|
PHP Databases Using PHP in conjunction with databases. PHP questions not specific to databases should be directed to one of the other PHP forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the PHP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 28th, 2005, 04:46 AM
Registered User
 
Join Date: Oct 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to taha_elearner
Default How can i delete multiple row through PHP coding

I am working on a project for my college , I have a problem in message page where I retrieve data from database and I also give delete option on this page so my prepare code can delete single row at a time so I want to delete multiple rows at a time

Plz help me in this.


Allah watching you
 
Old October 28th, 2005, 05:33 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 357
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to anshul
Default

Consider SQL syntax:

'DELETE FROM table_name' deletes all rows.

'DELETE FROM table_name WHERE condition' delete 1 or more rows matching the condition. If conditions are many, call this rule many times.

You may show 'checkbox' or 'multiple select' for 'admin' and when he/she selects (unique) IDs, records will get deleted may be by a single statement in a loop.

This is simple.
http://www.mediasworks.com/tutorials...l_tutorial.htm




`~@#\^%&*/\.<.\/-|+|_!:;..=?>
Support Indian students' finances http://scholarship.mediasworks.com/





Similar Threads
Thread Thread Starter Forum Replies Last Post
php/mysql delete button and delete query dungey PHP Databases 17 April 11th, 2009 12:24 PM
DataGridView - how to delete Row [email protected] C# 2005 0 November 25th, 2007 06:43 AM
Commit.PHP and Delete.PHP in WROX's book GiFos Beginning PHP 0 January 30th, 2007 10:51 PM
Questions regaring PHP Coding phpcoder1 PHP How-To 0 November 4th, 2004 05:02 PM
how to delete a row when click delete hyperlink naveenkumarg1 Pro JSP 1 August 16th, 2004 01:29 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.