PHP Coding
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Codewalkers Forums > PHP Related > PHP Coding
Reload this Page

Deleting the records in a table

Discuss Deleting the records in a table in the PHP Coding forum on Codewalkers.
Deleting the records in a table Having problems with a PHP script you are coding? This is the place to get help!

Record onscreen activity, your voice & webcam video. Turn everyday presentations into HD-quality videos.

For perfectly clear screencasts every time.
At the IBM® developerWorks Developer Knowledge Center you'll find resources for FREE ekits, Tutorials, Webcasts, Trial Downloads and more.


We cover the world of technology like no one else, constantly updating you with the best information available on open source software, Microsoft technologies, hardware and news from around the world.

Try Camtasia Studio today!
Visit the IBM® Developer Knowledge Center today!
Sign up today!

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Codewalkers Forums Sponsor:
  #1  
Old September 3rd, 2002, 08:33 PM
chinni chinni is offline
Codewalkers Newbie (0 - 499 posts)
  
Join Date: Apr 2007
Posts: 58 chinni User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 3
Deleting the records in a table
hello all,
I display all the records from a table on a form.I used to update the fields and Now, i would like to delete record(s) in a table using the same form.
Here it goes how i really want to implement this one:

1.First, i dont want to delete the record in a table in a single-step.
2.(when i displayed the records from a table, i also display a check box at the end of each record).

