help mi..

hazel999

Hi people

Can somebody tell me how to do this:
i have a list of dynamic item with checkbox beside each. And a delete button. I am able to delete from the database when i select the desired item to delete BUT... every time i delete 1 item, every thing goes away.....
I search from forum but no such problem seen.

Thanks in advance

thorpe

Post your code!

hazel999

okay, firstly i would like to know am i able to get the value for the software_version table 'ID' from this code??

$result4 = @mysql_query("select * from software_version left join version ON software_version.version_id = version.ID left join changelog ON software_version.ID = changelog.software_id where (changelog.software_id = '" . $SW . "')");

And this i used it to delete item

if (isset($_POST['delete']) && isset($_POST['checkbox'])){
					foreach ($_POST['checkbox'] as $dkey){
						$deletequery = mysql_query("DELETE FROM changelog WHERE ID='".$dkey."'");
						if($deletequery ){ 
						echo "<meta http-equiv=\"refresh\" content=\"0;URL=CL_changelog.php\">"; 
						} 
					}

			}

the checkbox statement:

echo '<TD><input name="checkbox[]" type=checkbox value='.$table['ID'].'></td>';

hazel999

someone told mi that isset does not work on checkbox. But not too sure how the procedure for checkbox goes. example the values and all. excuse me for asking stupid question, this is my first time using a checkbox.

kakki

you can name the checkboxes and check, whether there is a letter in
$_REQUEST[ 'checkboxname'.$checkboxId ] ( ->CHECKED ) or its empty ( ->NOT CHECKED )
if you name the boxes checkbox[], then youll get an array, which doesnt hold the correct
id-values.
(maybe i didnt make myself clear in the first place )
glhf....

kakki

OR you can do sth like:

echo '<TD><input name="checkbox['.$table['ID'].']" type=checkbox value="'.$table['ID'].'"></td>';

hazel999

Hi Kakki,
Do you have any idea why whenever i select 1 item from checkbox and click on delete, everything will go away?? i have to restart from the beginning then the latest data would display. do you know why? anyone out there knows?? i just cannot solve this thing
Any idea what causes this to happen??

kakki

maybe the $POST is correctly filled,
what about that: (checkbox)

echo '<TD><input name="checkbox_'.$table['ID'].'" type="checkbox"></td>';

and ( delete )

if (isset($_POST['delete']) && isset($_POST['checkbox'])){
                    foreach ($_POST as $item => $value){
if ( ( ereg( '^checkbox', $item ) && eregi( '[a-z]', $value ) )
{
$dkey=ereg_replace( 'checkbox_', $item );
$deletequery = mysql_query("DELETE FROM changelog WHERE ID='".$dkey."'");
}
                        if($deletequery ){
                        echo "<meta http-equiv=\"refresh\" content=\"0;URL=CL_changelog.php\">";
                        }
                    }

            }