RE: [PHP-DB] Deleting from a select list ? :-(
Dave, First, you need a "SELECT" tags. print ""; $deloptions_sql = "select * from $tbn2"; $delresult = mysql_query($deloptions_sql, $con) or die("error:".mysql_error()); while ($listdelrows = mysql_fetch_array($delresult) ){ $name2 = $listdelrows[name]; $id2 = $listdelrows[id]; $del_list .="$name2"; } print ""; Second, are you trying to do the above and this in one script? if($delproduct){ $del_sql ="delete from $tbn2 where id = '$id2' and name ='$name2'"; $del_res = mysql_query($del_sql,$con) or die ("Unable to Delete Product"); $delproductmsg = "Deleted $name2 from $p_cat_name"; } if so, you need some more structure... Show more of your script instead of what YOU think we ought to see. You have left out big chunks. I promise, we won't steal your coding for our own nefarious uses rick -Original Message----- From: Dave Carrera [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 11:04 AM To: php List Subject: [PHP-DB] Deleting from a select list ? :-( Hi All, I have this code creating a list in a select box. All works ok, I get my list BUT and a NIG BUT. When I select an item to delete it only ever deletes from the last record to the top. Err why ? I think all my code is in the right order but obviously not. Can anyone throw some light on this. As always thanks for past and future help Dave C :-) --MY CODE STARTS HERE --- $deloptions_sql = "select * from $tbn2"; $delresult = mysql_query($deloptions_sql, $con) or die("error: ".mysql_error()); $delrows = mysql_num_rows($delresult); for ($i = 0; $i < $delrows; $i++) { $listdelrows = mysql_fetch_array($delresult); $name2 = $listdelrows[name]; $id2 = $listdelrows[id]; $del_list .="$name2"; } if($delproduct){ $del_sql ="delete from $tbn2 where id = '$id2' and name ='$name2'"; $del_res = mysql_query($del_sql,$con) or die ("Unable to Delete Product"); $delproductmsg = "Deleted $name2 from $p_cat_name"; } --ENDS HERE--- Dave Carrera Website Designer http://www.davecarrera.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Deleting from a select list ? :-(
Is all of this code on one page or do you have the select part on a form on one page and the delete on another page? If this is all on one page, then it would only delete the last record because that was the last value of $id2 after the loop to fill the drop down. In order to select a certain record to delete, you will need to select the item from the drop down list and then submit it to another page to do the delete. HTH Maureen Biorn Dave Carrera <[EMAIL PROTECTED]> said: > Hi All, > I have this code creating a list in a select box. > > All works ok, I get my list BUT and a NIG BUT. > > When I select an item to delete it only ever deletes from the last > record to the top. > > Err why ? > > I think all my code is in the right order but obviously not. > > Can anyone throw some light on this. > > As always thanks for past and future help > > Dave C :-) > > --MY CODE STARTS HERE --- > > $deloptions_sql = "select * from $tbn2"; > $delresult = mysql_query($deloptions_sql, $con) or die("error: > ".mysql_error()); > $delrows = mysql_num_rows($delresult); > for ($i = 0; $i < $delrows; $i++) { > $listdelrows = mysql_fetch_array($delresult); > $name2 = $listdelrows[name]; > $id2 = $listdelrows[id]; > $del_list .=" value="$id2">$name2"; > } > > if($delproduct){ > $del_sql ="delete from $tbn2 where id = '$id2' and name = > '$name2'"; > $del_res = mysql_query($del_sql,$con) or die ("Unable to Delete > Product"); > $delproductmsg = "Deleted $name2 from $p_cat_name"; > } > --ENDS HERE--- > Dave Carrera > Website Designer > http://www.davecarrera.com > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Deleting from a select list ? :-(
Hi All, I have this code creating a list in a select box. All works ok, I get my list BUT and a NIG BUT. When I select an item to delete it only ever deletes from the last record to the top. Err why ? I think all my code is in the right order but obviously not. Can anyone throw some light on this. As always thanks for past and future help Dave C :-) --MY CODE STARTS HERE --- $deloptions_sql = "select * from $tbn2"; $delresult = mysql_query($deloptions_sql, $con) or die("error: ".mysql_error()); $delrows = mysql_num_rows($delresult); for ($i = 0; $i < $delrows; $i++) { $listdelrows = mysql_fetch_array($delresult); $name2 = $listdelrows[name]; $id2 = $listdelrows[id]; $del_list .="$name2"; } if($delproduct){ $del_sql ="delete from $tbn2 where id = '$id2' and name = '$name2'"; $del_res = mysql_query($del_sql,$con) or die ("Unable to Delete Product"); $delproductmsg = "Deleted $name2 from $p_cat_name"; } --ENDS HERE--- Dave Carrera Website Designer http://www.davecarrera.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php