3.Now, first, i want to check this box and click submit button.when i do this, i want to set a value to this row in the table(I've inserted a column called delete in the table)So, this column will have a value 0 or 1 when this row has been selected to delete.
4.After the value has been set, the form will show two buttons or images which has the values cancel delete or delete the record.

so, thatz it.

First thing, i would really like to do is to set the value to the delete column when the check box has been checked.

The records will be deleted only based on the column(delete), i.e the flag value.

If somebody has implemented such an application before, could you pls give me the code, if not atleast something similar to delete the records would be fine.I am able to do it with a simple delete statement in a single step but not in the way how i explained before.

For your reference here is my code which

hope somebody would be there to give assistance

Thanks in advance

To this code, i need to implement the delete functionality.

php Code:
Original - php Code 
  1.  
  2. <?php
  3. //Database connection
  4.  
  5. if ($HTTP_POST_VARS){
  6.     /*-- the form was submitted, lets process it --*/
  7.     /*-- get a count of how many ids we have to process --*/
  8.     $cnt = count($HTTP_POST_VARS['id']);
  9.  
  10.     /*-- cycle through the arrays and update the database table --*/
  11.     for($cntr=0;$cntr<$cnt;$cntr++) {
  12.     if (!$HTTP_POST_VARS['attach'][$cntr]) $attach=0; else $attach=1;
  13.     if (!$HTTP_POST_VARS['detach'][$cntr]) $detach=0; else $detach=1;
  14.     
  15.     $sql = "UPDATE TBL_STATION SET ". 
  16.         "HS_IPUI = '{$HTTP_POST_VARS['ipui'][$cntr]}', ".
  17.         "HS_TEI = '{$HTTP_POST_VARS['tei'][$cntr]}', ".
  18.         "HS_ATTACH = '$attach', ".
  19.         "HS_DETACH = '$detach', ". 
  20.         "HS_AC = '{$HTTP_POST_VARS['ac'][$cntr]}' ".
  21.         "where HS_ID = {$HTTP_POST_VARS['id'][$cntr]}";
  22.                     
  23.         $update_results = ibase_query($sql);
  24.     }
  25. }
  26.  
  27. /*-- get all records from the table --*/
  28.  
  29.     $select_sql = 'Select HS_ID, HS_DETACH, '. 
  30.               'HS_ATTACH, HS_IPUI, HS_TEI, HS_AC from TBL_STATION';
  31.                       
  32.     $result_id = ibase_query($select_sql);
  33. ?>
  34.  
  35. <p class="hsnormalbold"><b>Edit details</b></p>
  36.     <hr style="line-height:100%; margin-top:0px; margin-bottom:0px;">
  37.     <form name="edit details" action="<?=$HTTP_SERVER_VARS['PHP_SELF']?>" method="POST">
  38.         <table cellpadding="0" cellspacing="0" width="909" class="hsnormal">
  39.             <tr style="margin:0; padding:0;" align="left" valign="top" class="hsnormal">
  40.                 <td width="154">
  41.                     IPUI&nbsp;&nbsp;&nbsp;
  42.                 </td>
  43.                 <td width="154">
  44.                     TEI
  45.                 </td>
  46.                 <td width="65">
  47.                     Attach
  48.                 </td>
  49.                 <td width="155">
  50.                     Detach
  51.                 </td>
  52.                 <td width="96">
  53.                     AC
  54.                 </td>
  55.                 <td width="96">
  56.                     Delete
  57.                 </td>
  58.                 </tr>
  59. <?php
  60.         
  61.         $counter=0;
  62.         $old_values=null;
  63.     
  64.         while ($row = ibase_fetch_object($result_id)) {
  65.         $attach=$row->HS_ATTACH;
  66.         $detach=$row->HS_DETACH;
  67.         $ipui=$row->HS_IPUI;
  68.         $tei=$row->HS_TEI;
  69.         $ac=$row->HS_AC;
  70.         
  71.         /*-- output this row in the table --*/
  72. ?>
  73.             <tr style="margin:0; padding:0;" align="left" valign="top" class="hsnormal">
  74.                 <td width="156" height="23">
  75.                     <input type="text" name="ipui[<?=$counter?>]" value="<?=$ipui?>">
  76.                 </td>
  77.                 <td width="154" height="23">
  78.                     <input type="text" name="tei[<?=$counter?>]" value="<?=$tei?>">
  79.                 </td>
  80.                 <td width="69" height="23">
  81.                     <input type="checkbox" name="attach[<?=$counter?>]" value="1"<? if ($attach==1)echo "checked";?>>
  82.                 </td>
  83.                 <td width="65" height="23">
  84.                     <input type="checkbox" name="detach[<?=$counter?>]" value="1" <? if ($detach==1)echo "checked";?>>
  85.                 </td>
  86.                 <td width="156" height="23" align="left" valign="top">
  87.                     <input type="text" name="ac[<?=$counter?>]" value="<?=$ac?>">
  88.                 </td>
  89.                 <td width="65" height="23">
  90.                     <input type="checkbox" name="delete" value="1">->>When this check box is checked, i want the delete column t รณ be set to 1 for the selected row
  91.                 </td>
  92.             </tr>
  93.     <?php
  94.         
  95.         $old_values.='    <input type="hidden" name="id['.$counter.']" value="'.$row->HS_ID.'">
  96.         ';
  97.         $counter++;
  98.     }
  99.     ?>
  100.         </table>
  101.         <?=$old_values?>
  102.         <input type="submit" name="submit" value="Update">
  103.         &nbsp;&nbsp;
  104.         <input type="hidden" value="Reset">
  105.     </form>
  106.     <p class="hsnormal">&nbsp;</p>
  107.     <p class="hsnormal">&nbsp;</p>
  108.     <p class="hsnormal">&nbsp;</p>
  109.     <p class="hsnormal">&nbsp;</p>
  110.     <p class="hsnormal">&nbsp;</p>
  111.     <p class="hsnormal">&nbsp;</p>
  112.     <p class="hsnormal">&nbsp;</p>
  113.     <p class="hsnormal">&nbsp;</p>
  114. </body>
  115. </html>
  116.  






Reply With Quote
  #2  
Old September 3rd, 2002, 08:55 PM
Nimco Nimco is offline
Codewalkers Newbie (0 - 499 posts)
  
Join Date: Apr 2007
Posts: 132 Nimco User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 3
Send a message via AIM to Nimco
RE: Deleting the records in a table
Wasn't this answered in: ?

http://codewalkers.com/forum/index....6&realm=default

OK, I'm just going to copy out your code below with colour coding on so that it is easier to read - then I'll see if I can modify it where necessary for you.
--------

php Code:
Original - php Code 
  1.  
  2. <?php
  3. //Database connection
  4.  
  5. if ($HTTP_POST_VARS){
  6. /*-- the form was submitted, lets process it --*/
  7. /*-- get a count of how many ids we have to process --*/
  8. $cnt = count($HTTP_POST_VARS['id']);
  9.  
  10. /*-- cycle through the arrays and update the database table --*/
  11. for($cntr=0;$cntr<$cnt;$cntr++) {
  12. if (!$HTTP_POST_VARS['attach'][$cntr]) $attach=0; else $attach=1;
  13. if (!$HTTP_POST_VARS['detach'][$cntr]) $detach=0; else $detach=1;
  14.  
  15. $sql = "UPDATE TBL_STATION SET ". 
  16. "HS_IPUI = '{$HTTP_POST_VARS['ipui'][$cntr]}', ".
  17. "HS_TEI = '{$HTTP_POST_VARS['tei'][$cntr]}', ".
  18. "HS_ATTACH = '$attach', ".
  19. "HS_DETACH = '$detach', ". 
  20. "HS_AC = '{$HTTP_POST_VARS['ac'][$cntr]}' ".
  21. "where HS_ID = {$HTTP_POST_VARS['id'][$cntr]}";
  22.  
  23. $update_results = ibase_query($sql);
  24. }
  25. }
  26.  
  27. /*-- get all records from the table --*/
  28.  
  29. $select_sql = 'Select HS_ID, HS_DETACH, '. 
  30. 'HS_ATTACH, HS_IPUI, HS_TEI, HS_AC from TBL_STATION';
  31.  
  32. $result_id = ibase_query($select_sql);
  33. ?>
  34.  
  35. <p class="hsnormalbold"><b>Edit details</b></p>
  36. <hr style="line-height:100%; margin-top:0px; margin-bottom:0px;">
  37. <form name="edit details" action="<?=$HTTP_SERVER_VARS['PHP_SELF']?>" method="POST">
  38. <table cellpadding="0" cellspacing="0" width="909" class="hsnormal">
  39. <tr style="margin:0; padding:0;" align="left" valign="top" class="hsnormal">
  40. <td width="154">
  41. IPUI&nbsp;&nbsp;&nbsp;
  42. </td>
  43. <td width="154">
  44. TEI
  45. </td>
  46. <td width="65">
  47. Attach
  48. </td>
  49. <td width="155">
  50. Detach
  51. </td>
  52. <td width="96">
  53. AC
  54. </td>
  55. <td width="96">
  56. Delete
  57. </td>
  58. </tr>
  59. <?php
  60.  
  61. $counter=0;
  62. $old_values=null;
  63.  
  64. while ($row = ibase_fetch_object($result_id)) {
  65. $attach=$row->HS_ATTACH;
  66. $detach=$row->HS_DETACH;
  67. $ipui=$row->HS_IPUI;
  68. $tei=$row->HS_TEI;
  69. $ac=$row->HS_AC;
  70.  
  71. /*-- output this row in the table --*/
  72. ?>
  73. <tr style="margin:0; padding:0;" align="left" valign="top" class="hsnormal">
  74. <td width="156" height="23">
  75. <input type="text" name="ipui[<?=$counter?>]" value="<?=$ipui?>">
  76. </td>
  77. <td width="154" height="23">
  78. <input type="text" name="tei[<?=$counter?>]" value="<?=$tei?>">
  79. </td>
  80. <td width="69" height="23">
  81. <input type="checkbox" name="attach[<?=$counter?>]" value="1"<? if ($attach==1)echo "checked";?>>
  82. </td>
  83. <td width="65" height="23">
  84. <input type="checkbox" name="detach[<?=$counter?>]" value="1" <? if ($detach==1)echo "checked";?>>
  85. </td>
  86. <td width="156" height="23" align="left" valign="top">
  87. <input type="text" name="ac[<?=$counter?>]" value="<?=$ac?>">
  88. </td>
  89. <td width="65" height="23">
  90. <input type="checkbox" name="delete" value="1">->>When this check box is checked, i want the delete column t รณ be set to 1 for the selected row
  91. </td>
  92. </tr>
  93. <?php
  94.  
  95. $old_values.=' <input type="hidden" name="id['.$counter.']" value="'.$row->HS_ID.'">
  96. ';
  97. $counter++;
  98. }
  99. ?>
  100. </table>
  101. <?=$old_values?>
  102. <input type="submit" name="submit" value="Update">
  103. &nbsp;&nbsp;
  104. <input type="hidden" value="Reset">
  105. </form>
  106. <p class="hsnormal">&nbsp;</p>
  107. <p class="hsnormal">&nbsp;</p>
  108. <p class="hsnormal">&nbsp;</p>
  109. <p class="hsnormal">&nbsp;</p>
  110. <p class="hsnormal">&nbsp;</p>
  111. <p class="hsnormal">&nbsp;</p>
  112. <p class="hsnormal">&nbsp;</p>
  113. <p class="hsnormal">&nbsp;</p>
  114. </body>
  115. </html>
Reply With Quote
  #3  
Old September 3rd, 2002, 09:07 PM
Nimco Nimco is offline
Codewalkers Newbie (0 - 499 posts)
  
Join Date: Apr 2007
Posts: 132 Nimco User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 3
Send a message via AIM to Nimco
RE: Deleting the records in a table
OK, your problem is that all your checkboxes have the same value at the moment, "1". This makes it impossible to determine which checkbox goes with which row.

To modify it, change:

php Code:
Original - php Code 
  1.  
  2. <input type="checkbox" name="delete" value="1">
  3.  
  4. to:
  5.  
  6. <input type="checkbox" name="delete" value="<?=$counter?>">


and I think that should give you the identifier you need to set the delete flag.

Then, when the page is returned to itself with the necessary checkboxes ticked, you want code as follows:

php Code:
Original - php Code 
  1.  
  2. <?
  3. while(...)
  4. {
  5. if ($_POST['delete'] == "on") { <flag row> }
  6. }
  7. ?>


I shall leave you to write the while() loop (or a for() loop if you prefer) and the query to flag the rows since it will be much easier for you to do it as you have a clearer understanding of the specific table structure than I do.

Once you have flagged the relevant rows, it is just a case of running a query such as:

php Code:
Original - php Code 
  1.  
  2. DELETE FROM tbl_name WHERE delete='1';


By the way, I would recommend reducing your form name to a single word - help prevent errors.
Reply With Quote
  #4  
Old September 4th, 2002, 11:51 AM
chinni chinni is offline
Codewalkers Newbie (0 - 499 posts)
  
Join Date: Apr 2007
Posts: 58 chinni User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 3
RE: Deleting the records in a table
hello nim,

could you pls help me out further.I cant still do it.My table has the column HS_DELETE.I'm not able to set as a reference:

I would be extremely thankful to you if you can help me out with this.

thank you once again
Reply With Quote
  #5  
Old September 4th, 2002, 12:07 PM
Nimco Nimco is offline
Codewalkers Newbie (0 - 499 posts)
  
Join Date: Apr 2007
Posts: 132 Nimco User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 3
Send a message via AIM to Nimco
RE: Deleting the records in a table
What do you mean by "you can't set it as a reference"?
Reply With Quote
  #6  
Old September 4th, 2002, 12:16 PM
chinni chinni is offline
Codewalkers Newbie (0 - 499 posts)
  
Join Date: Apr 2007
Posts: 58 chinni User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 3
RE: Deleting the records in a table
i mean, when i check the check box and submit,the value of the column(HS_DELETE) is not set to 1, i.e the row is not set to delete.
Reply With Quote
  #7  
Old September 4th, 2002, 12:58 PM
Nimco Nimco is offline
Codewalkers Newbie (0 - 499 posts)
  
Join Date: Apr 2007
Posts: 132 Nimco User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 3
Send a message via AIM to Nimco
RE: Deleting the records in a table
Sorry, the code I gave you before was wrong. It should have been:

php Code:
Original - php Code 
  1.  
  2. <input type="checkbox" name="delete[<?=$counter?>]">
  3. [highlight=php]
  4.  
  5. Then I think you just need to modify your $sql variable like:
  6.  
  7. [highlight=php]
  8. <?
  9. $sql = "UPDATE TBL_STATION SET ". 
  10. "HS_IPUI = '{$HTTP_POST_VARS['ipui'][$cntr]}', ".
  11. "HS_TEI = '{$HTTP_POST_VARS['tei'][$cntr]}', ".
  12. "HS_ATTACH = '$attach', ".
  13. "HS_DETACH = '$detach', ". 
  14. "HS_AC = '{$HTTP_POST_VARS['ac'][$cntr]}' ";
  15.  
  16. if ($HTTP_POST_VARS['delete'][$cntr] == "on") { $sql.= "HS_DELETE = '1'"; }
  17. $sql.= "where HS_ID = {$HTTP_POST_VARS['id'][$cntr]}";
  18. ?>


Tell me if this works or not.
Reply With Quote
  #8  
Old September 4th, 2002, 01:31 PM
chinni chinni is offline
Codewalkers Newbie (0 - 499 posts)
  
Join Date: Apr 2007
Posts: 58 chinni User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 3
RE: Deleting the records in a table
hello nim,
sorry to tell you, itz'nt working.
It would be so kind of you, if you can append all the modifications in my code.Is this loop correct?

Code:
foreach( $HTTP_POST_VARS["delete"] AS $delete => $value ) {
if ( $value == "on" )


Thanks for helping me out.
Reply With Quote
  #9  
Old September 4th, 2002, 01:42 PM
Nimco Nimco is offline
Codewalkers Newbie (0 - 499 posts)
  
Join Date: Apr 2007
Posts: 132 Nimco User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 3
Send a message via AIM to Nimco
RE: Deleting the records in a table
hmmm... At the moment, that loop is checking each checkbox to see whether it is checked or not. If I am reading it correctly, the $delete variable should contain a matching value to $cntr, which you have used as your row ID. Can you not use this information to update the database as necessary?

What did the code I gave you before actually do? Did it return any errors? Did it add anything to the table? Try putting this code below the line which reads "$update_results = ibase_query($sql);" :

php Code:
Original - php Code 
  1.  
  2. <?
  3. echo mysql_errno() . ": " . mysql_error() . "n";
  4. ?>


This will cause any MySQL errors to be returned to the page.
Reply With Quote
  #10  
Old September 4th, 2002, 02:02 PM
chinni chinni is offline
Codewalkers Newbie (0 - 499 posts)
  
Join Date: Apr 2007
Posts: 58 chinni User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 3
RE: Deleting the records in a table
i am not able to display anything now.I doubt if this is in order.
Before, it was working fine, atleast i was able to display the records from the table,but now, itz blank.
since, i am using interbase as my database,i checked out with ibase_errmsg(),it does'nt show anything.I think the loop is not properly handled.

Thanks for your great attention Nim.


php Code:
Original - php Code 
  1.  
  2. <?php
  3. //database connection
  4.  
  5. if ($HTTP_POST_VARS){
  6.     $cnt = count($HTTP_POST_VARS['id']);
  7.  
  8.     for($cntr=0;$cntr<$cnt;$cntr++) {
  9.         if (!$HTTP_POST_VARS['enrolment'][$cntr]) $enrolment=0; else $enrolment=1;
  10.         if (!$HTTP_POST_VARS['ciphering'][$cntr]) $ciphering=0; else $ciphering=1;
  11.     foreach( $HTTP_POST_VARS["delete"] AS $delete => $value ) {
  12.     if ( $value == "on" ) {
  13.     
  14.     $update_sql = "update TBL_RBS SET ".
  15.             "RBS_RFPI = '{$HTTP_POST_VARS['rfpi'][$cntr]}', ".
  16.             "RBS_IPADDRESS = '{$HTTP_POST_VARS['ip_address'][$cntr]}', ".
  17.             "RBS_ENROLMENT = $enrolment, ".
  18.             "RBS_CIPHERING = $ciphering, ".
  19.             "RBS_TFTPFILENAME = '{$HTTP_POST_VARS['tftp_file'][$cntr]}' ".
  20.         
  21. if ($HTTP_POST_VARS['delete'][$cntr] == "on"){ $sql.= "RBS_DELETE=0"; } $sql.= "where RBS_ID = {$HTTP_POST_VARS['id'][$cntr]}";
  22.             
  23. $update_results = ibase_query($update_sql);
  24.        }
  25.      }
  26.    }
  27.  }
  28. $select_sql = 'Select RBS_ID, '.
  29.         'RBS_TFTPFILENAME, RBS_ENROLMENT, RBS_CIPHERING, '.
  30.         'RBS_RFPI, RBS_IPADDRESS from TBL_RBS';
  31.         
  32. $result_id = ibase_query($select_sql) or die('Error retrieving records from TBL_RBS.<br />Interbase Reported: '.ibase_errmsg());
  33. ?>
  34.     <b>Edit</b></p>
  35.     <hr style="line-height:100%; margin-top:0px; margin-bottom:0px;">
  36.     <form name="ediths" action="<?=$HTTP_SERVER_VARS['PHP_SELF']?>" method="POST">
  37.         <table cellpadding="0" cellspacing="0" width="909" class="rbsnormal">
  38.             <tr style="margin:0; padding:0;" align="left" valign="top" class="rbsnormal">
  39.                 <td width="154">
  40.                     RFPI&nbsp;&nbsp;&nbsp;
  41.                 </td>
  42.                 <td width="154">
  43.                     IP Address
  44.                 </td>
  45.                 <td width="69">
  46.                     Enrolment
  47.                 </td>
  48.                 <td width="65">
  49.                     Ciphering
  50.                 </td>
  51.                 <td width="96">
  52.                     TFTP FILE
  53.                 </td>
  54.                 <td width="96">
  55.                     Delete
  56.                 </td>
  57.                 </tr>
  58.     <?php
  59.     $counter=0;
  60.     $old_values=null;
  61.     while ($row = ibase_fetch_object($result_id)) {
  62.         $rfpi=$row->RBS_RFPI;
  63.         $ciphering=$row->RBS_CIPHERING;
  64.         $ipaddress=$row->RBS_IPADDRESS;
  65.         $enrolment=$row->RBS_ENROLMENT;
  66.         $tftpfile=$row->RBS_TFTPFILENAME;
  67.         
  68.     ?>
  69.             <tr style="margin:0; padding:0;" align="left" valign="top" class="rbsnormal">
  70.                 <td width="156" height="23">
  71.                     <input type="text" name="rfpi[<?=$counter?>]" value="<?=$rfpi?>">
  72.                 </td>
  73.                 <td width="154" height="23">
  74.                     <input type="text" name="ip_address[<?=$counter?>]" value="<?=$ipaddress?>">
  75.                 </td>
  76.                 <td width="69" height="23">
  77.                     <input type="checkbox" name="enrolment[<?=$counter?>]" value="1"<? if ($enrolment==1)echo "checked";?>>
  78.                 </td>
  79.                 <td width="65" height="23">
  80.                     <input type="checkbox" name="ciphering[<?=$counter?>]" value="1" <? if ($ciphering==1)echo "checked";?>>
  81.                 </td>
  82.                 <td width="156" height="23" align="left" valign="top">
  83.                     <input type="text" name="tftp_file[<?=$counter?>]" value="<?=$tftpfile?>">
  84.                 </td>
  85.                 <td width="65" height="23">
  86.                     <input type="checkbox" name="delete" value="<?=$counter?>">
  87.                 </td>
  88.                 </tr>
  89.         
  90.     <?php
  91.         
  92.         $old_values.='    <input type="hidden" name="id['.$counter.']" value="'.$row->RBS_ID.'">
  93.         ';
  94.         $counter++;
  95.     }
  96.     ?>
  97.         </table>
  98.         <?=$old_values?>
  99.         <input type="submit" name="submit" value="Update">
  100.         &nbsp;&nbsp;
  101.         <input type="hidden" value="Reset">
  102.     </form>
  103.     </body>
  104.     </html>

Reply With Quote
  #11  
Old September 4th, 2002, 02:14 PM
Nimco Nimco is offline
Codewalkers Newbie (0 - 499 posts)
  
Join Date: Apr 2007
Posts: 132 Nimco User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 3
Send a message via AIM to Nimco
RE: Deleting the records in a table
I'm really not sure then. If there is someone round here with a bit more Database experience than me they can probably help you - I've only been using MySQL for about 3 weeks... Makes me wonder how I've got a working search engine for the competition - just a bit more tweaking and it'll be done.
Reply With Quote
Reply

Viewing: Codewalkers Forums > PHP Related > PHP Coding > Deleting the records in a table

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump




 Free IT White Papers!
 
Create the Optimal Architecture for your Critical Applications
Warburton's the largest independently owned bakery in the UK faced a number of difficult challenges in providing the most robust yet efficient IT infrastructure for their organization's success. IBM's services combined with their xSeries servers created the perfect platform for their SAP environment with sufficient flexibility, and did so in very time effective fashion.
Request Your Free Technology Downloads!
 
Five Best Practices for Deploying a Successful Service-Oriented Architecture
This white paper describes the benefits you can expect with SOA, and how IBM can help take your business there.
Request Your Free Technology Downloads!
 
Gartner Magic Quadrant for Application Delivery Controllers
Gartner summarizes its view on Application Delivery Controllers, evaluates strengths and weaknesses of solutions, and provides Magic Quadrant reporting for a quick comparison across all vendors. Learn from Gartner how you can benefit from an all-in-one device like Citrix NetScaler that delivers the highest levels of availability, performance and security.
Request Your Free Technology Downloads!
 
Knowledge is Power
What you don't know can hurt you, and is likely costing you money and increasing your security risks during an era of scarce resources. This white paper proposes six key strategies that enterprise security managers can use to improve their network defense posture.
Request Your Free Technology Downloads!
 
Rationalizing the Multi-Tool Environment
The rationalized multi-tool approach is flexible, scalable and cost effective. It provides the necessary input to the IT service management business processes. It preserves prior investments in monitoring tools, empowers technologists to select the best tools with which to do their jobs, and enhances effective response to incidents.
Request Your Free Technology Downloads!
 

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 




© 2003-2010 by Developer Shed. All rights reserved. DS Cluster 11 Hosted by Hostway. 
For more Enterprise Application Development news, visit eWeek