Dear Shehzad,
Gopi has assigned the variable count already
$result=mysql_query($sql);
$count=mysql_num_rows($result);
but of course with wrong values. this should be assigned with selected check
boxes value as you suggested in your reply.
$count = count($_REQUEST['Checkbox']);
Thanks
Neeraj Jain
Senior Software Engineer
Tokyo.
On Sun, Aug 3, 2008 at 10:49 PM, Shehzad Asghar Saddiq <
shehzad_asghar@xxxxxxxxxxxxxxxxxxx> wrote:
> You are not putting anything in the $count variable.
>
> Kindly make it $count = count($_REQUEST['Checkbox']) before running the for
> loop for delete.
>
> Thanks & Best Regards,
>
> Shehzad Asghar Saddiq
>
> Group Manager Products
> UAE Experts IT Networking Services
>
> "This e-mail message (including any attachments) may contain confidential,
> proprietary or legally privileged information. It should not be used by
> anyone who is not the original intended recipient. If you have erroneously
> received this message, please delete it immediately and notify the sender.
> The recipient acknowledges that UAE Experts IT Networking Services or its
> sister companies and associated companies, (collectively "UAE Experts IT
> Networking Services"), are unable to exercise control or ensure or guarantee
> the integrity of/over the contents of the information contained in e-mail
> transmissions and further acknowledges that any views expressed in this
> message are those of the individual sender and no binding nature of the
> message shall be implied or assumed unless the sender does so expressly with
> due authority of UAE Experts IT Networking Services. Before opening any
> attachments please check them for viruses and defects."
>
>
> From: php-objects@xxxxxxxxxxxxxxx <php-objects%40yahoogroups.com> [mailto:
> php-objects@xxxxxxxxxxxxxxx <php-objects%40yahoogroups.com>] On Behalf Of
> gopi nath
> Sent: Saturday, August 02, 2008 6:49 AM
> To: php-objects@xxxxxxxxxxxxxxx <php-objects%40yahoogroups.com>
> Subject: Delete the Multiple Check Box using php+mysql
>
>
> HI Friends,
>
> i have a doubt in my script. my error is: cannot delete the multiple rows.
> <?php
>
> $host="localhost"; // Host name
>
> $username=""; // Mysql username
>
> $password=""; // Mysql password
>
> $db_name="test"; // Database name
>
> $tbl_name="test_mysql"; // Table name
> // Connect to server and select databse.
>
> mysql_connect("$host", "$username", "$password")or die("cannot connect");
>
> mysql_select_db("$db_name")or die("cannot select DB");
> $sql="SELECT * FROM $tbl_name";
>
> $result=mysql_query($sql);
> $count=mysql_num_rows($result);
> ?>
>
> <table width="400" border="0" cellspacing="1" cellpadding="0">
>
> <tr>
>
> <td><form name="form1" method="post" action="">
>
> <table width="400" border="0" cellpadding="3" cellspacing="1"
> bgcolor="#CCCCCC">
>
> <tr>
>
> <td bgcolor="#FFFFFF"> </td>
>
> <td colspan="4" bgcolor="#FFFFFF"><strong>Delete multiple rows in
> mysql</strong> </td>
>
> </tr>
>
> <tr>
>
> <td align="center" bgcolor="#FFFFFF">#</td>
>
> <td align="center" bgcolor="#FFFFFF"><strong>Id</strong></td>
>
> <td align="center" bgcolor="#FFFFFF"><strong>Name</strong></td>
>
> <td align="center" bgcolor="#FFFFFF"><strong>Lastname</strong></td>
>
> <td align="center" bgcolor="#FFFFFF"><strong>Email</strong></td>
>
> </tr>
>
> <?php
>
> while($rows=mysql_fetch_array($result)){
>
> ?>
>
> <tr>
>
> <td align="center" bgcolor="#FFFFFF"><input name="checkbox[]"
> type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"></td>
>
> <td bgcolor="#FFFFFF"><? echo $rows['id']; ?></td>
>
> <td bgcolor="#FFFFFF"><? echo $rows['name']; ?></td>
>
> <td bgcolor="#FFFFFF"><? echo $rows['lastname']; ?></td>
>
> <td bgcolor="#FFFFFF"><? echo $rows['email']; ?></td>
>
> </tr>
>
> <?php
>
> }
>
> ?>
>
> <tr>
>
> <td colspan="5" align="center" bgcolor="#FFFFFF"><input
> name="delete" type="submit" id="delete" value="Delete"></td>
>
> </tr>
>
> <?
>
> // Check if delete button active, start this
>
> if($delete){
>
> for($i=0;$i<$count;$i++){
>
> $del_id = $checkbox[$i];
>
> $sql = "DELETE FROM $tbl_name WHERE id='$del_id'";
>
> $result = mysql_query($sql);
>
> }
> // if successful redirect to delete_multiple.php
>
> if($result){
>
> echo "<meta http-equiv=\"refresh\" content=\"0;URL=delete_multiple.php\">";
>
> }
>
> }
>
> mysql_close();
>
> ?>
>
> </table>
>
> </form>
>
> </td>
>
> </tr>
> </body>
> </html>
>
> Add more friends to your messenger and enjoy! Go to
> http://in.messenger.yahoo.com/invite/
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>
[Non-text portions of this message have been removed]
