how to update and delete data using mysql query

Question

unwanted_virus 0 Newbie Poster

14 Years Ago

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>::SISTEM SEMAKAN KEPUTUSAN PEPERIKSAAN KOLEJ EASTERN::</title>
<style type="text/css">
<!--
.style7 {color: #000000; font-weight: bold; }
.style8 {color: #000000}
body {
	background-image: url(eastern1.jpg);
}
.style10 {color: #FF0000}
.style9 {color: #FF0000;
	font-weight: bold;
	font-style: italic;
	font-size: large;
}
-->
</style>
</head>

<body>
<form id="form1" name="form1" onSubmit="return checkban()" method="post" action="proses_transkrip.php">
  <p align="center"><span class="style9">
    <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="105" height="23">
      <param name="BGCOLOR" value="" />
      <param name="movie" value="button3.swf" />
      <param name="quality" value="high" />
      <embed src="button3.swf" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="105" height="23" ></embed>
    </object>
    <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="105" height="23">
      <param name="BGCOLOR" value="" />
      <param name="movie" value="button8.swf" />
      <param name="quality" value="high" />
      <embed src="button8.swf" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="105" height="23" ></embed>
    </object>
    <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="105" height="23">
      <param name="BGCOLOR" value="" />
      <param name="movie" value="button9.swf" />
      <param name="quality" value="high" />
      <embed src="button9.swf" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="105" height="23" ></embed>
    </object>
    <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="105" height="23">
      <param name="BGCOLOR" value="" />
      <param name="movie" value="button10.swf" />
      <param name="quality" value="high" />
      <embed src="button10.swf" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="105" height="23" ></embed>
    </object>
  </span></p>
  <table width="521" height="394" border="1" align="center">
    <tr>
      <th height="100" colspan="2" scope="row"><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="700" height="96">
        <param name="movie" value="Mak_pel.swf" />
        <param name="quality" value="high" />
        <embed src="Mak_pel.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="700" height="96"></embed>
      </object></th>
    </tr>
    <tr>
      <th width="96" scope="row"><div align="left">Nama</div></th>
      <td width="640"><input name="nama" type="text" id="nama" size="50" />
      <span class="style10">      *</span></td>
    </tr>
    <tr>
      <th scope="row"><div align="left">No. KP</div></th>
      <td><input name="no_kp" type="text" id="no_kp" maxlength="12" />
        <span class="style10">* </span><strong>900117125171 </strong><span class="style10"></span></td>
	   <script language="JavaScript1.2">
/*Number check script-
By JavaScript Kit ([url]www.javascriptkit.com[/url])
Over 200 free scripts here!
*/

function checknumber(){
var x=document.form1.no_kp.value
var anum=/(^\d+$)|(^\d+\.\d+$)/
if (anum.test(x))
testresult=true
else{
alert("Please input the blank field and insert a valid number!")
testresult=false
}
return (testresult)
}

    </script>
    <script>
function checkban(){
if (document.layers||document.all||document.getElementById)
return checknumber()
else
return true
}
    </script>
    </tr>
    <tr>
      <th scope="row"><div align="left">No. Matrik </div></th>
      <td><input name="no_matrik" type="text" id="no_matrik" maxlength="18" />
      <span class="style10">      * </span><strong>DTM-EC201-0154 </strong><span class="style10"></span></td>
    </tr>
    <tr>
      <th scope="row"><div align="left">Alamat</div></th>
      <td><textarea name="alamat" rows="5" id="alamat"></textarea></td>
    </tr>
    <tr>
      <th scope="row"><div align="left">Program</div></th>
      <td><select name="program" id="program">
        <option selected="selected">Select</option>
        <option>DIPLOMA TEKNOLOGI MAKLUMAT</option>
        <option>DIPLOMA PENGURUSAN PERNIAGAAN</option>
        <option>SIJIL TEKNOLOGI MAKLUMAT</option>
        <option>SIJIL SAINS KOMPUTER</option>
      </select>      </td>
    </tr>
    <tr>
      <th scope="row"><div align="left">Semester</div></th>
      <td><select name="semester" size="1" id="semester">
        <option selected="selected">Select</option>
        <option>1</option>
        <option>2</option>
        <option>3</option>
        <option>4</option>
        <option>5</option>
        <option>6</option>
        <option>7</option>
        <option>Lain-Lain</option>
      </select></td>
    </tr>
    <tr>
      <th height="26" scope="row"><div align="left">Sesi</div></th>
      <td><input name="sesi" type="text" id="sesi" /></td>
    </tr>
  </table>
  <p>&nbsp;</p>
  <table width="679" border="1" align="center">
    <tr>
      <th colspan="7" scope="row"><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="700" height="96">
        <param name="movie" value="mak_exam.swf" />
        <param name="quality" value="high" />
        <embed src="mak_exam.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="700" height="96"></embed>
      </object></th>
    </tr>
    <tr>
      <th width="33" scope="row"><font size="2">BIL</font></th>
      <td width="75"><div align="center"><strong><font size="2">Kod Subjek </font></strong></div></td>
      <td width="284"><div align="center"><strong>Subjek</strong></div></td>
      <td width="38"><strong><font size="2">Kredit</font></strong></td>
      <td width="80"><div align="center"><strong><font size="2">Gred</font></strong></div></td>
      <td width="63"><div align="center"><strong><font size="2">Mata Nilai </font></strong></div></td>
      <td width="60"><div align="left"><strong><font size="2">Jum Mata </font></strong></div></td>
    </tr>
    <tr>
      <th height="158" scope="row"><div align="center">
        <p align="left">
          <select name="bil" id="bil">
            <option>1</option>
            <option>2</option>
            <option>3</option>
            <option>4</option>
            <option>5</option>
            <option>6</option>
            <option>7</option>
          </select>
          <select name="bil2" id="bil2">
            <option>1</option>
            <option>2</option>
            <option>3</option>
            <option>4</option>
            <option>5</option>
            <option>6</option>
            <option>7</option>
          </select>
          <select name="bil3" id="bil3">
            <option>1</option>
            <option>2</option>
            <option>3</option>
            <option>4</option>
            <option>5</option>
            <option>6</option>
            <option>7</option>
          </select>
          <select name="bil4" id="bil4">
            <option>1</option>
            <option>2</option>
            <option>3</option>
            <option>4</option>
            <option>5</option>
            <option>6</option>
            <option>7</option>
          </select>
          <select name="bil5" id="bil5">
            <option>1</option>
            <option>2</option>
            <option>3</option>
            <option>4</option>
            <option>5</option>
            <option>6</option>
            <option>7</option>
          </select>
          <select name="bil6" id="bil6">
            <option>1</option>
            <option>2</option>
            <option>3</option>
            <option>4</option>
            <option>5</option>
            <option>6</option>
            <option>7</option>
          </select>
          <select name="bil7" id="bil7">
            <option>1</option>
            <option>2</option>
            <option>3</option>
            <option>4</option>
            <option>5</option>
            <option>6</option>
            <option>7</option>
          </select>
        </p>
        </div></th>
			   <script language="JavaScript1.2">
/*Number check script-
By JavaScript Kit ([url]www.javascriptkit.com[/url])
Over 200 free scripts here!
*/

function checknumber(){
var x=document.form1.bil.value
var x=document.form1.bil2.value
var x=document.form1.bil3.value
var x=document.form1.bil4.value
var x=document.form1.bil5.value
var x=document.form1.bil6.value
var x=document.form1.bil7.value
var anum=/(^\d+$)|(^\d+\.\d+$)/
if (anum.test(x))
testresult=true
else{
alert("Please input the blank field and insert a valid number!")
testresult=false
}
return (testresult)
}

    </script>
    <script>
function checkban(){
if (document.layers||document.all||document.getElementById)
return checknumber()
else
return true
}
    </script>
      <td><div align="center">
        <p align="left">
          <input name="kod_subjek" type="text" id="kod_subjek" size="12" />
          <input name="kod_subjek2" type="text" id="kod_subjek2" size="12" />
          <input name="kod_subjek3" type="text" id="kod_subjek3" size="12" />
          <input name="kod_subjek4" type="text" id="kod_subjek4" size="12" />
          <input name="kod_subjek5" type="text" id="kod_subjek5" size="12" />
          <input name="kod_subjek6" type="text" id="kod_subjek6" size="12" />
          <input name="kod_subjek7" type="text" id="kod_subjek7" size="12" /></p>
        </div></td>
      <td><div align="center">
        <p align="left"><select name="subjek" id="subjek">
            <option selected="selected">Select</option>
            <option>PENGENALAN KEPADA PENGATURCARAAN</option>
            <option>ENGLISH FOR ACADEMIC PURPOSES I</option>
            <option>PENGENALAN PENGURUSAN PERBIAGAAN</option>
            <option>MATEMATIK DISKRIT</option>
            <option>PENGATURCARAAN VISUAL BASIC</option>
            <option>KOMUNIKASI PERNIAGAAN</option>
            <option>STATISTIK</option>
            <option>ETIKA DALAM PENGKOMPUTERAN</option>
            <option>SISTEM DAN ORGANISASI KOMPUTER</option>
            <option>PEMBANGUNAN MULTIMEDIA</option>
            <option>PENGURUSAN PANGKALAN DATA</option>
            <option>ANALISIS DAN REKABENTUK SISTEM</option>
            <option>E-PENTADBIRAN</option>
            <option>SISTEM MAKLUMAT PENGURUSAN</option>
            <option>PENGATURCARAAN INTERNET</option>
            <option>PROJEK TEKNOLOGI MAKLUMAT</option>
            </select>
          <select name="subjek2" id="subjek2">
            <option selected="selected">Select</option>
            <option>PENGENALAN KEPADA PENGATURCARAAN</option>
            <option>ENGLISH FOR ACADEMIC PURPOSES I</option>
            <option>PENGENALAN PENGURUSAN PERBIAGAAN</option>
            <option>MATEMATIK DISKRIT</option>
            <option>PENGATURCARAAN VISUAL BASIC</option>
            <option>KOMUNIKASI PERNIAGAAN</option>
            <option>STATISTIK</option>
            <option>ETIKA DALAM PENGKOMPUTERAN</option>
            <option>SISTEM DAN ORGANISASI KOMPUTER</option>
            <option>PEMBANGUNAN MULTIMEDIA</option>
            <option>PENGURUSAN PANGKALAN DATA</option>
            <option>ANALISIS DAN REKABENTUK SISTEM</option>
            <option>E-PENTADBIRAN</option>
            <option>SISTEM MAKLUMAT PENGURUSAN</option>
            <option>PENGATURCARAAN INTERNET</option>
            <option>PROJEK TEKNOLOGI MAKLUMAT</option>
            </select>
          <select name="subjek3" id="subjek3">
            <option selected="selected">Select</option>
            <option>PENGENALAN KEPADA PENGATURCARAAN</option>
            <option>ENGLISH FOR ACADEMIC PURPOSES I</option>
            <option>PENGENALAN PENGURUSAN PERBIAGAAN</option>
            <option>MATEMATIK DISKRIT</option>
            <option>PENGATURCARAAN VISUAL BASIC</option>
            <option>KOMUNIKASI PERNIAGAAN</option>
            <option>STATISTIK</option>
            <option>ETIKA DALAM PENGKOMPUTERAN</option>
            <option>SISTEM DAN ORGANISASI KOMPUTER</option>
            <option>PEMBANGUNAN MULTIMEDIA</option>
            <option>PENGURUSAN PANGKALAN DATA</option>
            <option>ANALISIS DAN REKABENTUK SISTEM</option>
            <option>E-PENTADBIRAN</option>
            <option>SISTEM MAKLUMAT PENGURUSAN</option>
            <option>PENGATURCARAAN INTERNET</option>
            <option>PROJEK TEKNOLOGI MAKLUMAT</option>
            </select>
          <select name="subjek4" id="subjek4">
            <option selected="selected">Select</option>
            <option>PENGENALAN KEPADA PENGATURCARAAN</option>
            <option>ENGLISH FOR ACADEMIC PURPOSES I</option>
            <option>PENGENALAN PENGURUSAN PERBIAGAAN</option>
            <option>MATEMATIK DISKRIT</option>
            <option>PENGATURCARAAN VISUAL BASIC</option>
            <option>KOMUNIKASI PERNIAGAAN</option>
            <option>STATISTIK</option>
            <option>ETIKA DALAM PENGKOMPUTERAN</option>
            <option>SISTEM DAN ORGANISASI KOMPUTER</option>
            <option>PEMBANGUNAN MULTIMEDIA</option>
            <option>PENGURUSAN PANGKALAN DATA</option>
            <option>ANALISIS DAN REKABENTUK SISTEM</option>
            <option>E-PENTADBIRAN</option>
            <option>SISTEM MAKLUMAT PENGURUSAN</option>
            <option>PENGATURCARAAN INTERNET</option>
            <option>PROJEK TEKNOLOGI MAKLUMAT</option>
            </select>
          <select name="subjek5" id="subjek5">
            <option selected="selected">Select</option>
            <option>PENGENALAN KEPADA PENGATURCARAAN</option>
            <option>ENGLISH FOR ACADEMIC PURPOSES I</option>
            <option>PENGENALAN PENGURUSAN PERBIAGAAN</option>
            <option>MATEMATIK DISKRIT</option>
            <option>PENGATURCARAAN VISUAL BASIC</option>
            <option>KOMUNIKASI PERNIAGAAN</option>
            <option>STATISTIK</option>
            <option>ETIKA DALAM PENGKOMPUTERAN</option>
            <option>SISTEM DAN ORGANISASI KOMPUTER</option>
            <option>PEMBANGUNAN MULTIMEDIA</option>
            <option>PENGURUSAN PANGKALAN DATA</option>
            <option>ANALISIS DAN REKABENTUK SISTEM</option>
            <option>E-PENTADBIRAN</option>
            <option>SISTEM MAKLUMAT PENGURUSAN</option>
            <option>PENGATURCARAAN INTERNET</option>
            <option>PROJEK TEKNOLOGI MAKLUMAT</option>
            </select>
          <select name="subjek6" id="subjek6">
            <option selected="selected">Select</option>
            <option>PENGENALAN KEPADA PENGATURCARAAN</option>
            <option>ENGLISH FOR ACADEMIC PURPOSES I</option>
            <option>PENGENALAN PENGURUSAN PERBIAGAAN</option>
            <option>MATEMATIK DISKRIT</option>
            <option>PENGATURCARAAN VISUAL BASIC</option>
            <option>KOMUNIKASI PERNIAGAAN</option>
            <option>STATISTIK</option>
            <option>ETIKA DALAM PENGKOMPUTERAN</option>
            <option>SISTEM DAN ORGANISASI KOMPUTER</option>
            <option>PEMBANGUNAN MULTIMEDIA</option>
            <option>PENGURUSAN PANGKALAN DATA</option>
            <option>ANALISIS DAN REKABENTUK SISTEM</option>
            <option>E-PENTADBIRAN</option>
            <option>SISTEM MAKLUMAT PENGURUSAN</option>
            <option>PENGATURCARAAN INTERNET</option>
            <option>PROJEK TEKNOLOGI MAKLUMAT</option>
            </select>
          <select name="subjek7" id="subjek7">
            <option selected="selected">Select</option>
            <option>PENGENALAN KEPADA PENGATURCARAAN</option>
            <option>ENGLISH FOR ACADEMIC PURPOSES I</option>
            <option>PENGENALAN PENGURUSAN PERBIAGAAN</option>
            <option>MATEMATIK DISKRIT</option>
            <option>PENGATURCARAAN VISUAL BASIC</option>
            <option>KOMUNIKASI PERNIAGAAN</option>
            <option>STATISTIK</option>
            <option>ETIKA DALAM PENGKOMPUTERAN</option>
            <option>SISTEM DAN ORGANISASI KOMPUTER</option>
            <option>PEMBANGUNAN MULTIMEDIA</option>
            <option>PENGURUSAN PANGKALAN DATA</option>
            <option>ANALISIS DAN REKABENTUK SISTEM</option>
            <option>E-PENTADBIRAN</option>
            <option>SISTEM MAKLUMAT PENGURUSAN</option>
            <option>PENGATURCARAAN INTERNET</option>
            <option>PROJEK TEKNOLOGI MAKLUMAT</option>
            </select>
</p>
        </div></td>
      <td><div align="center">
        <p align="left">
          <input name="jam_kredit" type="text" id="jam_kredit" size="5" />
          <input name="jam_kredit2" type="text" id="jam_kredit2" size="5" />
          <input name="jam_kredit3" type="text" id="jam_kredit3" size="5" />

          <input name="jam_kredit4" type="text" id="jam_kredit4" size="5" />

          <input name="jam_kredit5" type="text" id="jam_kredit5" size="5" />
          <input name="jam_kredit6" type="text" id="jam_kredit6" size="5" />
          <input name="jam_kredit7" type="text" id="jam_kredit7" size="5" />
</p>
      </div></td>
	   <script language="JavaScript1.2">
/*Number check script-
By JavaScript Kit ([url]www.javascriptkit.com[/url])
Over 200 free scripts here!
*/

function checknumber(){
var x=document.form1.jam_kredit.value
var x=document.form1.jam_kredit2.value
var x=document.form1.jam_kredit3.value
var x=document.form1.jam_kredit4.value
var x=document.form1.jam_kredit5.value
var x=document.form1.jam_kredit6.value
var x=document.form1.jam_kredit7.value
var anum=/(^\d+$)|(^\d+\.\d+$)/
if (anum.test(x))
testresult=true
else{
alert("Please input the blank field and insert a valid number!")
testresult=false
}
return (testresult)
}

    </script>
    <script>
function checkban(){
if (document.layers||document.all||document.getElementById)
return checknumber()
else
return true
}
    </script>
      <td><div align="center">
        <p align="left">
          <select name="gred"  id="Gred" onchange="DisplayGred(this.value)">
            <option>Select </option> 
            <option value="A">A </option>
            <option value="A-">A- </option>
            <option value="B+">B+ </option>
            <option value="B">B </option>
            <option value="B-">B- </option>
            <option value="C+">C+ </option>
            <option value="C">C </option>
            <option value="C-">C- </option> 
            <option value="D">D </option>
            <option value="F">F </option>
          </select>
          <select name="gred2"  id="gred2" onchange="DisplayGred(this.value)">
            <option>Select </option>
            <option value="A">A </option>
            <option value="A">A- </option>
            <option value="B+">B+ </option>
            <option value="B">B </option>
            <option value="B-">B- </option>
            <option value="C+">C+ </option>
            <option value="C">C </option>
            <option value="C-">C- </option>
            <option value="D">D </option>
            <option value="F">F </option>
          </select>    
          <select name="gred3"  id="gred3" onchange="DisplayGred(this.value)">
            <option>Select </option>
            <option value="A">A </option>
            <option value="A">A- </option>
            <option value="B+">B+ </option>
            <option value="B">B </option>
            <option value="B-">B- </option>
            <option value="C+">C+ </option>
            <option value="C">C </option>
            <option value="C-">C- </option>
            <option value="D">D </option>
            <option value="F">F </option>
          </select>    
          <select name="gred4"  id="gred4" onchange="DisplayGred(this.value)">
            <option>Select </option>
            <option value="A">A </option>
            <option value="A">A- </option>
            <option value="B+">B+ </option>
            <option value="B">B </option>
            <option value="B-">B- </option>
            <option value="C+">C+ </option>
            <option value="C">C </option>
            <option value="C-">C- </option>
            <option value="D">D </option>
            <option value="F">F </option>
          </select>    
          <select name="gred5"  id="gred5" onchange="DisplayGred(this.value)">
            <option>Select </option>
            <option value="A">A </option>
            <option value="A">A- </option>
            <option value="B+">B+ </option>
            <option value="B">B </option>
            <option value="B-">B- </option>
            <option value="C+">C+ </option>
            <option value="C">C </option>
            <option value="C-">C- </option>
            <option value="D">D </option>
            <option value="F">F </option>
          </select>    
          <select name="gred6"  id="gred6" onchange="DisplayGred(this.value)">
            <option>Select </option>
            <option value="A">A </option>
            <option value="A">A- </option>
            <option value="B+">B+ </option>
            <option value="B">B </option>
            <option value="B-">B- </option>
            <option value="C+">C+ </option>
            <option value="C">C </option>
            <option value="C-">C- </option>
            <option value="D">D </option>
            <option value="F">F </option>
          </select>    
          <select name="gred7"  id="gred7" onchange="DisplayGred(this.value)">
            <option>Select </option>
            <option value="A">A </option>
            <option value="A">A- </option>
            <option value="B+">B+ </option>
            <option value="B">B </option>
            <option value="B-">B- </option>
            <option value="C+">C+ </option>
            <option value="C">C </option>
            <option value="C-">C- </option>
            <option value="D">D </option>
            <option value="F">F </option>
          </select>
        </p>
        </div></td>
      <td>
        <div align="left">
          <select name="mata_nilai" id="mata_nilai">
            <option selected="selected">0.00</option>
            <option>1.00</option>
            <option>1.67</option>
            <option>2.00</option>
            <option>2.33</option>
            <option>2.67</option>
            <option>3.00</option>
            <option>3.33</option>
            <option>3.67</option>
            <option>4.00</option>
          </select>
          <select name="mata_nilai2" id="mata_nilai2">
            <option>0.00</option>
            <option>1.00</option>
            <option>1.67</option>
            <option>2.00</option>
            <option>2.33</option>
            <option>2.67</option>
            <option>3.00</option>
            <option>3.33</option>
            <option>3.67</option>
            <option>4.00</option>
          </select>
          <select name="mata_nilai3" id="mata_nilai3">
            <option>0.00</option>
            <option>1.00</option>
            <option>1.67</option>
            <option>2.00</option>
            <option>2.33</option>
            <option>2.67</option>
            <option>3.00</option>
            <option>3.33</option>
            <option>3.67</option>
            <option>4.00</option>
          </select>
          <select name="mata_nilai4" id="mata_nilai4">
            <option>0.00</option>
            <option>1.00</option>
            <option>1.67</option>
            <option>2.00</option>
            <option>2.33</option>
            <option>2.67</option>
            <option>3.00</option>
            <option>3.33</option>
            <option>3.67</option>
            <option>4.00</option>
          </select>
          <select name="mata_nilai5" id="mata_nilai5">
            <option>0.00</option>
            <option>1.00</option>
            <option>1.67</option>
            <option>2.00</option>
            <option>2.33</option>
            <option>2.67</option>
            <option>3.00</option>
            <option>3.33</option>
            <option>3.67</option>
            <option>4.00</option>
          </select>
          <select name="mata_nilai6" id="mata_nilai6">
            <option>0.00</option>
            <option>1.00</option>
            <option>1.67</option>
            <option>2.00</option>
            <option>2.33</option>
            <option>2.67</option>
            <option>3.00</option>
            <option>3.33</option>
            <option>3.67</option>
            <option>4.00</option>
          </select>
          <select name="mata_nilai7" id="mata_nilai7">
            <option>0.00</option>
            <option>1.00</option>
            <option>1.67</option>
            <option>2.00</option>
            <option>2.33</option>
            <option>2.67</option>
            <option>3.00</option>
            <option>3.33</option>
            <option>3.67</option>
            <option>4.00</option>
          </select>
        </div></td>
			   <script language="JavaScript1.2">
/*Number check script-
By JavaScript Kit ([url]www.javascriptkit.com[/url])
Over 200 free scripts here!
*/

function checknumber(){
var x=document.form1.mata_nilai.value
var x=document.form1.mata_nilai2.value
var x=document.form1.mata_nilai3.value
var x=document.form1.mata_nilai4.value
var x=document.form1.mata_nilai5.value
var x=document.form1.mata_nilai6.value
var x=document.form1.mata_nilai7.value
var anum=/(^\d+$)|(^\d+\.\d+$)/
if (anum.test(x))
testresult=true
else{
alert("Please input the blank field and insert a valid number!")
testresult=false
}
return (testresult)
}

    </script>
    <script>
function checkban(){
if (document.layers||document.all||document.getElementById)
return checknumber()
else
return true
}
    </script>
      <td>
        <div align="left">
          <input name="jum_mata" type="text" id="jum_mata" size="10" />
          <input name="jum_mata2" type="text" id="jum_mata2" size="10" />
          <input name="jum_mata3" type="text" id="jum_mata3" size="10" />
          <input name="jum_mata4" type="text" id="jum_mata4" size="10" />
          <input name="jum_mata5" type="text" id="jum_mata5" size="10" />
          <input name="jum_mata6" type="text" id="jum_mata6" size="10" />
          <input name="jum_mata7" type="text" id="jum_mata7" size="10" />
        </div></td>
			   <script language="JavaScript1.2">
/*Number check script-
By JavaScript Kit ([url]www.javascriptkit.com[/url])
Over 200 free scripts here!
*/

function checknumber(){
var x=document.form1.jum_mata.value
var x=document.form1.jum_mata2.value
var x=document.form1.jum_mata3.value
var x=document.form1.jum_mata4.value
var x=document.form1.jum_mata5.value
var x=document.form1.jum_mata6.value
var x=document.form1.jum_mata7.value
var anum=/(^\d+$)|(^\d+\.\d+$)/
if (anum.test(x))
testresult=true
else{
alert("Please input the blank field and insert a valid number!")
testresult=false
}
return (testresult)
}

    </script>
    <script>
function checkban(){
if (document.layers||document.all||document.getElementById)
return checknumber()
else
return true
}
    </script>
    </tr>
  </table>
  <p>&nbsp;</p>
  <table width="486" border="1" align="center">
    <tr>
      <th width="52" scope="row"><div align="center"><span class="style8">Jumlah Kredit </span></div></th>
      <td width="77"><div align="center"><span class="style7">Jumlah Kredit Terkumpul </span></div></td>
      <td width="52"><div align="center"><span class="style7">Jumlah Mata Nilai </span></div></td>
      <td width="73"><div align="center"><span class="style7">Jumlah Mata Nilai Terkumpul</span></div></td>
      <td width="48"><div align="center"><span class="style7">PNG</span></div></td>
      <td width="48"><div align="center"><span class="style7">PNGK</span></div></td>
      <td width="90"><div align="center"><span class="style7">Kedudukan</span></div></td>
    </tr>
    <tr>
      <th height="26" scope="row"><div align="center">
        <input name="jumlah_kredit" type="text" id="jumlah_kredit" size="8" />
      </div></th>
      <td><div align="center">
        <input name="kredit_terkumpul" type="text" id="kredit_terkumpul" size="8" />
      </div></td>
      <td><div align="center">
        <input name="jum_nilai" type="text" id="jum_nilai" size="8" />
      </div></td>
      <td><div align="center">
        <input name="nilai_terkumpul" type="text" id="nilai_terkumpul" size="8" />
      </div></td>
      <td><div align="center">
        <input name="png" type="text" id="png" size="8" />
      </div></td>
      <td><div align="center">
        <input name="pngk" type="text" id="pngk" size="8" />
      </div></td>
	  	   <script language="JavaScript1.2">
/*Number check script-
By JavaScript Kit ([url]www.javascriptkit.com[/url])
Over 200 free scripts here!
*/

function checknumber(){
var x=document.form1.jumlah_kredit.value
var x=document.form1.kredit_terkumpul.value
var x=document.form1.jum_nilai.value
var x=document.form1.nilai_terkumpul.value
var x=document.form1.png.value
var x=document.form1.pngk.value
var anum=/(^\d+$)|(^\d+\.\d+$)/
if (anum.test(x))
testresult=true
else{
alert("Please input the blank field and insert a valid number!")
testresult=false
}
return (testresult)
}

    </script>
    <script>
function checkban(){
if (document.layers||document.all||document.getElementById)
return checknumber()
else
return true
}
    </script>
      <td><div align="center">
        <input name="kedudukan" type="text" id="kedudukan" size="15" />
      </div></td>
    </tr>
  </table>
  <p>&nbsp;</p>
  <p align="center"><input type="submit" name="Submit" value="Hantar" />
    <input type="submit" name="Submit3" value="Edit" />
    <input type="submit" name="Submit4" onclick="alert ('Maklumat Anda Telah Dikemaskini')" value="Simpan" />
    <input type="reset" name="Submit2" value="Reset" />
    <a href="delete_record.php"><input type="submit" name="Submit5" value="Padam" /><? echo $rows['no_matrik']; ?>delete</a> </p>
</form>
</body>
</html>

php

Edited 14 Years Ago by peter_budo because: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks)

3 Contributors
2 Replies
99 Views
17 Hours Discussion Span
Latest Post 14 Years Ago Latest Post by Will Gresham

All 2 Replies

kekkaishi 18 Junior Poster

14 Years Ago

come on man, there's no way someone can go thru all ur codes to understand ur problem. in light of the title, check out these links.

http://www.tizag.com/mysqlTutorial/mysqlupdate.php
http://www.tizag.com/mysqlTutorial/mysqldelete.php
OR
http://www.w3schools.com/php/php_mysql_update.asp
http://www.w3schools.com/php/php_mysql_delete.asp
OR
http://dev.mysql.com/doc/refman/5.0/en/update.html
http://dev.mysql.com/doc/refman/5.0/en/delete.html

good luck.

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

Will Gresham 81 Master Poster · Answer 1 · 2009-10-26T05:33:38+00:00

The only PHP code I can find in your post is this on line 777: <? echo $rows['no_matrik']; ?> Please post what the problem is, as well as the relevant code.

how to update and delete data using mysql query

Recommended Answers Collapse Answers

All 2 Replies

Recommended Answers