this is my prosedure....
1st. I'm, selecting base on std_nis=111 in
STY_RANK_200501
2nd. looping and fetching echoing
---- looping and fetching echoing----
while ($nline = mysql_fetch_array($result)) {
echo $nline["std_value"]
echo $nline["std_item"]
}
----- end looping and fetching echoing -----
3rd. result of 2nd stage is
----- result---------
std_nis std_class std_item std_value
111 1 1 8 -----1st row
111 1 2 7 -----2nd row
111 1 5 6 -----3rd row
111 1 4 9 -----4th row
----end result-------
4th. updating
the page(web page) is show like this with new value
commnent
---start web page view -------
Update Student Value for Student NIS 111 in Class 1
Study(define as std_item) Value(define as std_value)
1 7 <-------this new
value
2 4 <-------this new
value
5 9 <-------this new
value
4 10 <-------this new
value
Submit Reset
---end web page view--------
so the new value will update the old value of each
study item using
---updating script----
$query = "update STY_REPORT_200501 set std_value='" .
$nenilai . "', std_nis='" . $nenis . "', std_item='" .
$neitem . "', std_entusr='" . $neentusr . "' where
std_item=".$neitem ;
----- end updating script-------
and that the complate way I'm doing it, but when user
click the submit result is like this
---after submiting-----
std_nis std_class std_item std_value
111 1 1 8 -----1st row
111 1 1 8 -----2nd row
111 1 1 8 ------3rd row
111 1 1 8 -----4th row
----- end submitting ----------
so how I had to doit so each row will update base on
it std_item, not make it all as std_item=1 and value
is 8 ?
__________________________________
Yahoo! Mail Mobile
Take Yahoo! Mail with you! Check email on your mobile phone.
http://mobile.yahoo.com/learn/mail
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
