displaying query

hazel999

Hi all,

I have a textarea with a submit button below, and a few datas with checkbox below the submit button, and below all of that had a delete button. Got a problem that whenever i add entries and click on submit, initially the datas with checkbox was there but after i click on submit button, the datas are gone AND new entries does not display into the page. can someone pls help mi with it? been trying it for a few days.. :queasy:

thorpe

Posting code helps!!!!

hazel999

sure..
I use this to delete the checked datas:

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\">"; 
	} 
}

And this to add new entries:

if (isset($_POST['submitcl'])){
 $akey = mysql_query("insert into changelog (software_id, change_log) values     ('$SW', '" .$_POST['changelog']. "')");
	if (!$akey){
	    die ('Can\'t use : ' . mysql_error());
	}else {
   echo "<meta http-equiv=\"refresh\" content=\"0;URL=CL_changelog.php\">"; 
	} 
  }

i could not get the new entries to display after clicking on submit, furthermore, it remove my datas away also. i can post more info if you need. because i do not know where the problem lies.. :o

hazel999

The $SW in adding entry i get it from the previous page where user had to choose an item. i want to add entry into the table where the id is equal to the item that user had selected. umm so, at the previous page i used a joining of 3 tables. which is:

$q=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 (version.product_id = '" . $FID . "')");

the $SW value is from changelog.software_id, But, how can i make it to take the ID from software table instead of the connected value from changelog??? i tried to use var=$line['software_version.ID']; but not working. does that mean that my joining of tables are wrong??

IF there are no datas in changelog table(which include the var $SW), then when user add entry, no sub_id is added to it, because it did not even read the value from the previous page.

hmm... i hope i do explain it clearly... thought its abit confusing...